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