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