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);
}
public DataSet getSelectedVehicles()
{
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);
}
ds.Tables.Add(carrierdt);
ds.Tables.Add(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 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);
}
}
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);
}
