public static DetailsClass[] fn_get_grid_data() //GetData function
{
List <DetailsClass> Detail = new List <DetailsClass>();
DateTime today = DateTime.Today;
string SelectString = "select binid,bin_name,zone_name,ward_name,route_name,vehicle,[Vehicle Type],[Driver ID],Driver,format(convert(date,Date),'dd/MM/yyyy') as Date,status from Mst_Bin_Collection where Date='" + today + "' and status='P' order by DAY(Date) DESC";
SqlConnection cn = new SqlConnection("Data Source=192.168.0.171;Initial Catalog=ACME_IOT;Persist Security Info=True;User ID=sa;Password=asdzxc@987");
SqlCommand cmd = new SqlCommand(SelectString, cn);
cn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtGetData = new DataTable();
da.Fill(dtGetData);
foreach (DataRow dtRow in dtGetData.Rows)
{
DetailsClass DataObj = new DetailsClass();
DataObj.BinId = dtRow["binid"].ToString();
DataObj.BinName = dtRow["bin_name"].ToString();
DataObj.Zone = dtRow["zone_name"].ToString();
DataObj.Ward = dtRow["ward_name"].ToString();
DataObj.Route = dtRow["route_name"].ToString();
DataObj.Vehicle = dtRow["vehicle"].ToString();
DataObj.vtype = dtRow["Vehicle Type"].ToString();
DataObj.did = dtRow["Driver ID"].ToString();
DataObj.dnm = dtRow["Driver"].ToString();
DataObj.Date = dtRow["Date"].ToString();
Detail.Add(DataObj);
}
return(Detail.ToArray());
}
public static DetailsClass[] fn_get_grid_data() //GetData function
{
List <DetailsClass> Detail = new List <DetailsClass>();
DateTime today = DateTime.Today;
//string SelectString = "select distinct Mst_Route_planner.routid,Mst_Route_planner.routeName,Mst_Route_planner.wardid,ward_master.ward_name,Mst_Bin.Zoneid,ZoneName from Mst_Route_planner inner join ward_master on ward_master.ward_id=Mst_Route_planner.wardid inner join Mst_Bin on Mst_Bin.wardid=Mst_Route_planner.wardid";
string SelectString = "select Mst_Route_Planner.routid,routeName,ward_master.ward_name,zone_master.Zone_Name from Mst_Route_planner inner join ward_master on ward_master.ward_id=Mst_Route_planner.wardid inner join zone_master on ward_master.Zone_id=zone_master.Zone_id";
SqlConnection cn = new SqlConnection("Data Source=192.168.0.171;Initial Catalog=ACME_IOT;Persist Security Info=True;User ID=sa;Password=asdzxc@987");
SqlCommand cmd = new SqlCommand(SelectString, cn);
cn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtGetData = new DataTable();
da.Fill(dtGetData);
foreach (DataRow dtRow in dtGetData.Rows)
{
DetailsClass DataObj = new DetailsClass();
DataObj.routid = dtRow["routid"].ToString();
DataObj.routeName = dtRow["routeName"].ToString();
//DataObj.wardid = dtRow["wardid"].ToString();
DataObj.ward_name = dtRow["ward_name"].ToString();
//DataObj.Zoneid = dtRow["Zoneid"].ToString();
DataObj.ZoneName = dtRow["Zone_Name"].ToString();
Detail.Add(DataObj);
}
return(Detail.ToArray());
}
private void Lul()
{
ConnectionClass connectionClass = new ConnectionClass();
DetailsClass details = new DetailsClass();
details.NameDetalClass = "rofl";
_brendName = new List <DetailsClass>();
_brendName.Add(details);
connectionClass.DoWriteDetalClass(_brendName);
}
public static DetailsClass[] GetData(string data) //GetData function
{
List <DetailsClass> Detail = new List <DetailsClass>();
DataTable dt = db.QP("select Title,Description,Price,Product_ID,İmage from PRODUCT where Product_ID='" + data + "'").Tables[0];
foreach (DataRow dtRow in dt.Rows)
{
DetailsClass DataObj = new DetailsClass();
DataObj.Title = dtRow["Title"].ToString();
DataObj.Description = dtRow["Description"].ToString();
DataObj.Price = dtRow["Price"].ToString();
DataObj.Product_ID = dtRow["Product_ID"].ToString();
DataObj.İmage = dtRow["İmage"].ToString();
Detail.Add(DataObj);
}
return(Detail.ToArray());
}
public static DetailsClass[] GetData2(string Data) //GetData function
{
List <DetailsClass> Detail = new List <DetailsClass>();
DataTable dt = db.QP("select * from subproduct where Product_ID=" + Data).Tables[0];
foreach (DataRow dtRow in dt.Rows)
{
DetailsClass DataObj = new DetailsClass();
DataObj.Title = dtRow["Title"].ToString();
//DataObj.Description = dtRow["Description"].ToString();
//DataObj.Price = dtRow["Price"].ToString();
DataObj.Product_ID = dtRow["Product_ID"].ToString();
DataObj.İmage = dtRow["İmage"].ToString();
DataObj.İmageSmall = dtRow["İmageSmall"].ToString();
DataObj.İmageZoom = dtRow["İmageZoom"].ToString();
Detail.Add(DataObj);
}
return(Detail.ToArray());
}
