DotQuery

Tuesday, July 9, 2019

Linq SqlQuery fill SelectListItem by sql normal query in linq

1. Fill into List<SelectListItem> in Linq by normal sql query

sql = "\n select o.Odr_Code Value, o.Odr_No Text ";
sql += "\n from v_Order o left join v_Sales s on o.Odr_Code=s.Odr_Code and o.ICode=s.ICode ";
sql += "\n where o.Pcode='" + du.CSQ(Pcode) +"' ";
sql += "\n group by o.Odr_Code,o.Odr_No ";
sql += "\n having sum(isnull(o.Qty,0)-isnull(s.Qty,0))>0 ";
sql += "\n order by convert(numeric(18),substring(o.Odr_No,2,15)) ";
List<SelectListItem> list = db.Database.SqlQuery<SelectListItem>(sql).ToList();

2. Fill into List<Class> in Linq by normal sql query

public class Order_Remain
{
public string Odr_Code { get; set; }
public string Odr_No { get; set; }
public decimal Qty_Bal { get; set; }
}

sql = "\n select o.Odr_Code , o.Odr_No ";
sql += "\n ,sum(isnull(o.Qty,0)-isnull(s.Qty,0)) Qty_Bal ";
sql += "\n from v_Order o left join v_Sales s on o.Odr_Code=s.Odr_Code and o.ICode=s.ICode ";
sql += "\n where o.Pcode='" + du.CSQ(Pcode) +"' ";
sql += "\n group by o.Odr_Code,o.Odr_No ";
sql += "\n having sum(isnull(o.Qty,0)-isnull(s.Qty,0))>0 ";
sql += "\n order by convert(numeric(18),substring(o.Odr_No,2,15)) ";
var list_ = db.Database.SqlQuery<Order_Remain>(sql).ToList();
var list = (from x in list_
select (new SelectListItem() { Text = x.Odr_No, Value = x.Odr_Code })).ToList();

Monday, July 8, 2019

Download vs2017 professional for offline

1. Download vs2017 for offline

cmd like

c:\ downloads>vs_pro.exe --layout e:\rinkesh\vs2017

Thursday, July 4, 2019

Angular Services in like db connection with $http service

1. Angular Services in like db connection with $http service

Angular User Directive in Angular

1. User Directive (one page use in other page like header footer) in angular

1. Add Reference in js file of js file

Wednesday, July 3, 2019

IONIC Create new project in ionic

Monday, July 1, 2019

Get data in Angular

1. Html

<!DOCTYPE html>
<html ng-app="ApiApp">
<head>
<title></title>
<meta charset="utf-8" />
<script src="scripts/angular.min.js"></script>
</head>
<body ng-controller="ApiCtrl">
<p>Welcome</p>
<p ng-repeat="data in Data">
{{data.id}}-{{data.Name}}-{{data.address}}
</p>
<script type="text/javascript">
var app = angular.module("ApiApp", [])
.controller("ApiCtrl", function ($scope, $http) {
//$http.get("http://localhost:53083/api/data/getdata") applicable
//$http.get("api/data/getdata") applicable
$http.get("/api/data/getdata")
.then(function (apiResponse) {
console.log(apiResponse);
$scope.Data = apiResponse.data;
})
})
</script>
</body>
</html>

2. Web Api Controller

[RoutePrefix("api/data")]
public class DemoApiController : ApiController
{
[Route("getdata")]
public List<info> GetData()
{

var data = new List<info>();
data.Add(new info {id=1,Name="Rinkesh",address="Rupbas",mobile="87987798778" });
data.Add(new info { id = 2, Name = "Kusum", address = "Agra", mobile = "555555555" });
data.Add(new info { id = 3, Name = "Darsika", address = "Agra", mobile = "66666666" });
data.Add(new info { id = 4, Name = "Vihan", address = "Agra", mobile = "88888888888" });
return data;
}
}

3. Model

public class info
{
public int id { get; set; }
public string Name { get; set; }
public string address { get; set; }
public string mobile { get; set; }

}

4. Angular Js File
Angular Js File