protected void bindControls()
{
try
{
cls_Carriers obj_carrier = new cls_Carriers();
DataSet ds = new DataSet();
ds = obj_carrier.fn_CarrierLastLoc_Fetch(Convert.ToInt32(Session["role"].ToString()), Convert.ToInt32(Session["fk_CompanyID"].ToString()), Convert.ToInt32(Session["fk_OrgID"].ToString()));
int count = ds.Tables[0].Rows.Count;
int val = Convert.ToInt32(ds.Tables[0].Rows[0]["carrierId"].ToString());
// ds = obj_carrier.fn_CarrierLastLoc_Fetch(Convert.ToInt32(Session["role"].ToString()), Convert.ToInt32(Session["task"].ToString()));
car_listbox.DataSource = ds.Tables[0];
car_listbox.DataTextField = "carrierName";
car_listbox.DataValueField = "carrierId";
car_listbox.DataBind();
car_listbox.SelectedIndex = 0;
}
catch (Exception e)
{
cls_fileHandling fh = new cls_fileHandling();
fh.appendToFile("~/logs/error.txt", DateTime.Now + ": " + e.Message);
fh.appendToFile("~/logs/stackTrace.txt", DateTime.Now + ": " + e.StackTrace);
}
}
public DataSet generateArrayIndex()
{
int[] arr;
int[] fleetarr;
int[] carrierId = new int[200];
string fleetString = string.Empty;
arraycount = 0;
DataTable carrierdt = new DataTable();
DataTable fleetdt = new DataTable();
DataSet ds = new DataSet();
carrierdt.Columns.Add("carrierId");
fleetdt.Columns.Add("carrierId");
arr = car_listbox.GetCheckedIndices();
fleetarr = RadListBoxFleet.GetCheckedIndices();
foreach (int index in fleetarr)
{
fleetdt.Rows.Add(RadListBoxFleet.Items[index].Value);
}
foreach (int index in arr)
{
carrierdt.Rows.Add(car_listbox.Items[index].Value);
}
cls_Carriers obj_carrier = new cls_Carriers();
ds = obj_carrier.fn_fetchLastLocation(carrierdt, fleetdt);
return(ds);
}
protected void BindCarrierData()
{
try
{
cls_Carriers obj_carrier = new cls_Carriers();
DataSet ds = new DataSet();
ds = obj_carrier.fn_CarrierLastLoc_Fetch(Convert.ToInt32(Session["role"].ToString()), Convert.ToInt32(Session["fk_CompanyID"].ToString()), Convert.ToInt32(Session["fk_OrgID"].ToString()));
car_listbox.DataSource = ds;
car_listbox.DataTextField = "carrierName";
car_listbox.DataValueField = "carrierId";
car_listbox.DataBind();
car_listbox.SelectedIndex = 0;
cls_Carriers obj_fleet = new cls_Carriers();
DataSet dsFleet = new DataSet();
dsFleet = obj_fleet.fn_FleetLastLoc_Fetch(Convert.ToInt32(Session["role"].ToString()), Convert.ToInt32(Session["task"].ToString()));
RadListBoxFleet.DataSource = dsFleet;
RadListBoxFleet.DataTextField = "fleetName";
RadListBoxFleet.DataValueField = "fleetID";
RadListBoxFleet.DataBind();
RadListBoxFleet.SelectedIndex = 0;
int count = ds.Tables[0].Rows.Count;
MapLaod(generateArrayIndex());
}
catch (Exception e)
{
cls_fileHandling fh = new cls_fileHandling();
fh.appendToFile("~/logs/error.txt", DateTime.Now + ": " + e.Message);
fh.appendToFile("~/logs/stackTrace.txt", DateTime.Now + ": " + e.StackTrace);
}
}
protected void Timer1_Tick(object sender, EventArgs e)
{
cls_Carriers obj_carrier = new cls_Carriers();
DataSet ds = obj_carrier.fn_fetchLastLocation(getCarrierDt(), null);
PlotOnTimer(ds.Tables[0]);
}
public object getLocation(int vehicleId)
{
cls_Carriers obj_carrier = new cls_Carriers();
DataSet ds = new DataSet();
DataTable carrierdt = new DataTable();
carrierdt.Columns.Add("carrierId");
carrierdt.Rows.Add(vehicleId);
ds = obj_carrier.fn_fetchLastLocation(carrierdt, null);
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
Dictionary <string, object> row;
foreach (DataRow dr in ds.Tables[0].Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in ds.Tables[0].Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
var jsonString = serializer.Serialize(rows);
return(jsonString);
}
protected bool saveRefrencesToUsers(DataTable dt)
{
try
{
int userID = int.Parse(Session["InsertedUserID"].ToString());
cls_Carriers obj = new cls_Carriers();
obj.fn_carrierUsers_ins(dt, userID);
return(true);
}
catch
{
return(false);
}
}
protected void getcurrentlocload()
{
try
{
DataSet ds = new System.Data.DataSet();
cls_Carriers obj_carrier = new cls_Carriers();
ds = obj_carrier.fn_CarrierLastLoc_FetchBY_CarrierID(Convert.ToInt32(ddlcarrier.SelectedItem.Value));
ViewState["cu_lat"] = ds.Tables[0].Rows[0]["latitude"].ToString();
ViewState["cu_long"] = ds.Tables[0].Rows[0]["longitude"].ToString();
ViewState["cu_speed"] = ds.Tables[0].Rows[0]["speed"].ToString();
}
catch (Exception ex)
{
}
}
protected void bindControls()
{
try
{
cls_Carriers obj_carrier = new cls_Carriers();
DataSet ds = new DataSet();
ds = obj_carrier.fn_CarrierLastLoc_Fetch(Convert.ToInt32(Session["role"].ToString()), Convert.ToInt32(Session["fk_CompanyID"].ToString()), Convert.ToInt32(Session["fk_OrgID"].ToString()));
txtVehName.DataSource = ds;
txtVehName.DataTextField = "CarrierName";
txtVehName.DataValueField = "CarrierId";
txtVehName.DataBind();
int count = ds.Tables[0].Rows.Count;
int val = Convert.ToInt32(ds.Tables[0].Rows[0]["carrierId"].ToString());
//ds = obj_carrier.fn_CarrierLastLoc_Fetch(Convert.ToInt32(Session["role"].ToString()), Convert.ToInt32(Session["task"].ToString()));
car_listbox.DataSource = ds.Tables[0];
car_listbox.DataTextField = "carrierName";
car_listbox.DataValueField = "carrierId";
car_listbox.DataBind();
car_listbox.SelectedIndex = 0;
RadListBoxFleet.DataSource = ds.Tables[1];
RadListBoxFleet.DataTextField = "fleetName";
RadListBoxFleet.DataValueField = "fleetID";
RadListBoxFleet.DataBind();
RadListBoxFleet.SelectedIndex = 0;
RadListBoxFleet.Items.Insert(0, new RadListBoxItem("Select All", "-1"));
car_listbox.Items.Insert(0, new RadListBoxItem("Select All", "-1"));
car_listbox.Items[0].BackColor = System.Drawing.Color.LightBlue;
RadListBoxFleet.Items[0].BackColor = System.Drawing.Color.LightBlue;
// count = ds.Tables[0].Rows.Count;
//MapLoad(generateArrayIndex());
// UpdatePanelReplayMap.Update();
}
catch (Exception e)
{
cls_fileHandling fh = new cls_fileHandling();
fh.appendToFile("~/logs/error.txt", DateTime.Now + ": " + e.Message);
fh.appendToFile("~/logs/stackTrace.txt", DateTime.Now + ": " + e.StackTrace);
}
}
protected void BindCarrierData()
{
try
{
cls_Carriers obj_carrier = new cls_Carriers();
DataSet ds = new DataSet();
ds = obj_carrier.fn_CarrierLastLoc_Fetch(Convert.ToInt32(Session["role"].ToString()), Convert.ToInt32(Session["fk_CompanyID"].ToString()), Convert.ToInt32(Session["fk_OrgID"].ToString()));
ddlcarrier.DataSource = ds;
ddlcarrier.DataTextField = "CarrierName";
ddlcarrier.DataValueField = "CarrierId";
ddlcarrier.DataBind();
int count = ds.Tables[0].Rows.Count;
int val = Convert.ToInt32(ds.Tables[0].Rows[0]["carrierId"].ToString());
}
catch (Exception ex)
{
}
}
public object getList()
{
cls_Carriers obj_carrier = new cls_Carriers();
DataSet ds = new DataSet();
ds = obj_carrier.fn_CarrierLastLoc_Fetch(1, 0, 0);
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
Dictionary <string, object> row;
foreach (DataRow dr in ds.Tables[0].Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in ds.Tables[0].Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
var jsonString = serializer.Serialize(rows);
return(jsonString);
}
/*
* void plotTrack(DataSet ds)
* {
* double speed;
* int maxSpeed = 75;
* Artem.Google.UI.GooglePolyline pl = new Artem.Google.UI.GooglePolyline();
* pl.StrokeColor = System.Drawing.Color.Blue;
* pl.StrokeWeight = 5;
* ReplayMap.Markers.Clear();
* if (ds.Tables[0].Rows.Count <= 0)
* {
* }
* else
* {
* DateTime prevTime = (DateTime)ds.Tables[0].Rows[0]["time"];
* double newlat = 0;
* double newlong = 0;
*
* DateTime newtime = DateTime.Now;
* DateTime oldtime = DateTime.Now;
* int cnt = 0;
* int recordCnt = ds.Tables[0].Rows.Count;
* int m = 0;
* while (m < recordCnt)
* {
* speed = (double)ds.Tables[0].Rows[m]["speed"];
* newlat = (double)ds.Tables[0].Rows[m]["latitude"];
* newlong = (double)ds.Tables[0].Rows[m]["longitude"];
* newtime = (DateTime)ds.Tables[0].Rows[m]["time"];
* cnt = 0;
* if (speed <=2)
* {
* while (m+1 < recordCnt)
* {
* if (Math.Round(newlat, 4) == Math.Round((double)ds.Tables[0].Rows[m+!]["latitude"], 4)&&Math.Round(newlong, 4) == Math.Round((double)ds.Tables[0].Rows[m]["longitude"],4))
* {
* m++;
* cnt++;
* }
* else
* {
* break;
* }
* }
* if (cnt < 2)
* {
* double lat = (double)ds.Tables[0].Rows[m]["latitude"];
* double lng = (double)ds.Tables[0].Rows[m]["longitude"];
* string PlateNo = txtVehName.Text;
* string Speed = speed.ToString();
* string Date = ds.Tables[0].Rows[m]["time"].ToString();
* Marker GP1 = new Marker();
* GP1.Position = new LatLng(Convert.ToDouble(lat), Convert.ToDouble(lng));
* ViewState["lat"] = lat;
* ViewState["lng"] = lng;
* GP1.Info = "Plate No : " + PlateNo + "</br>" + "Latitude : " + lat + "</br>" + "Longitude : " + "" + lng + "</br>" + "Speed : " + "" + Speed + "</br>" + "Date & Time : " + Date;
* GP1.Title = newtime.TimeOfDay.ToString(); ;
* GP1.Icon = new MarkerImage().Url = "icons/car_icon3.png";
* ReplayMap.Markers.Add(GP1);
* pl.Path.Add(new LatLng(lat,lng));
* }
* else
* {
* oldtime = (DateTime)ds.Tables[0].Rows[m - 1]["time"];
* string PlateNo = txtVehName.Text;
* string Speed = "0";
* string Date = newtime.ToString();
* Marker GP1 = new Marker();
* GP1.Position = new LatLng(Convert.ToDouble(lat), Convert.ToDouble(lng));
* ViewState["lat"] = lat;
* ViewState["lng"] = lng;
* GP1.Info = "Plate No : " + PlateNo + "</br>" + "Latitude : " + lat + "</br>" + "Longitude : " + "" + lng + "</br>" + "Speed : " + "" + Speed + "</br>" + "Time from:" + newtime + " to:" + oldtime;
* GP1.Title = "Stop from " + newtime.TimeOfDay + " to " + oldtime.TimeOfDay;
* GP1.Icon = new MarkerImage().Url = "icons/car_icon3big.png";
* ReplayMap.Markers.Add(GP1);
* pl.Path.Add(new LatLng(lat, lng));
*
* }
* }
* else if (speed > maxSpeed)
* {
* lat = newlat;
* lng = newlong;
* string PlateNo = txtVehName.Text;
* string Speed = speed.ToString();
* string Date = newtime.ToString();
* Marker GP1 = new Marker();
* GP1.Position = new LatLng(Convert.ToDouble(lat), Convert.ToDouble(lng));
* ViewState["lat"] = lat;
* ViewState["lng"] = lng;
* GP1.Info = "Plate No : " + PlateNo + "</br>" + "Latitude : " + lat + "</br>" + "Longitude : " + "" + lng + "</br>" + "Speed : " + "" + Speed + "</br>" + "Date & Time : " + Date;
* GP1.Title = newtime.TimeOfDay.ToString();
* GP1.Icon = new MarkerImage().Url = "icons/car_icon2.png";
* ReplayMap.Markers.Add(GP1);
* pl.Path.Add(new LatLng(lat, lng));
* }
* else
* {
* string PlateNo = txtVehName.Text;
* string Speed = speed.ToString();
* string Date = newtime.ToString();
* Marker GP1 = new Marker();
* GP1.Position = new LatLng(Convert.ToDouble(lat), Convert.ToDouble(lng));
* ViewState["lat"] = lat;
* ViewState["lng"] = lng;
* GP1.Info = "Plate No : " + PlateNo + "</br>" + "Latitude : " + newlat + "</br>" + "Longitude : " + "" + lng + "</br>" + "Speed : " + "" + Speed + "</br>" + "Date & Time : " + Date;
* GP1.Title = newtime.TimeOfDay.ToString();
* GP1.Icon = new MarkerImage().Url = "icons/car_icon4.png";
* ReplayMap.Markers.Add(GP1);
* pl.Path.Add(new LatLng(lat, lng));
*
* }
* m++;
* }
* ReplayMap.Polylines.Add(pl);
* ReplayMap.Center = new LatLng(Convert.ToDouble(lat), Convert.ToDouble(lng));
* }
*
* }
*/
void liveTrackPlay()
{
if (txtVehName.SelectedItem != null)
{
DataSet ds = new System.Data.DataSet();
cls_Carriers obj_carrier = new cls_Carriers();
string lat;
string lng;
ds = obj_carrier.fn_CarrierMtsLoc_FetchBY_CarrierID(Int32.Parse(txtVehName.SelectedItem.Value), (DateTime)Session["followStartTime"]);
if (ds.Tables[0].Rows.Count == 0)
{
ds = obj_carrier.fn_CarrierLastLoc_FetchBY_CarrierID(Int32.Parse(txtVehName.SelectedItem.Value));
}
LatLng ltlng = new LatLng();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
lat = ds.Tables[0].Rows[i]["latitude"].ToString();
lng = ds.Tables[0].Rows[i]["longitude"].ToString();
string PlateNo = ds.Tables[0].Rows[i]["carrierName"].ToString();
string Speed = ds.Tables[0].Rows[i]["speed"].ToString();
string D1 = ds.Tables[0].Rows[i]["Din1"].ToString();
string Date = ds.Tables[0].Rows[i]["time"].ToString();
Marker GP1 = new Marker();
GP1.Position = new LatLng(Convert.ToDouble(lat), Convert.ToDouble(lng));
GP1.Info = "Plate No : " + PlateNo + "</br>" + "Latitude : " + lat + "</br>" + "Longitude : " + "" + lng + "</br>" + "Speed : " + "" + Speed
+ "</br>" + "Digital Ignition : " + D1 + "</br>" + "Date & Time : " + Date;
GP1.Title = PlateNo;
if (D1 == "1" || Int32.Parse(Speed) > 2)
{
GP1.Icon = new MarkerImage().Url = "icons/car_icon4.png";
}
else
{
GP1.Icon = new MarkerImage().Url = "icons/car_icon3.png";
}
ReplayMap.Markers.Add(GP1);
if (i != 0)
{
Artem.Google.UI.GooglePolyline pl = new Artem.Google.UI.GooglePolyline();
pl.StrokeColor = System.Drawing.Color.Blue;
pl.StrokeWeight = 5;
pl.Path.Add(new LatLng(Convert.ToDouble(lat), Convert.ToDouble(lng)));
pl.Path.Add(ltlng);
ReplayMap.Polylines.Add(pl);
}
ltlng = new LatLng(Convert.ToDouble(lat), Convert.ToDouble(lng));
ReplayMap.Center = (ltlng);
ReplayMap.OverviewMapControlOptions.Opened = true;
}
}
else
{
// Page.ClientScript.RegisterStartupScript(Page.GetType(), "MyKey", "selectError()", true);
//DateBoxError.Text = "Please select a Vehicle to follow!";
liveFollow.Checked = false;
updatePanelControlPanel.Update();
}
}
public DataSet generateArrayIndex()
{
int[] arr;
int[] fleetarr;
int[] carrierId = new int[200];
string fleetString = string.Empty;
arraycount = 0;
DataTable carrierdt = new DataTable();
DataTable fleetdt = new DataTable();
DataSet ds = new DataSet();
carrierdt.Columns.Add("carrierId");
fleetdt.Columns.Add("carrierId");
arr = car_listbox.GetCheckedIndices();
fleetarr = RadListBoxFleet.GetCheckedIndices();
foreach (int index in fleetarr)
{
fleetdt.Rows.Add(RadListBoxFleet.Items[index].Value);
}
foreach (int index in arr)
{
carrierdt.Rows.Add(car_listbox.Items[index].Value);
}
//foreach(int index in fleetarr)
//{
// fleetString=fleetString+RadListBoxFleet.Items[index].Value+",";
//}
//if (fleetString.Length > 0)
//{
// fleetString = fleetString.Substring(0, fleetString.Length - 1);
//}
cls_Carriers obj_carrier = new cls_Carriers();
ds = obj_carrier.fn_fetchLastLocation(carrierdt, fleetdt);
//DataSet ds = new DataSet();
//ds = obj_carrier.Prc_CarrierLastLoc_FetchByString(fleetString);
//foreach (int index in arr)
//{
// string carrier_id = car_listbox.Items[index].Value;
// carrierId[arraycount] = Int32.Parse(car_listbox.Items[index].Value);
// arraycount++;
//}
//for (int k = 0; k < ds.Tables[0].Rows.Count; k++)
//{
// carrierId[arraycount] = (int)ds.Tables[0].Rows[k]["carrierFID"];
// arraycount++;
//}
//string str = generateString(carrierId);
//Session["carrierString"] = str;
//Session["carrierIdArray"] = carrierId;
//return carrierId;
return(ds);
}
protected void getMapLoad(int task)
{
try
{
if (task == 1)
{
cls_Carriers obj_carrier = new cls_Carriers();
int carrier = Convert.ToInt32(ddlcarrier.SelectedItem.Value);
DataTable dt = new DataTable();
dt = obj_carrier.fn_FetchGofenceData(carrier, 1);
Double lat = 0;
Double lng = 0;
int radius = 0;
lat = Convert.ToDouble(dt.Rows[0]["latitude"].ToString());
ViewState["Centerlat"] = lat;
lng = Convert.ToDouble(dt.Rows[0]["longitude"].ToString());
ViewState["centerlng"] = lng;
radius = 1;
ViewState["Centerradius"] = radius;
Page.ClientScript.RegisterStartupScript(Page.GetType(), "MyKey", "initialize('" + lat + "', '" + lng + "', '" + radius + "','" + ViewState["cu_lat"].ToString() + "','" + ViewState["cu_long"].ToString() + "','" + ViewState["cu_speed"] + "','" + ddlcarrier.SelectedItem.Text + "');", true);
//panel_geo.Visible = true;
GeoareaList();
}
else if (task == 2)
{
DataSet ds = new System.Data.DataSet();
cls_Carriers obj_carrier = new cls_Carriers();
ds = obj_carrier.fn_CarrierLastLoc_FetchBY_CarrierID(Convert.ToInt32(ddlcarrier.SelectedItem.Value));
string lat = ds.Tables[0].Rows[0]["latitude"].ToString();
string lng = ds.Tables[0].Rows[0]["longitude"].ToString();
get_latlongrange();
int i = 0;
string newcenter = txtcenter.Text;
string[] newcenterarray = newcenter.Split(',', '(', ')');
foreach (string word1 in newcenterarray)
{
newcenterarray[i] = word1.ToString();
i++;
}
string newcenterlat = newcenterarray[1].ToString();
string newcenterlong = newcenterarray[2].ToString();
ViewState["Centerlat"] = newcenterlat;
ViewState["centerlng"] = newcenterlong;
Page.ClientScript.RegisterStartupScript(Page.GetType(), "MyKey", "initialize('" + newcenterlat + "', '" + newcenterlong + "', '" + txtredius.Text + "','" + ViewState["cu_lat"].ToString() + "','" + ViewState["cu_long"].ToString() + "','" + ViewState["cu_speed"] + "','" + ddlcarrier.SelectedItem.Text + "');", true);
checkGeoArea(lat, lng, DateTime.Now, 0);
}
else if (task == 3)
{
DataSet ds = new System.Data.DataSet();
cls_Carriers obj_carrier = new cls_Carriers();
ds = obj_carrier.fn_CarrierLastLoc_FetchBY_CarrierID(Convert.ToInt32(ddlcarrier.SelectedItem.Value));
string lat = ds.Tables[0].Rows[0]["latitude"].ToString();
string lng = ds.Tables[0].Rows[0]["longitude"].ToString();
get_latlongrange();
int i = 0;
string newcenter = txtcenter.Text;
string[] newcenterarray = newcenter.Split(',', '(', ')');
foreach (string word1 in newcenterarray)
{
newcenterarray[i] = word1.ToString();
i++;
}
string newcenterlat = newcenterarray[1].ToString();
string newcenterlong = newcenterarray[2].ToString();
ViewState["Centerlat"] = newcenterlat;
ViewState["centerlng"] = newcenterlong;
Page.ClientScript.RegisterStartupScript(Page.GetType(), "MyKey", "initialize('" + newcenterlat + "', '" + newcenterlong + "', '" + txtredius.Text + "','" + ViewState["cu_lat"].ToString() + "','" + ViewState["cu_long"].ToString() + "','" + ViewState["cu_speed"] + "','" + ddlcarrier.SelectedItem.Text + "');", true);
}
}
catch (Exception)
{
}
}
