public void GetVehicleTariffInfoByID(int V_TrfID)
{
transportdata = new TransportData();
DS = transportdata.GetVehicleTariffInfoByID(V_TrfID);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
dpModelNo.ClearSelection();
if (dpModelNo.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["tr_model_Id"]).ToString()) != null)
{
dpModelNo.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["tr_model_Id"]).ToString()).Selected = true;
}
dpSelectOption.ClearSelection();
if (dpSelectOption.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["tr_option"]).ToString()) != null)
{
dpSelectOption.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["tr_option"]).ToString()).Selected = true;
}
txtTariffamt.Text = string.IsNullOrEmpty((Convert.ToDecimal(DS.Tables[0].Rows[0]["Amount"]).ToString("#.##"))) ? string.Empty : (Convert.ToDecimal(DS.Tables[0].Rows[0]["Amount"]).ToString("#.##"));
dpIsActive.ClearSelection();
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "True")
{
dpIsActive.Items.FindByValue("1").Selected = true;
}
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "False")
{
dpIsActive.Items.FindByValue("2").Selected = true;
}
}
}
public void GetJOBCardInfoByID(int ID)
{
transportdata = new TransportData();
DS = transportdata.GetJOBCardInfoByID(ID);
ClearTextBox();
lblShowMessage.Text = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS))
{
txtOutKM.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["StartKm"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["StartKm"].ToString();
txtInKM.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["EndKm"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["EndKm"].ToString();
txtVOpId.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["VOp"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["VOp"].ToString();
txtInDate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["EndDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["EndDate"].ToString();
txtOutDate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["StartDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["StartDate"].ToString();
txtOutTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["StartTime"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["StartTime"].ToString();
txtInTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["EndTime"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["EndTime"].ToString();
txtSalesMan.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Salesman"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Salesman"].ToString();
txtDriver.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Driver"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Driver"].ToString();
txtRunKM.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TotalKm"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TotalKm"].ToString();
txtDieselLtr.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["FuelLtr"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["FuelLtr"].ToString();
txtAmt.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["FuelAmount"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["FuelAmount"].ToString();
txtRouteId.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TransportRoute"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TransportRoute"].ToString();
}
if (Comman.Comman.IsDataSetEmpty(DS))
{
lblShowMessage.Text = "Operation Not Completed yet ";
}
}
public void GetTransportModelInfoByID(int trVRMID)
{
transportdata = new TransportData();
DS = transportdata.GetVehicleRouteMapInfoByID(trVRMID);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
dpVehicleNo.ClearSelection();
if (dpVehicleNo.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["TM_Id"]).ToString()) != null)
{
dpVehicleNo.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["TM_Id"]).ToString()).Selected = true;
}
dproute.ClearSelection();
if (dproute.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["RouteID"]).ToString()) != null)
{
dproute.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["RouteID"]).ToString()).Selected = true;
}
dpIsActive.ClearSelection();
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "True")
{
dpIsActive.Items.FindByValue("1").Selected = true;
}
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "False")
{
dpIsActive.Items.FindByValue("2").Selected = true;
}
}
}
public void GetTransportOperationInfoByID(int Tr_FuelID)
{
transportdata = new TransportData();
DS = transportdata.GetFuelPumpDetailsInfoByID(Tr_FuelID);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
dpIsActive.ClearSelection();
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "True")
{
dpIsActive.Items.FindByValue("1").Selected = true;
}
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "False")
{
dpIsActive.Items.FindByValue("2").Selected = true;
}
//txtBata.Text = string.IsNullOrEmpty((Convert.ToDecimal(DS.Tables[0].Rows[0]["Bata"]).ToString("#.##"))) ? string.Empty : (Convert.ToDecimal(DS.Tables[0].Rows[0]["Bata"]).ToString("#.##"));
if (DS.Tables[0].Rows[0]["contractstartdate"].ToString() == "")
{
txtcontractstartdate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["contractstartdate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["contractstartdate"].ToString();
}
else
{
string startdate = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["contractstartdate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["contractstartdate"].ToString();
//sky
DateTime date2 = Convert.ToDateTime(startdate, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
txtcontractstartdate.Text = (Convert.ToDateTime(date2).ToString("yyyy-MM-dd"));
}
if (DS.Tables[0].Rows[0]["contractenddate"].ToString() == "")
{
txtcontractenddate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["contractenddate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["contractenddate"].ToString();
}
else
{
string startdate = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["contractenddate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["contractenddate"].ToString();
//sky
DateTime date2 = Convert.ToDateTime(startdate, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
txtcontractenddate.Text = (Convert.ToDateTime(date2).ToString("yyyy-MM-dd"));
}
dproute.ClearSelection();
if (dproute.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["routeId"]).ToString()) != null)
{
dproute.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["routeId"]).ToString()).Selected = true;
}
dpfuelcompany.ClearSelection();
if (dpfuelcompany.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["FuelCompanyId"]).ToString()) != null)
{
dpfuelcompany.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["FuelCompanyId"]).ToString()).Selected = true;
}
txtfuelpumpname.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["fuelpumpname"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["fuelpumpname"].ToString();
txtpumpaddress.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["pumpaddress"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["pumpaddress"].ToString();
txtregistrationno.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["registrationno"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["registrationno"].ToString();
txtcontractamt.Text = string.IsNullOrEmpty((Convert.ToDecimal(DS.Tables[0].Rows[0]["contractamt"]).ToString("#.##"))) ? string.Empty : (Convert.ToDecimal(DS.Tables[0].Rows[0]["contractamt"]).ToString("#.##"));
}
}
private static void ReceiveMessage(TransportData data)
{
if (data.type == TransportDataType.CHAT_MESSAGE)
{
var message = JsonConvert.DeserializeObject <Message>(data.data);
Console.WriteLine(message.message);
}
}
private void ReceiveMessage(TransportData data)
{
if (data.type == TransportDataType.CHAT_MESSAGE)
{
var message = Message.FromJson(data.data);
SendMessageToAllClients(message.message);
}
}
public void DeleteMapbyID(int ID)
{
transportdata = new TransportData();
transport = new Transports();
transport.ID = Convert.ToInt32(ID);
transport.TM_Id = 0;
transport.TM_Id = Convert.ToInt32(dpVehicleNo.SelectedItem.Value);
transport.insuranceamt = Convert.ToDouble(txtVehicleInsuraceAmt.Text);
transport.CreatedBy = GlobalInfo.Userid;
//if (dpIsActive.SelectedItem.Value == "1")
//{
transport.IsActive = true;
//}
//else if (dpIsActive.SelectedItem.Text == "2")
//{
// transport.IsActive = false;
//}
//DateTime time = DateTime.Parse(string.Format("{0}:{1}:{2} {3}", TimeSelector1.Hour, TimeSelector1.Minute, TimeSelector1.Second, TimeSelector1.AmPm));
////product.IsActive = true;
//time.ToString();
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.ModifiedBy = GlobalInfo.Userid;
transport.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
transport.flag = "Delete";
int Result = 0;
Result = transportdata.AddVehicleInsuanceDetailsInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Vehicle Insurance Deleted Successfully";
ClearTextBox();
BindVehicleOperationInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnClick_btnAddTypeID(object sender, EventArgs e)
{
if (Page.IsValid)
{
transportdata = new TransportData();
transport = new Transports();
transport.trModelID = 0;
transport.trModelName = string.IsNullOrEmpty(txtModel.Text.ToString()) ? string.Empty : Convert.ToString(txtModel.Text);
transport.trBrandID = Convert.ToInt32(dpBrand.SelectedItem.Value);
transport.CreatedBy = GlobalInfo.Userid;
if (dpIsActive.SelectedItem.Value == "1")
{
transport.IsActive = true;
}
else if (dpIsActive.SelectedItem.Text == "2")
{
transport.IsActive = false;
}
//product.IsActive = true;
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.ModifiedBy = GlobalInfo.Userid;
transport.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
transport.flag = "Insert";
int Result = 0;
Result = transportdata.AddTransportModelInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Transport Model Add Successfully";
ClearTextBox();
BindTransportModelInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
if (Result == -2627)
{
lblwarning.Text = "Data Already Exists";
}
else
{
lblwarning.Text = "Please Contact to Site Admin";
}
pnlError.Update();
}
}
}
protected void btnClick_btnAddConfig(object sender, EventArgs e)
{
transportdata = new TransportData();
transport = new Transports();
transport.ID = 0;
transport.configname = dpConfigName.SelectedItem.Text.ToString();
transport.configkey = dpConfigkey.SelectedItem.Text.ToString();
transport.configvalue = string.IsNullOrEmpty(txtConfigvalue.Text.ToString()) ? string.Empty : Convert.ToString(txtConfigvalue.Text);
transport.CreatedBy = GlobalInfo.Userid;
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.ModifiedBy = GlobalInfo.Userid;
transport.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
if (dpIsActive.SelectedItem.Value == "1")
{
transport.IsActive = true;
}
if (dpIsActive.SelectedItem.Value == "2")
{
transport.IsActive = false;
}
transport.flag = "Insert";
int Result = 0;
Result = transportdata.AddConfigInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Transport Config Add Successfully";
ClearTextBox();
GetConfigInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
if (Result == -2627)
{
lblwarning.Text = "Data Already Exists";
}
else
{
lblwarning.Text = "Please Contact to Site Admin";
}
pnlError.Update();
}
}
public void SendMessage(string message)
{
var newMessage = new Message()
{
message = message
};
var td = new TransportData(newMessage.ToJson(), TransportDataType.CHAT_MESSAGE);
SendData(JsonConvert.SerializeObject(td));
}
public void DeleteMapbyID(int VOp)
{
transportdata = new TransportData();
transport = new Transports();
transport.VOp = Convert.ToInt32(VOp);
transport.TM_Id = 0;
transport.StartDate = txtStartDate.Text;
transport.StartTime = txtStartTime.Text;
transport.RouteID = 0;
transport.StartKm = 0;
transport.EndKm = 0;
transport.FirstDriver = 0;
transport.SecondDriver = 0;
transport.operationtype = 0;
transport.bata = 0;
transport.tollpaid = 0;
transport.CreatedBy = GlobalInfo.Userid;
transport.IsActive = true;
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.ModifiedBy = GlobalInfo.Userid;
transport.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
transport.SalesmanId = Convert.ToInt32(dpSalesman.SelectedItem.Value);
transport.SecondSalesmanId = Convert.ToInt32(dpSecondSalesmanId.SelectedItem.Value);
transport.flag = "Delete";
int Result = 0;
Result = transportdata.AddVehicleOperationInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Vehicle Out Operation Deleted Successfully";
ClearTextBox();
BindVehicleOperationInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
public void GetVehiclePUCInfoByID(int ID)
{
transportdata = new TransportData();
DS = transportdata.GetVehiclePUCInfoByID(ID);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
dpVehicleNo.ClearSelection();
if (dpVehicleNo.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["TM_Id"]).ToString()) != null)
{
dpVehicleNo.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["TM_Id"]).ToString()).Selected = true;
}
dpIsActive.ClearSelection();
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "True")
{
dpIsActive.Items.FindByValue("1").Selected = true;
}
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "False")
{
dpIsActive.Items.FindByValue("2").Selected = true;
}
//txtBata.Text = string.IsNullOrEmpty((Convert.ToDecimal(DS.Tables[0].Rows[0]["Bata"]).ToString("#.##"))) ? string.Empty : (Convert.ToDecimal(DS.Tables[0].Rows[0]["Bata"]).ToString("#.##"));
if (DS.Tables[0].Rows[0]["PUCDate"].ToString() == "")
{
txtPucStartDate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["PUCDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["PUCDate"].ToString();
}
else
{
string startdate = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["PUCDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["PUCDate"].ToString();
//sky
DateTime date2 = Convert.ToDateTime(startdate, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
txtPucStartDate.Text = (Convert.ToDateTime(date2).ToString("yyyy-MM-dd"));
}
if (DS.Tables[0].Rows[0]["NextPucDate"].ToString() == "")
{
txtPUCEndDate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["NextPucDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["NextPucDate"].ToString();
}
else
{
string startdate = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["NextPucDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["NextPucDate"].ToString();
//sky
DateTime date2 = Convert.ToDateTime(startdate, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
txtPUCEndDate.Text = (Convert.ToDateTime(date2).ToString("yyyy-MM-dd"));
}
txtPUCAmt.Text = string.IsNullOrEmpty(Convert.ToDouble(DS.Tables[0].Rows[0]["PucAmt"]).ToString("#.##")) ? string.Empty : (Convert.ToDouble(DS.Tables[0].Rows[0]["PucAmt"]).ToString("#.##"));
}
}
protected void btnClick_btnupdateVehicleOperation(object sender, EventArgs e)
{
if (Page.IsValid)
{
transportdata = new TransportData();
transport = new Transports();
transport.VOp = string.IsNullOrEmpty(hfvoperationId.Value) ? 0 : Convert.ToInt32(hfvoperationId.Value);
transport.dispatchId = string.IsNullOrEmpty(lblDispatchId.Text) ? 0 : Convert.ToInt32(lblDispatchId.Text);
transport.StartDate = string.IsNullOrEmpty(txtStartDate.Text) ? string.Empty : (Convert.ToDateTime(txtStartDate.Text)).ToString("dd-MM-yyyy");
transport.StartTime = string.IsNullOrEmpty(txtStartTime.Text) ? string.Empty : (Convert.ToDateTime(txtStartTime.Text)).ToString("HH:mm");
transport.scheduleOuttime = string.IsNullOrEmpty(txtSchedueOutTime.Text) ? string.Empty : (Convert.ToDateTime(txtSchedueOutTime.Text)).ToString("HH:mm");
transport.scheduleIntime = string.IsNullOrEmpty(txtScheduleEndTime.Text) ? string.Empty : (Convert.ToDateTime(txtScheduleEndTime.Text)).ToString("HH:mm");
transport.StartKm = string.IsNullOrEmpty(txtStartKm.Text) ? 0 : Convert.ToDecimal(txtStartKm.Text);
transport.bata = string.IsNullOrEmpty(txtBata.Text) ? 0 : Convert.ToDecimal(txtBata.Text);
transport.salesbata = string.IsNullOrEmpty(txtSalesBata.Text) ? 0 : Convert.ToDecimal(txtSalesBata.Text);
transport.operationtype = Convert.ToInt32(dpOperations.SelectedItem.Value);
transport.FirstDriver = Convert.ToInt32(dpDriver.SelectedItem.Value);
transport.SecondDriver = Convert.ToInt32(dpDriver2.SelectedItem.Value);
transport.SalesmanId = Convert.ToInt32(dpSalesman.SelectedItem.Value);
transport.SecondSalesmanId = Convert.ToInt32(dpSecondSalesmanId.SelectedItem.Value);
transport.CreatedBy = GlobalInfo.Userid;
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.ModifiedBy = GlobalInfo.Userid;
transport.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
transport.IsActive = true;
transport.flag = "Add";
int Result = 0;
Result = transportdata.AddVehicleProductOutOperationInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Vehicle Operation Updated Successfully";
ClearTextBox();
BindVehicleOperationInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
btnupdateVehicleOperation.Visible = false;
btnAddVehicleOperation.Visible = true;
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
}
/// <summary>
/// Constructs the Packetizer with the specified transport
/// and the packet size.
/// </summary>
/// <param name="transport">Transport to send data</param>
/// <param name="maxPktSize">the maximum packet size that will be accepted.
/// Must be >= 0. If maxPktSize == 0, the default will be used.</param>
private Packetizer(TransportData transport, int maxPktSize)
{
if (maxPktSize < 0)
{
throw new ArgumentOutOfRangeException("maxPktSize < 0");
}
this.transport = transport;
this.maxPktSize = maxPktSize;
transport.SetSession(this);
}
protected void btnClick_btnupdateVehicletariff(object sender, EventArgs e)
{
if (Page.IsValid)
{
// My credential check code
transportdata = new TransportData();
transport = new Transports();
transport.V_TrfID = string.IsNullOrEmpty(hfvmapId.Value) ? 0 : Convert.ToInt32(hfvmapId.Value);
transport.trModelID = Convert.ToInt32(dpModelNo.SelectedItem.Value);;
transport.troption = Convert.ToInt32(dpSelectOption.SelectedItem.Value);
transport.tariffamt = Convert.ToDouble(txtTariffamt.Text);
transport.CreatedBy = GlobalInfo.Userid;
if (dpIsActive.SelectedItem.Value == "1")
{
transport.IsActive = true;
}
else if (dpIsActive.SelectedItem.Text == "2")
{
transport.IsActive = false;
}
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.ModifiedBy = GlobalInfo.Userid;
transport.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
transport.flag = "Update";
int Result = 0;
Result = transportdata.AddVehicleTariffInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Vehicle Tariff Updated Successfully";
ClearTextBox();
BindVehicleTariffInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
btnAddVehicleTariff.Visible = true;
btnupdateVehicletariff.Visible = false;
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
}
protected void btnClick_btnAddBrandID(object sender, EventArgs e)
{
if (Page.IsValid)
{
// My credential check code
transportdata = new TransportData();
transport = new Transports();
transport.trBrandID = 0;
transport.trBrandName = string.IsNullOrEmpty(txtBrand.Text.ToString()) ? string.Empty : Convert.ToString(txtBrand.Text);
transport.CreatedBy = GlobalInfo.Userid;
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.ModifiedBy = GlobalInfo.Userid;
transport.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
if (dpIsActive.SelectedItem.Value == "1")
{
transport.IsActive = true;
}
if (dpIsActive.SelectedItem.Value == "2")
{
transport.IsActive = false;
}
transport.flag = "Insert";
int Result = 0;
Result = transportdata.AddTransportBrandInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Transport Brand Add Successfully";
ClearTextBox();
GetTransportBrandInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
}
public void BindVehicleOperationInfo()
{
transportdata = new TransportData();
DataSet DS = new DataSet();
DS = transportdata.GetFuelPumpDetailsInfo();
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpvehiclefueldetailsInfo.DataSource = DS;
rpvehiclefueldetailsInfo.DataBind();
}
}
public void GetScheduleInfo()
{
transportdata = new TransportData();
DataSet DS = new DataSet();
DS = transportdata.GetScheduleInfo();
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpSchedulelist.DataSource = DS;
rpSchedulelist.DataBind();
}
}
public void BindVehicleTariffInfo()
{
transportdata = new TransportData();
DataSet DS = new DataSet();
DS = transportdata.GetVehicleTariffInfo();
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpvehicleroutemapInfo.DataSource = DS;
rpvehicleroutemapInfo.DataBind();
}
}
public void BindTransportModelInfo()
{
transportdata = new TransportData();
DataSet DS = new DataSet();
DS = transportdata.GetTransportModelInfo();
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpTypeMasteInfo.DataSource = DS;
rpTypeMasteInfo.DataBind();
}
}
public void BindVehicleOperationInfo()
{
transportdata = new TransportData();
DataSet DS = new DataSet();
DS = transportdata.GetVehicleMaintenanceInfo();
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpmaintenanceInfo.DataSource = DS;
rpmaintenanceInfo.DataBind();
}
}
private void Login()
{
Console.Write("Write your name: ");
var login = new ServerCommand()
{
clientName = Console.ReadLine()
};
clientName = login.clientName;
var td = new TransportData(JsonConvert.SerializeObject(login), TransportDataType.SERVER_COMMAND_LOGIN);
SendData(JsonConvert.SerializeObject(td));
}
public void GetConfigInfo()
{
transportdata = new TransportData();
DataSet DS = new DataSet();
DS = transportdata.GetConfigInfo();
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpBrandInfo.DataSource = DS;
rpBrandInfo.DataBind();
}
}
public void GetOutOperationDetailsbyVechileId(int routeid, int Vehicleid)
{
transportdata = new TransportData();
DS = transportdata.GetOutOperationDetailsbyVechileId(routeid, Vehicleid);
lblShowMessage.Text = string.Empty;
lblDispatchId.Text = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS))
{
lblDispatchId.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DispatchId"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DispatchId"].ToString();
dpDriver.ClearSelection();
if (dpDriver.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["FirstDriver"]).ToString()) != null)
{
dpDriver.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["FirstDriver"]).ToString()).Selected = true;
}
dpDriver2.ClearSelection();
if (dpDriver2.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["SecondDriver"]).ToString()) != null)
{
dpDriver2.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["SecondDriver"]).ToString()).Selected = true;
}
dpSalesman.ClearSelection();
if (dpSalesman.Items.FindByValue(DS.Tables[0].Rows[0]["SalesmanId"].ToString()) != null)
{
dpSalesman.Items.FindByValue(DS.Tables[0].Rows[0]["SalesmanId"].ToString()).Selected = true;
}
dpSecondSalesmanId.ClearSelection();
if (dpSecondSalesmanId.Items.FindByValue(DS.Tables[0].Rows[0]["SecondSalesman"].ToString()) != null)
{
dpSecondSalesmanId.Items.FindByValue(DS.Tables[0].Rows[0]["SecondSalesman"].ToString()).Selected = true;
}
if (DS.Tables[0].Rows[0]["DispatchDate"].ToString() == "")
{
txtDispatchDate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DispatchDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DispatchDate"].ToString();
}
else
{
string startdate = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DispatchDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DispatchDate"].ToString();
//sky
DateTime date2 = Convert.ToDateTime(startdate, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat);
txtDispatchDate.Text = (Convert.ToDateTime(date2).ToString("yyyy-MM-dd"));
}
txtDispatchTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DispatchTime"].ToString()) ? string.Empty : (Convert.ToDateTime(DS.Tables[0].Rows[0]["DispatchTime"]).ToString("hh:mm"));
txtSchedueOutTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ScheduleOutTime"].ToString()) ? string.Empty : (Convert.ToDateTime(DS.Tables[0].Rows[0]["ScheduleOutTime"]).ToString("hh:mm"));
txtScheduleEndTime.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["ScheduleInTime"].ToString()) ? string.Empty : (Convert.ToDateTime(DS.Tables[0].Rows[0]["ScheduleInTime"]).ToString("hh:mm"));
}
if (Comman.Comman.IsDataSetEmpty(DS))
{
lblShowMessage.Text = "Vehicle is not in Product Supply Operation";
}
}
protected void btnClick_btnAddVehicleroutemap(object sender, EventArgs e)
{
if (Page.IsValid)
{
// My credential check code
transportdata = new TransportData();
transport = new Transports();
transport.trVRMID = 0;
transport.trVehicleNo = Convert.ToInt32(dpVehicleNo.SelectedItem.Value);;
transport.trRouteID = Convert.ToInt32(dproute.SelectedItem.Value);
transport.CreatedBy = GlobalInfo.Userid;
if (dpIsActive.SelectedItem.Value == "1")
{
transport.IsActive = true;
}
else if (dpIsActive.SelectedItem.Text == "2")
{
transport.IsActive = false;
}
//product.IsActive = true;
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.ModifiedBy = GlobalInfo.Userid;
transport.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
transport.flag = "Insert";
int Result = 0;
Result = transportdata.AddVehicleRouteMapInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Vehicle Route Maped Successfully";
ClearTextBox();
BindVehicleRoteMapInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
}
public void BindVehicleOperationInfo()
{
transportdata = new TransportData();
DataSet DS = new DataSet();
DS = transportdata.GetVehicleProductOutOperationInfo();
if (!Comman.Comman.IsDataSetEmpty(DS))
{
rpvehicleoperationInfo.DataSource = DS;
rpvehicleoperationInfo.DataBind();
}
}
protected void btnClick_btnAddJobCard(object sender, EventArgs e)
{
if (Page.IsValid)
{
transportdata = new TransportData();
transport = new Transports();
transport.ID = 0;
transport.VOp = Convert.ToInt32(txtVOpId.Text);
transport.Brake = txtBrake.Text;
transport.Light = txtLight.Text;
transport.TyreCon = txtTyreCondition.Text;
transport.damage = txtDamages.Text;
transport.other = txtOthers.Text;
transport.oillevel = txtOilLevel.Text;
transport.battery = txtBattery.Text;
transport.crownjointsound = txtCrownnandJointSound.Text;
transport.clutchcon = txtClutchCondition.Text;
transport.stearingvobling = txtStearingVobling.Text;
transport.suspension = txtSuspension.Text;
transport.gearbox = txtGearBox.Text;
transport.CreatedBy = GlobalInfo.Userid;
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.flag = "Insert";
int Result = 0;
Result = transportdata.AddVehicleJOBCardInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Vehicle Operation Added Successfully";
ClearTextBox();
BindVehicleOperationInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
}
private TransportData CreateTransportData(DogStatsdEndPoint endPoint, StatsdConfig config)
{
var transportData = new TransportData();
transportData.Transport = CreateTransport(endPoint, config);
switch (transportData.Transport.TransportType)
{
case TransportType.UDP: transportData.BufferCapacity = config.StatsdMaxUDPPacketSize; break;
case TransportType.UDS: transportData.BufferCapacity = config.StatsdMaxUnixDomainSocketPacketSize; break;
// use StatsdMaxUDPPacketSize for named pipe
case TransportType.NamedPipe: transportData.BufferCapacity = config.StatsdMaxUDPPacketSize; break;
default: throw new NotSupportedException();
}
return transportData;
}
protected void btnClick_btnAddSchedule(object sender, EventArgs e)
{
transportdata = new TransportData();
transport = new Transports();
transport.ID = 0;
transport.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
transport.scheduleOuttime = txtScheduleOutTime.Text;
transport.scheduleIntime = txtScheduleInTime.Text;
transport.CreatedBy = GlobalInfo.Userid;
transport.IsActive = true;
transport.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
transport.flag = "Insert";
int Result = 0;
Result = transportdata.AddTransportScheduleInfo(transport);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Schedule Added Successfully";
ClearTextBox();
GetScheduleInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
if (Result == -2627)
{
lblwarning.Text = "Data Already Exists";
}
else
{
lblwarning.Text = "Please Contact to Site Admin";
}
pnlError.Update();
}
}
public void GetTansportBrandInfoByID(int trBrandID)
{
transportdata = new TransportData();
DS = transportdata.GetTransportBrandInfoByID(trBrandID);
if (!Comman.Comman.IsDataSetEmpty(DS))
{
txtBrand.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["tr_brand_name"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["tr_brand_name"].ToString();
dpIsActive.ClearSelection();
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "True")
{
dpIsActive.Items.FindByValue("1").Selected = true;
}
if (DS.Tables[0].Rows[0]["IsActive"].ToString() == "False")
{
dpIsActive.Items.FindByValue("2").Selected = true;
}
}
}
