public IActionResult Create(connections connection) { if (HttpContext.Session.GetString("accRole").Equals("Admin") || HttpContext.Session.GetString("accRole").Equals("Technician")) { try { if (connection.Connection_image_thumbnail == null) { ViewBag.Msg = "You must select the connection's image!"; } else if (ModelState.IsValid) { db.connections.Add(connection); db.SaveChanges(); return(RedirectToAction("Index", "Connections")); } else { ViewBag.Msg = "Model State is invalid!"; } return(View(@"~/Views/Admin/connections/Create.cshtml")); } catch (Exception ex) { ModelState.AddModelError("Error: ", ex.Message); } } return(View(@"~/Views/Admin/ErrorPemission.cshtml")); }
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_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_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 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"); }
public ActionResult SetConnectionActive(int connectionId, bool isActive) { connections connection = db.connections.Find(connectionId); if (connection == null) { return(HttpNotFound()); } connection.isActive = isActive; db.SaveChanges(); return(null); }
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 ActionResult Create(StoreModel storeModel) { if (!storeIPOkay(storeModel.store)) { ModelState.AddModelError("store.storeIP", "IP already exists"); } if (storeModel.checkboxRelayModel.Where(x => x.selected).Count() < 1) { ModelState.AddModelError("", "Needs to be connected to a relay"); } if (ModelState.IsValid) { db.store.Add(storeModel.store); db.SaveChanges(); var selectedRelays = storeModel.checkboxRelayModel.Where(x => x.selected); foreach (var selectedRelay in selectedRelays) { connections connection = new connections() { storeID = storeModel.store.storeID, destRelayID = selectedRelay.relayID, isActive = true, weight = selectedRelay.weight }; db.connections.Add(connection); } db.SaveChanges(); return(RedirectToAction("Index", "Store")); } var selectList = from region in db.region select new { regionID = region.regionID, regionColor = region.colors.colorName }; ViewBag.store = new { regionID = new SelectList(selectList, "regionID", "regionColor") }; return(View(storeModel)); }
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 ActionResult Create(RegionStoreRelayModel regionStoreRelay) { if (!storeIPOkay(regionStoreRelay.store)) { ModelState.AddModelError("store.storeIP", "IP already exists"); } if (!relayIPOkay(regionStoreRelay.relay)) { ModelState.AddModelError("relay.relayIP", "IP already exists"); } if (regionStoreRelay.CheckboxGatewayModel.Where(x => x.selected).Count() < 1) { ModelState.AddModelError("", "Needs to be connected to gateway or processing center"); } if (ModelState.IsValid) { region newRegion = new region() { colorID = regionStoreRelay.region.colorID, regionNumber = db.region.Select(x => x.regionID).Max() + 1 }; db.region.Add(newRegion); db.store.Add(regionStoreRelay.store); db.SaveChanges(); relay gatewayRelay = new relay() { isActive = true, isProcessingCenter = false, queueLimit = regionStoreRelay.relay.queueLimit, isGateway = true, relayIP = regionStoreRelay.relay.relayIP, regionID = newRegion.regionID }; db.relay.Add(gatewayRelay); db.SaveChanges(); connections connection = new connections() { storeID = regionStoreRelay.store.storeID, destRelayID = gatewayRelay.relayID, isActive = true, weight = regionStoreRelay.connections.weight }; db.connections.Add(connection); db.SaveChanges(); var selectedRelays = regionStoreRelay.CheckboxGatewayModel.Where(x => x.selected); foreach (var selectedRelay in selectedRelays) { connections connection2 = new connections() { relayID = gatewayRelay.relayID, destRelayID = selectedRelay.relayID, isActive = true, weight = selectedRelay.weight }; db.connections.Add(connection2); } db.SaveChanges(); return(RedirectToAction("Index", "Home")); } //regionStoreRelay.CheckboxGatewayModel = GetGatewayRelays(); var colorInfo = from colors in db.colors select new { colors.colorID }; var colorsUsed = from region in db.region select new { region.colorID }; var temp = from colors in colorInfo.Except(colorsUsed) join colors2 in db.colors on colors.colorID equals colors2.colorID select new { colors2.colorName, colors2.colorID }; ViewBag.region = new { colorID = new SelectList(temp, "colorID", "colorName") }; return(View(regionStoreRelay)); }
public ActionResult Create(RelayModel relayModel) { if (!relayIPOkay(relayModel.relay)) { ModelState.AddModelError("relay.relayIP", "IP already exists"); } if (relayModel.checkboxRelayModel.Where(x => x.selected).Count() <= 0) { ModelState.AddModelError("", "Must select at least one relay connection"); } if (relayModel.checkboxStoreModel.Where(x => x.selected).Count() <= 0) { if (relayModel.checkboxRelayModel.Where(x => x.selected).Count() <= 1) { ModelState.AddModelError("", "Incorrect number of connections"); } } if (ModelState.IsValid) { db.relay.Add(relayModel.relay); db.SaveChanges(); var selectedRelays = relayModel.checkboxRelayModel.Where(x => x.selected); foreach (var selectedRelay in selectedRelays) { connections connection = new connections() { relayID = relayModel.relay.relayID, destRelayID = selectedRelay.relayID, isActive = true, weight = selectedRelay.weight }; db.connections.Add(connection); } var selectedStores = relayModel.checkboxStoreModel.Where(x => x.selected); foreach (var selectedStore in selectedStores) { connections connection2 = new connections() { storeID = selectedStore.storeID, destRelayID = relayModel.relay.relayID, isActive = true, weight = selectedStore.weight }; db.connections.Add(connection2); } db.SaveChanges(); return(RedirectToAction("Index", "Relay")); } //relayModel.checkboxRelayModel = GetCheckboxRelays(relayModel.relay.regionID); //relayModel.checkboxStoreModel = GetCheckboxStores(relayModel.relay.regionID); var selectList = from region in db.region select new { regionID = region.regionID, regionColor = region.colors.colorName }; ViewBag.relay = new { regionID = new SelectList(selectList, "regionID", "regionColor") }; return(View(relayModel)); }
public static MAPS[] ConvertDataTabletoString(string s, string zone, string ward, string type) { List <MAPS> lstMarkers = new List <MAPS>(); DataSet dslocation = new DataSet(); DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); business ob = new business(); DataTable dt1 = new DataTable(); DataSet dsbinid = new DataSet(); connections con = new connections(); map_procedures mp = new map_procedures(); DataSet getPU = new DataSet(); DataSet select = new DataSet(); string jam = string.Empty; DataSet get_PU_zn_ws = 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> >(); DataTable dt12 = new DataTable(); dt.Columns.Add("AreaName"); dt.Columns.Add("lat"); dt.Columns.Add("lon"); dt.Columns.Add("BinId"); dt.Columns.Add("Bin_Type"); dt.Columns.Add("Priority"); if (s == "1") { ds = ob.fn_map_bind(s, zone, ward, type);//all bin bind } else if (s == "2") { ds1 = ob.fn_feeders_bind(s, zone, ward);//only feeders s,zone,ward } else if (s == "3") { getPU = ob.fn_get_PU(s, zone, ward);//only processing units } else { ds = ob.fn_map_bind(s, zone, ward, type); //for binding bins getPU = ob.fn_get_PU(s, zone, ward); //for binding Processing points ds1 = ob.fn_feeders_bind(s, zone, ward); //for binding feeders points } try { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++)//binding bins { DataRow dr = dt.NewRow(); dr["BinId"] = ds.Tables[0].Rows[i]["BinId"].ToString(); dr["AreaName"] = ds.Tables[0].Rows[i]["BinName"].ToString(); dr["lat"] = ds.Tables[0].Rows[i]["Latitude"].ToString(); dr["lon"] = ds.Tables[0].Rows[i]["Longitude"].ToString(); dr["Bin_Type"] = ds.Tables[0].Rows[i]["Type"].ToString(); dr["Priority"] = ds.Tables[0].Rows[i]["Priority"].ToString(); dt.Rows.Add(dr); } } } catch { } try { if (ds1.Tables[0].Rows.Count > 0)//feeders { for (int j = 0; j < ds1.Tables[0].Rows.Count; j++) { DataRow dr1 = dt.NewRow(); dr1["lat"] = ds1.Tables[0].Rows[j]["lat"].ToString(); dr1["lon"] = ds1.Tables[0].Rows[j]["lon"].ToString(); dr1["AreaName"] = ds1.Tables[0].Rows[j]["FeederName"].ToString(); dr1["Bin_Type"] = ds1.Tables[0].Rows[j]["Type"].ToString(); dt.Rows.Add(dr1); } } } catch { } try { if (getPU.Tables[0].Rows.Count > 0)//processing units { for (int k = 0; k < getPU.Tables[0].Rows.Count; k++) { DataRow dr2 = dt.NewRow(); dr2["lat"] = getPU.Tables[0].Rows[k]["lat"].ToString(); dr2["lon"] = getPU.Tables[0].Rows[k]["lon"].ToString(); dr2["AreaName"] = getPU.Tables[0].Rows[k]["name"].ToString(); dr2["Bin_Type"] = getPU.Tables[0].Rows[k]["Type"].ToString(); dt.Rows.Add(dr2); } } } catch { } foreach (DataRow dtrow in dt.Rows) { MAPS objMAPS = new MAPS(); objMAPS.AreaName = dtrow[0].ToString(); objMAPS.lat = dtrow[1].ToString(); objMAPS.lon = dtrow[2].ToString(); //objMAPS.Areaid = dtrow[0].ToString(); objMAPS.Bin_Type = dtrow[4].ToString(); objMAPS.BinId = dtrow[3].ToString(); objMAPS.Priority = dtrow[5].ToString(); lstMarkers.Add(objMAPS); } return(lstMarkers.ToArray()); //return serializer.Serialize(rows); }
public static MAPS[] ConvertDataTabletoString(string s, string zone, string ward, string type, string rid) { List <MAPS> lstMarkers = new List <MAPS>(); DataSet ds = new DataSet(); business ob = new business(); connections con = new connections(); 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("AreaName"); dt.Columns.Add("lat"); dt.Columns.Add("lon"); dt.Columns.Add("BinId"); dt.Columns.Add("Bin_Type"); dt.Columns.Add("Priority"); dt.Columns.Add("routeid"); dt.Columns.Add("status"); try { if (s == "1") { ds = ob.fn_get_bin_routewise(s, zone, ward, type, rid);//all bin bind } } catch { } try { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++)//binding bins { DataRow dr = dt.NewRow(); dr["BinId"] = ds.Tables[0].Rows[i]["BinId"].ToString(); dr["AreaName"] = ds.Tables[0].Rows[i]["BinName"].ToString(); dr["lat"] = ds.Tables[0].Rows[i]["Latitude"].ToString(); dr["lon"] = ds.Tables[0].Rows[i]["Longitude"].ToString(); dr["Bin_Type"] = ds.Tables[0].Rows[i]["Type"].ToString(); dr["Priority"] = ds.Tables[0].Rows[i]["Priority"].ToString(); dr["routeid"] = ds.Tables[0].Rows[i]["routeid"].ToString(); dr["status"] = ds.Tables[0].Rows[i]["status"].ToString(); dt.Rows.Add(dr); } } } catch { } foreach (DataRow dtrow in dt.Rows) { MAPS objMAPS = new MAPS(); objMAPS.AreaName = dtrow[0].ToString(); objMAPS.lat = dtrow[1].ToString(); objMAPS.lon = dtrow[2].ToString(); objMAPS.BinId = dtrow[3].ToString(); objMAPS.Bin_Type = dtrow[4].ToString(); objMAPS.Priority = dtrow[5].ToString(); objMAPS.routeid = dtrow[6].ToString(); objMAPS.status = dtrow[7].ToString(); lstMarkers.Add(objMAPS); } return(lstMarkers.ToArray()); //return serializer.Serialize(rows); }
public static MAPS[] get_routes(string m, string route) { List <MAPS> lstMarkers = new List <MAPS>(); DataSet ds = new DataSet(); business ob = new business(); connections con = new connections(); 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> >(); DataTable dt12 = new DataTable(); dt.Columns.Add("BinName"); dt.Columns.Add("lat"); dt.Columns.Add("lon"); dt.Columns.Add("BinId"); dt.Columns.Add("Bin_Type"); dt.Columns.Add("Priority"); if (m == "1") { ds = ob.fn_get_routes_for_bin(m, route); } try { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++)//binding bins { DataRow dr = dt.NewRow(); dr["BinId"] = ds.Tables[0].Rows[i]["BinId"].ToString(); dr["BinName"] = ds.Tables[0].Rows[i]["BinName"].ToString(); dr["lat"] = ds.Tables[0].Rows[i]["Latitude"].ToString(); dr["lon"] = ds.Tables[0].Rows[i]["Longitude"].ToString(); dr["Bin_Type"] = ds.Tables[0].Rows[i]["Type"].ToString(); dr["Priority"] = ds.Tables[0].Rows[i]["Priority"].ToString(); dt.Rows.Add(dr); } } } catch { } foreach (DataRow dtrow in dt.Rows) { MAPS objMAPS = new MAPS(); objMAPS.BinId = dtrow[3].ToString(); objMAPS.lat = dtrow[1].ToString(); objMAPS.lon = dtrow[2].ToString(); objMAPS.BinName = dtrow[0].ToString(); objMAPS.Type = dtrow[4].ToString(); objMAPS.SPriority = dtrow[5].ToString(); lstMarkers.Add(objMAPS); } return(lstMarkers.ToArray()); }