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);
}
}
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)
{
try
{
DataSet ds = generateArrayIndex();
DataTable dt = new DataTable();
dt = ds.Tables[0];
dt.PrimaryKey = new System.Data.DataColumn[] { dt.Columns[0] };
dt.Merge(ds.Tables[1]);
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
updatePanelDashboardGrid.Update();
//ReplayMap.DisableClear = true;
//int[] carrierId = generateArrayIndex();
MapLoad(ds, updatePanel1, false);
//cls_Carriers obj_carrier = new cls_Carriers();
//DataSet ds = new DataSet();
//ds = obj_carrier.tikerDataFetch(Convert.ToInt32(Session["role"].ToString()), Convert.ToInt32(Session["task"].ToString()), DateTime.Now);
//for (int m = 0; m < ds.Tables[0].Rows.Count; m++)
//{
// TikerContent.Items.Add(new RadListBoxItem(ds.Tables[0].Rows[m]["carrierName"].ToString() + ":" + ds.Tables[0].Rows[m]["feed"].ToString() + " at " + ds.Tables[0].Rows[m]["feedTime"].ToString(), ds.Tables[0].Rows[m]["feedId"].ToString()));
//}
}
catch (Exception ex)
{
cls_fileHandling fh = new cls_fileHandling();
fh.appendToFile("~/logs/error.txt", DateTime.Now + ": " + ex.Message);
fh.appendToFile("~/logs/stackTrace.txt", DateTime.Now + ": " + ex.StackTrace);
}
}
public void create()
{
try
{
DataSet ds = new System.Data.DataSet();
DataSet ds2 = new System.Data.DataSet();
cls_Reports obj_report = new cls_Reports();
obj_report.carrierId = Convert.ToInt32(getSelectedCarrierID());
obj_report.dateStart = dateFrom.SelectedDate.ToString();
obj_report.dateEnd = dateTo.SelectedDate.ToString();
ds = obj_report.fn_Trackcarrier(obj_report);
ds2 = obj_report.fn_CarrierName(obj_report);
string carrierName = ds2.Tables[0].Rows[0]["carrierName"].ToString();
DateTime date = DateTime.Now;
path = "~/KML/" + obj_report.carrierId + " " + date.Year + " " + date.Month + " " + date.Day + " " + date.Hour + " " + date.Minute + " " + date.Second + " " + date.Millisecond + ".kml";
createRequiredPath("~/KML/");
path = ViewState["path"].ToString() + obj_report.carrierId + " " + date.Year + " " + date.Month + " " + date.Day + " " + date.Hour + " " + date.Minute + " " + date.Second + " " + date.Millisecond + ".kml";
Createkml createkml = new Createkml();
createkml.createKmlAdv(ds, path, obj_report.carrierId, carrierName);
createKmz(path);
Uri url = Request.Url;
string temp = url.ToString();
string str = Request.AppRelativeCurrentExecutionFilePath;
str = str.Substring(1);
path = temp.Substring(0, temp.IndexOf(str));
path = path + "/KML/" + obj_report.carrierId + " " + date.Year + " " + date.Month + " " + date.Day + " " + date.Hour + " " + date.Minute + " " + date.Second + " " + date.Millisecond + ".kmz";
Page.ClientScript.RegisterStartupScript(Page.GetType(), "MyKey", "init('" + path + "');", true);
}
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 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 btnLinePath_Click(object sender, EventArgs e)
{
try
{
bool valid = datevalidate();
if (valid == true)
{
createLinePath();
btnentertour.Visible = true;
btnexisttour.Visible = true;
btnpausetour.Visible = true;
btnplaytour.Visible = true;
btnresettour.Visible = true;
}
}
catch (Exception ex)
{
cls_fileHandling fh = new cls_fileHandling();
fh.appendToFile("~/logs/error.txt", DateTime.Now + ": " + ex.Message);
fh.appendToFile("~/logs/stackTrace.txt", DateTime.Now + ": " + ex.StackTrace);
}
}
protected void report_kmTravelledMultiple(cls_Reports rpt)
{
DateTime startdt = Convert.ToDateTime(dateFrom.SelectedDate.ToString(), culturenew); // + " " + ddl_HH.SelectedItem.Text + ":" + ddl_MM.SelectedItem.Text + ":" + ddl_SS.SelectedItem.Text);
DateTime enddt = Convert.ToDateTime(dateTo.SelectedDate.ToString(), culturenew); //+ " " + ddl_HH_end.SelectedItem.Text + ":" + ddl_MM_end.SelectedItem.Text + ":" + ddl_SS_end.SelectedItem.Text);
btnshowchatMultiple.Visible = true;
lblmsgMultiple.Text = "";
try
{
lblRptNameMultiple.Text = "KILOMETER TRAVEL REPORT FOR SELECTED VEHICLES From" + " " + rpt.dateStart + " " + "To" + " " + rpt.dateEnd;
km_table.Columns.Add(new DataColumn("Vehicles/Day"));
DateTime tempstartDate = startdt;
while (tempstartDate < enddt)
{
km_table.Columns.Add(new DataColumn(tempstartDate.Date.ToShortDateString()));
tempstartDate = tempstartDate.AddDays(1);
}
km_table.Columns.Add("Total KMS");
lblKM.Text = "";
DataSet fleet = getSelectedVehicles();
DataSet ds = rpt.fn_prc_KMtravelMultiple(rpt, fleet.Tables[0], fleet.Tables[1]);
double km = 0;
double dayKm = 0;
if (ds.Tables[0].Rows.Count > 1)
{
DataTable carriers = ds.Tables[0].DefaultView.ToTable(true, "carrierFId", "carrierName");
for (int i = 0; i < carriers.Rows.Count; i++)
{
DataRow dr = km_table.NewRow();
tempstartDate = startdt;
DateTime tempEndDate = startdt.AddDays(1);
TimeSpan span = enddt - startdt;
if (span.Days > 1)
{
km = dayKm = calculateKm(ds.Tables[0].Select(string.Format("time > \'{0}\' and time<\'{1}\' and carrierFId={2}", tempstartDate, tempstartDate.AddDays(1).Date, carriers.Rows[i]["carrierFId"]), "time asc"));
dr[tempstartDate.ToShortDateString()] = Math.Round(dayKm, 0);
tempstartDate = tempstartDate.AddDays(1).Date;
while (tempstartDate < enddt)
{
dayKm = calculateKm(ds.Tables[0].Select(string.Format("time > \'{0}\' and time<\'{1}\' and carrierFId={2}", tempstartDate, tempstartDate.AddDays(1).Date, carriers.Rows[i]["carrierFId"]), "time asc"));
dr[tempstartDate.ToShortDateString()] = Math.Round(dayKm, 0);
km = km + dayKm;
tempstartDate = tempstartDate.AddDays(1);
}
}
else
{
km = calculateKm(ds.Tables[0].Select(string.Format("time > \'{0}\' and time<\'{1}\' and carrierFId={2}", startdt, enddt, carriers.Rows[i]["carrierFId"]), "time asc"));
dr[startdt.ToShortDateString()] = Math.Round(km, 0);
}
dr["Vehicles/Day"] = carriers.Rows[i]["carrierName"];
dr["Total KMS"] = Math.Round(km, 0);
km_table.Rows.Add(dr);
}
}
gv_ReportMultiple.DataSource = km_table;
// gv_ReportMultiple.Rebind();
ViewState["tbl_KMMultiple"] = km_table;
//lblKM.Text = "Total Kilometer Travel is:" + " " + Math.Round(km, 0) + " KM";
//lblKM.Visible = true;
}
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);
}
}
