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()); }