public void Edit_driver_details(string d_id) { bt_sbt.Visible = false; udpt.Visible = true; txt_licence.ReadOnly = true; ds = con.FN_ExecuteQuerySingle("select name,licence_n,p_address,r_address,email,mobile,format(convert(date,dob),'dd-MM-yyyy') as dob ,typeOFveh from MSt_driver_Reg where licence_n='" + d_id + "'"); string name = ds.Tables[0].Rows[0]["name"].ToString(); txt_name.Text = name; txt_licence.Text = ds.Tables[0].Rows[0]["licence_n"].ToString(); txt_p_add.Text = ds.Tables[0].Rows[0]["p_address"].ToString(); txt_c_add.Text = ds.Tables[0].Rows[0]["r_address"].ToString(); txt_email.Text = ds.Tables[0].Rows[0]["email"].ToString(); // txt_licence.Text = ds.Tables[0].Rows[0]["licence_n"].ToString(); txt_mbl.Text = ds.Tables[0].Rows[0]["mobile"].ToString(); txt_dob.Text = ds.Tables[0].Rows[0]["dob"].ToString(); string veh = ds.Tables[0].Rows[0]["typeOFveh"].ToString(); string vh = "Previous Select:- " + " " + veh.Replace("_", ","); if (veh != "") { lbl_msg.Visible = true; lbl_msg.Text = vh; } //string v1 = veh.Split("_".ToCharArray())[0]; //string v2 = veh.Split("_".ToCharArray())[1]; //string v3 = veh.Split("_".ToCharArray())[2]; //if (v1 == "Dumper") //{ // //chk_veh.ThreeState= true; //} }
protected void Ddlword_SelectedIndexChanged(object sender, EventArgs e) { DataSet ds = new DataSet(); string zone = Ddlzone.SelectedValue.ToString(); string wadrid = Ddlword.SelectedValue.ToString(); string strsql = "proc_select_feeders_wardwise '" + zone + "','" + wadrid + "'"; ds = con.FN_ExecuteQuerySingle(strsql); GridView1.DataSource = ds; GridView1.DataBind(); }
protected void BIND_ddl_zone() { DataSet ddl_z = con.FN_ExecuteQuerySingle("select *from zone_master"); ddl_zone.DataSource = ddl_z; ddl_zone.DataTextField = "Zone_Name"; ddl_zone.DataValueField = "Zone_id"; ddl_zone.DataBind(); ddl_zone.Items.Add(new ListItem("--Select--", "0")); ddl_zone.SelectedValue = "0"; }
public void BindWards(string zone) //created By Gajendra Singh { DataSet ds = new DataSet(); string strsql = "BindWardonSelect_Zone '" + zone + "'"; ds = con.FN_ExecuteQuerySingle(strsql); Ddlword.DataSource = ds; Ddlword.DataTextField = "ward_name"; Ddlword.DataValueField = "ward_id"; Ddlword.DataBind(); Ddlword.Items.Add(new ListItem("--Select--", "0")); Ddlword.SelectedValue = "0"; }
public static string fn_change_routesss(string binid, string binName, string lat, string lon, string zone, string ward, string rid) { DataSet ds = new DataSet(); connections con = new connections(); DateTime today = DateTime.Today; DataSet type = new DataSet(); type = con.FN_ExecuteQuerySingle("select Type,Priority from Mst_Bin where BinId='" + binid + "'"); string typ = type.Tables[0].Rows[0]["Type"].ToString(); string prior = type.Tables[0].Rows[0]["Priority"].ToString(); ds = con.FN_ExecuteQuerySingle("FN_change_route_rt_proc" + "'" + binid + "','" + binName + "','" + lat + "','" + lon + "','" + typ + "','" + prior + "','" + zone + "','" + ward + "','" + rid + "','" + today + "'"); return("s"); }
protected void submit_Click(object sender, EventArgs e) { if ((Uid.Value != "" || Uid.Value != null) && (pass.Value != "" || pass.Value != null)) { try { DataSet ds = new DataSet(); ds = con.FN_ExecuteQuerySingle("select * from MST_USER where username='******' and userpassword='******'");// and usertype='"++ if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["usertype"].ToString() == "A") { Session["uid"] = Uid.Value; Session["type"] = ds.Tables[0].Rows[0]["usertype"].ToString(); string sest = Session["type"].ToString(); Response.Redirect("Home_page.aspx");//cityid=" + ds.Tables[0].Rows[0]["cityid"].ToString() } if (ds.Tables[0].Rows[0]["usertype"].ToString() == "U") { Session["uid"] = Uid.Value; Session["type"] = ds.Tables[0].Rows[0]["usertype"].ToString(); string sess = Session["type"].ToString(); Response.Redirect("Home_page.aspx"); } } else { MessageBox.Show("User Does not Exist!!"); } } catch { } } }
public static string fn_assignment(string binid, string lat, string lon, string rid) { DataSet assign = new DataSet(); connections ob = new connections(); assign = ob.FN_ExecuteQuerySingle("update Mst_Bin set routeid='" + rid + "',Latitude='" + lat + "' ,Longitude='" + lon + "' where BinId='" + binid + "'"); return("0"); }
public static string fn_Select_bins(string binid) { DataSet ds = new DataSet(); connections con = new connections(); ds = con.FN_ExecuteQuerySingle("select * from Mst_Bin where BinId='" + binid + "' and StatusB='A'"); return("0"); }
public static string fn_del_bin(string routeid) { DataSet ds = new DataSet(); connections con = new connections(); ds = con.FN_ExecuteQuerySingle("delete from Mst_Route_Planner where routid='" + routeid + "'"); return("0"); }
public static string fn_del_bin(string binid) { DataSet ds = new DataSet(); business ob = new business(); connections con = new connections(); ds = con.FN_ExecuteQuerySingle("update Mst_Bin_Collection set status='D' where binid='" + binid + "'"); return("0"); }
public MAPS[] init_get_car() { List <MAPS> lstMarkers = new List <MAPS>(); connections con = new connections(); DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); DataTable dt = new DataTable(); System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >(); dt.Columns.Add("lat"); dt.Columns.Add("lon"); dt.Columns.Add("type"); ds1 = con.FN_ExecuteQuerySingle("select lat,lon from Car_LAT_LON"); if (ds1.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { DataRow dr = dt.NewRow(); dr["lat"] = ds1.Tables[0].Rows[i]["lat"].ToString(); dr["lon"] = ds1.Tables[0].Rows[i]["lon"].ToString(); dt.Rows.Add(dr); } } else { DataRow dr = dt.NewRow(); dr["lat"] = "23.235846"; dr["lon"] = "77.3980373"; dr["type"] = "D"; dt.Rows.Add(dr); } foreach (DataRow dtrow in dt.Rows) { MAPS objMAPS = new MAPS(); objMAPS.lat = dtrow[0].ToString(); objMAPS.lon = dtrow[1].ToString(); objMAPS.type = dtrow[2].ToString(); lstMarkers.Add(objMAPS); } return(lstMarkers.ToArray()); }
public MAPS[] fn_get_car(string lat, string lon) { List <MAPS> lstMarkers = new List <MAPS>(); connections con = new connections(); DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); DataTable dt = new DataTable(); System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >(); dt.Columns.Add("lat"); dt.Columns.Add("lon"); ds = con.FN_ExecuteQuerySingle("insert into Car_LAT_LON (lat,lon) values('" + lat + "','" + lon + "')"); ds1 = con.FN_ExecuteQuerySingle("select lat,lon from Car_LAT_LON"); if (ds1.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { DataRow dr = dt.NewRow(); dr["lat"] = ds1.Tables[0].Rows[i]["lat"].ToString(); dr["lon"] = ds1.Tables[0].Rows[i]["lon"].ToString(); dt.Rows.Add(dr); } } foreach (DataRow dtrow in dt.Rows) { MAPS objMAPS = new MAPS(); objMAPS.lat = dtrow[0].ToString(); objMAPS.lon = dtrow[1].ToString(); lstMarkers.Add(objMAPS); } return(lstMarkers.ToArray()); }
public static string fn_insert_routes(string ward, string route) { connections con = new connections(); DataSet ds = new DataSet(); try { ds = con.FN_ExecuteQuerySingle("INERT_ROUTE_proc" + "'" + ward + "','" + route + "'"); string msg = ds.Tables[0].Rows[0]["msg"].ToString(); return(msg); } catch { return("0"); } }
public static string fn_Schedule_bins_(string mar, string veh, string vtype, string driverID, string dname) { DateTime today = DateTime.Today; DataSet dm = new DataSet(); DataSet ds = new DataSet(); connections con = new connections(); try { string[] slice = mar.Split(','); for (int ij = 0; ij < slice.Length; ij++) { DataSet check = new DataSet(); //check = con.FN_ExecuteQuerySingle("Fn_check_proc_"+"'" + slice[ij] + "'"); dm = con.FN_ExecuteQuerySingle("select * from Mst_Bin where BinId='" + slice[ij] + "'"); string bin_name = dm.Tables[0].Rows[0]["BinName"].ToString(); string z_id = dm.Tables[0].Rows[0]["Zoneid"].ToString(); string w_id = dm.Tables[0].Rows[0]["wardid"].ToString(); string r_id = dm.Tables[0].Rows[0]["routeid"].ToString(); dm = con.FN_ExecuteQuerySingle("select Zone_Name from zone_master where Zone_id='" + z_id + "'"); string z_nm = dm.Tables[0].Rows[0]["Zone_Name"].ToString(); dm = con.FN_ExecuteQuerySingle("select ward_name from ward_master where ward_id='" + w_id + "'"); string w_nm = dm.Tables[0].Rows[0]["ward_name"].ToString(); dm = con.FN_ExecuteQuerySingle("select routeName from Mst_Route_planner where routid='" + r_id + "'"); string r_name = dm.Tables[0].Rows[0]["routeName"].ToString(); dm = con.FN_ExecuteQuerySingle("select DriverName from Mst_Drivers where DriverID='" + driverID + "'"); string drivernm = dm.Tables[0].Rows[0]["DriverName"].ToString(); dm = con.FN_ExecuteQuerySingle("select vehicle_type from Mst_Vehicles where [vehicle_num]='" + veh + "'"); string vh = dm.Tables[0].Rows[0]["vehicle_type"].ToString(); //dm=con.FN_ExecuteQuerySingle("select vehicle_num from Mst_Vehicles where routid='"+route+"'"); ds = con.FN_ExecuteQuerySingle("insert into Mst_Bin_Collection (binid,bin_name,zone_name,ward_name,route_name,vehicle,[Vehicle Type],[Driver ID],Driver,Date,status) values('" + slice[ij] + "','" + bin_name + "','" + z_nm + "','" + w_nm + "','" + r_name + "','" + veh + "','" + vh + "','" + driverID + "','" + drivernm + "','" + today + "','P')"); } } catch { } return("0"); }
public void bind_grid_vehicle() { ds = con.FN_ExecuteQuerySingle("select vehicle_num,vehicle_type from Mst_Vehicles"); grid_vehicle.DataSource = ds; grid_vehicle.DataBind(); }
public string zonewstable(string zoneid) { string returnvalue = ""; ds = con.FN_ExecuteQuerySingle("FN_select_policy" + "'" + zoneid + "'"); foreach (DataTable dt in ds.Tables) { returnvalue = returnvalue + DataTableToJSONWithStringBuilder(dt); } return(returnvalue); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ds = ob.fn_get_z_name(); ddlZone.DataTextField = "Zone_Name"; ddlZone.DataValueField = "Zone_id"; ddlZone.DataSource = ds; ddlZone.DataBind(); ddlZone.Items.Add(new ListItem("--Select--", "0")); ddlZone.SelectedValue = "0"; ds = con.FN_ExecuteQuerySingle(" Select *,CONVERT(VARCHAR(10),allotmentDT,103)as date from Mst_Driver_Vehicle_Allotment order by AllotmentLongDT desc"); if (ds.Tables[0].Rows.Count > 0) { grdDefault.DataSource = ds; grdDefault.DataBind(); } else { grdDefault.DataSource = null; grdDefault.DataBind(); } } dvgrvDetails.Visible = false; }
public void BindGrid_Driver() { ds = con.FN_ExecuteQuerySingle("select name,licence_n,p_address,r_address,email,mobile,format(convert(date,dob),'dd-MM-yyyy') as dob ,typeOFveh from MSt_driver_Reg"); grdDriver.DataSource = ds; grdDriver.DataBind(); }