protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdedit")
{
Response.Redirect("CustomTripSheet.aspx?TripId=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
CustomTripSheetDAL obj = new CustomTripSheetDAL();
Int32 intValue = obj.DeleteTrip(Convert.ToInt64(e.CommandArgument));
obj = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
txtTripNo.Focus();
}
else
{
if (intValue == -1)
{
strMsg = "Record can not be deleted. It is in use.";
}
else
{
strMsg = "Record not deleted.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
txkStartKms.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txkEndKms.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtdriverno.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtdslcardltr.Attributes.Add("onkeypress", "return allowOnlyAlphabet(event);");
txtdslcardrate.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);");
txtremark.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);");
if (!IsPostBack)
{
this.BindDateRange();
BindDropdown();
this.BindLane();
CustomTripSheetDAL objDAL = new CustomTripSheetDAL();
if (Request.QueryString["TripId"] != null)
{
this.Populate(Request.QueryString["TripId"]);
}
}
}
protected void ddlCompFromCity_SelectedIndexChanged(object sender, EventArgs e)
{
CustomTripSheetDAL obj = new CustomTripSheetDAL();
txtTripNo.Text = obj.GetTripNo(Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToInt32(ddlCompFromCity.SelectedValue), ApplicationFunction.ConnectionString()).ToString();
txtTripNo.Focus();
tblCityMaster mt = obj.GEtLocationDetail(Convert.ToInt64(ddlCompFromCity.SelectedValue));
txtPref.Text = Convert.ToString(mt.City_Abbr);
}
public void lnkbtnNext_OnClick(object sender, EventArgs e)
{
CustomTripSheetDAL obj = new CustomTripSheetDAL();
Int64 MaxTripId = obj.GetMaxId(Convert.ToInt32(ddlDateRange.SelectedValue), ApplicationFunction.ConnectionString());
if (Request.QueryString["TripId"] != null && Convert.ToInt64(Request.QueryString["TripId"]) != MaxTripId)
{
Int32 TripId = Convert.ToInt32(Request.QueryString["TripId"]) + 1;
Response.Redirect("CustomTripSheet.aspx?TripId=" + TripId, true);
}
}
private void BindLane()
{
CustomTripSheetDAL objDAL = new CustomTripSheetDAL();
var objlist = objDAL.BindLane();
ddlLane.DataSource = objlist;
ddlLane.DataTextField = "Lane_Name";
ddlLane.DataValueField = "Lane_Idno";
ddlLane.DataBind();
objDAL = null;
ddlLane.Items.Insert(0, new ListItem("--- Select Lane ---", "0"));
}
private void Populate(string tripId)
{
lnkbtnPrint.Visible = true;
lnkbtnSubmit.Text = "Update";
Int64 tripIdno = Convert.ToInt64(tripId);
CustomTripSheetDAL obj = new CustomTripSheetDAL();
Int64 MaxTripId = obj.GetMaxId(Convert.ToInt32(ddlDateRange.SelectedValue), ApplicationFunction.ConnectionString());
if (Request.QueryString["TripId"] != null && Convert.ToInt64(Request.QueryString["TripId"]) != MaxTripId)
{
lnkbtnNext.Visible = true;
}
tblManualTripHead mt = obj.GetTripSheet(tripIdno);
if (mt != null)
{
txtTripNo.Text = mt.Trip_No.ToString(); txtTripNo.Enabled = false;
txtTripDate.Text = ((mt.Trip_Date == null || mt.Trip_Date.ToString() == "") ? "" : Convert.ToDateTime(mt.Trip_Date.ToString()).ToString("dd-MM-yyyy")); txtTripDate.Enabled = true;
ddlCompFromCity.SelectedValue = mt.BaseCity_Idno.ToString(); ddlCompFromCity.Enabled = true;
ddlTruckNo.SelectedValue = mt.Truck_Idno.ToString(); ddlTruckNo.Enabled = true;
ddlSender.SelectedValue = mt.Party_Idno.ToString(); ddlSender.Enabled = true;
ddlLane.SelectedValue = mt.Lane_Idno.ToString(); ddlLane.Enabled = true;
txtDriverName.Text = mt.Driver_Name.ToString(); txtDriverName.Enabled = true;
txtdriverno.Text = mt.Driver_No.ToString(); txtdriverno.Enabled = true;
txtVehicleSize.Text = mt.Vehicle_Size.ToString(); txtVehicleSize.Enabled = true;
txkStartKms.Text = mt.StartKms.ToString(); txkStartKms.Enabled = true;
ddlDateRange.SelectedValue = mt.Year_Idno.ToString(); ddlDateRange.Enabled = true;
txtdslqty.Text = mt.DSL_Qty.ToString(); txtdslqty.Enabled = true;
txtdslrate.Text = mt.DSL_Rate.ToString(); txtdslrate.Enabled = true;
txtdslamt.Text = mt.DSL_Amt.ToString(); txtdslamt.Enabled = true;
txtcash.Text = mt.Cash.ToString(); txtcash.Enabled = true;
txttoll.Text = mt.Toll.ToString(); txttoll.Enabled = true;
txtwages.Text = mt.Dihadi.ToString(); txtwages.Enabled = true;
txtfoodexp.Text = mt.Food_Exp.ToString(); txtfoodexp.Enabled = true;
txtrepair.Text = mt.Repair.ToString(); txtrepair.Enabled = true;
txttotaldslqty.Text = mt.Total_DSL_Qty.ToString(); txttotaldslqty.Enabled = true;
txttotaldslamt.Text = mt.Total_DSL_Amt.ToString(); txttotaldslamt.Enabled = true;
txtmilage.Text = mt.Milage.ToString(); txtmilage.Enabled = true;
txtadvdriver.Text = mt.Adv_in_Driver.ToString(); txtadvdriver.Enabled = true;
txtother.Text = mt.Other.ToString(); txtother.Enabled = true;
txtremark.Text = mt.Remark.ToString(); txtremark.Enabled = true;
txttotalamt.Text = mt.Total_Amt.ToString(); txttotalamt.Enabled = true;
txtTotalKms.Text = mt.TotalKms.ToString();
txkEndKms.Text = mt.EndKms.ToString();
txtdslcardamt.Text = mt.DSL_Card_Amt.ToString();
txtdslcardrate.Text = mt.DSL_Card_Rate.ToString();
txtdslcardltr.Text = mt.DSL_Card_Name.ToString();
txtexdslamt.Text = mt.Ex_DSL_Amt.ToString();
txtexdslltr.Text = mt.Ex_DSL_Ltr.ToString();
hidtripid.Value = mt.Trip_Idno.ToString();
}
}
private void BindGrid()
{
CustomTripSheetDAL obj = new CustomTripSheetDAL();
DateTime? dtfrom = null;
DateTime? dtto = null;
Int64 yearIDNO = Convert.ToInt32(ddlDateRange.SelectedValue);
Int64 Lane_Idno = Convert.ToInt64(ddlLane.SelectedValue);
Int64 lorry_Idno = Convert.ToInt64(ddlLorry_No.SelectedValue);
int TripNo = string.IsNullOrEmpty(Convert.ToString(txtTripNo.Text)) ? 0 : Convert.ToInt32(txtTripNo.Text);
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtfrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Datefrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(Datefrom.Text)) == false)
{
dtto = Convert.ToDateTime(ApplicationFunction.mmddyyyy(Dateto.Text));
}
int cityfrom = Convert.ToInt32(drpCityFrom.SelectedValue);
int sender = Convert.ToInt32(ddlSender.SelectedValue == "" ? 0 : Convert.ToInt32(ddlSender.SelectedValue));
Int32 yearidno = Convert.ToInt32(ddlDateRange.SelectedValue == "" ? 0 : Convert.ToInt32(ddlDateRange.SelectedValue));
Int64 UserIdno = 0;
if (Convert.ToString(Session["Userclass"]) != "Admin")
{
UserIdno = Convert.ToInt64(Session["UserIdno"]);
}
var lstGridData = obj.SelectTrip(TripNo, dtfrom, dtto, cityfrom, sender, yearidno, Lane_Idno, lorry_Idno);
obj = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SrNo", typeof(string));
dt.Columns.Add("Trip No.", typeof(string));
dt.Columns.Add("Pref No.", typeof(string));
dt.Columns.Add("Trip_Date", typeof(string));
dt.Columns.Add("Party", typeof(string));
dt.Columns.Add("City", typeof(string));
dt.Columns.Add("Truck No", typeof(string));
dt.Columns.Add("Driver", typeof(string));
dt.Columns.Add("Driver No", typeof(string));
dt.Columns.Add("Vehicle Size", typeof(string));
dt.Columns.Add("StartKm", typeof(string));
dt.Columns.Add("EndKm", typeof(string));
dt.Columns.Add("Total KM", typeof(string));
dt.Columns.Add("Qty", typeof(string));
dt.Columns.Add("Lane", typeof(string));
dt.Columns.Add("DSL_Card_Name", typeof(string));
dt.Columns.Add("DSL_Card_Number", typeof(string));
dt.Columns.Add("DSL_Qty", typeof(string));
dt.Columns.Add("DSL_Rate", typeof(string));
dt.Columns.Add("DSL_Amt", typeof(string));
dt.Columns.Add("DSL_Card_Amt", typeof(string));
dt.Columns.Add("Total_DSL_Qty", typeof(string));
dt.Columns.Add("Total_DSL_Amt", typeof(string));
dt.Columns.Add("Milage", typeof(string));
dt.Columns.Add("Cash", typeof(string));
dt.Columns.Add("Toll", typeof(string));
dt.Columns.Add("Wages", typeof(string));
dt.Columns.Add("Food_Exp", typeof(string));
dt.Columns.Add("Repair", typeof(string));
dt.Columns.Add("Adv_in_Driver", typeof(string));
dt.Columns.Add("Other", typeof(string));
dt.Columns.Add("Net Amount", typeof(string));
dt.Columns.Add("Remark", typeof(string));
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["SrNo"] = Convert.ToString(i + 1);
dr["Trip No."] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Trip_Idno"));
dr["Trip_Date"] = Convert.ToDateTime(DataBinder.Eval(lstGridData[i], "Trip_Date")).ToString("dd-MM-yyyy");;
dr["Party"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Acnt_Name"));
dr["City"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "City_Name"));
dr["Truck No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lorry_No"));
dr["Driver"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Driver_Name"));
dr["StartKm"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "StartKms"));
dr["EndKm"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "EndKms"));
dr["Total KM"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "TotalKms"));
dr["Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Quantity"));
dr["Lane"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Lane_Name"));
dr["Pref No."] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Pref_No"));
dr["Driver No"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Driver_No"));
dr["Vehicle Size"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Vehicle_Size"));
dr["DSL_Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Qty"));
dr["DSL_Rate"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Rate"));
dr["DSL_Amt"] = Convert.ToDouble(string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Amt"))) ? "0.0" : DataBinder.Eval(lstGridData[i], "DSL_Amt")).ToString("N2");
dr["DSL_Card_Amt"] = Convert.ToDouble(string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Card_Amt"))) ? "0.0" : DataBinder.Eval(lstGridData[i], "DSL_Card_Amt")).ToString("N2");
dr["DSL_Card_Name"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Card_Name"));
dr["DSL_Card_Number"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "DSL_Card_Number"));
dr["Total_DSL_Qty"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Total_DSL_Qty"));
dr["Total_DSL_Amt"] = Convert.ToDouble(string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lstGridData[i], "Total_DSL_Amt"))) ? "0.0" : DataBinder.Eval(lstGridData[i], "Total_DSL_Amt")).ToString("N2");
dr["Cash"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Cash"));
dr["Toll"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Toll"));
dr["Wages"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Wages"));
dr["Food_Exp"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Food_Exp"));
dr["Repair"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Repair"));
dr["Adv_in_Driver"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Adv_in_Driver"));
dr["Other"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Other"));
dr["Milage"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Milage"));
dr["Net Amount"] = Convert.ToDouble(DataBinder.Eval(lstGridData[i], "Total_Amt")).ToString("N2");
dr["Remark"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "Remark"));
dt.Rows.Add(dr);
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
grdMain.DataSource = lstGridData;
grdMain.DataBind();
imgBtnExcel.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
}
}
public void lnkbtnSubmit_OnClick(object sender, EventArgs e)
{
if (CheckEmptyFields())
{
CalculateAll();
Int64 return_status = 0;
CustomTripSheetDAL obj = new CustomTripSheetDAL();
if (Request.QueryString["TripId"] == null)
{
return_status = obj.InsertTripSheet(Convert.ToInt64(txtTripNo.Text),
Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtTripDate.Text.Trim().ToString())),
Convert.ToInt32(ddlCompFromCity.SelectedValue),
Convert.ToInt32(ddlTruckNo.SelectedValue),
Convert.ToInt32(ddlSender.SelectedValue),
Convert.ToInt32(ddlLane.SelectedValue),
Convert.ToString(txtDriverName.Text),
Convert.ToInt64(txtdriverno.Text),
Convert.ToString(txtVehicleSize.Text),
Convert.ToString(txkStartKms.Text),
Convert.ToString(txkEndKms.Text),
Convert.ToString(txtTotalKms.Text),
Convert.ToInt32(ddlDateRange.SelectedValue),
Convert.ToDouble(txtdslqty.Text == "" ? "0" : txtdslqty.Text),
Convert.ToDouble(txtdslrate.Text == "" ? "0" : txtdslrate.Text),
Convert.ToDouble(txtdslamt.Text == "" ? "0" : txtdslamt.Text),
Convert.ToDouble(txtcash.Text == "" ? "0" : txtcash.Text),
Convert.ToDouble(txtdslcardamt.Text == "" ? "0" : txtdslcardamt.Text),
Convert.ToString(txtdslcardrate.Text == "" ? "0" : txtdslcardrate.Text),
Convert.ToString(txtdslcardltr.Text),
Convert.ToDouble(txttoll.Text == "" ? "0" : txttoll.Text),
Convert.ToDouble(txtwages.Text == "" ? "0" : txtwages.Text),
Convert.ToDouble(txtfoodexp.Text == "" ? "0" : txtfoodexp.Text),
Convert.ToDouble(txtrepair.Text == "" ? "0" : txtrepair.Text),
Convert.ToDouble(txtexdslamt.Text == "" ? "0" : txtexdslamt.Text),
Convert.ToDouble(txtexdslltr.Text == "" ? "0" : txtexdslltr.Text),
Convert.ToDouble(txttotaldslqty.Text == "" ? "0" : txttotaldslqty.Text),
Convert.ToDouble(txttotaldslamt.Text == "" ? "0" : txttotaldslamt.Text),
Convert.ToDouble(txtmilage.Text == "" ? "0" : txtmilage.Text),
Convert.ToDouble(txtadvdriver.Text == "" ? "0" : txtadvdriver.Text),
Convert.ToDouble(txtother.Text == "" ? "0" : txtother.Text),
Convert.ToString(txtremark.Text),
Convert.ToDouble(txttotalamt.Text == "" ? "0" : txttotalamt.Text));
}
else
{
Int64 intTripIdno = Convert.ToInt64(Request.QueryString["TripId"]);
return_status = obj.UpdateTripSheet(intTripIdno, Convert.ToInt64(txtTripNo.Text),
Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtTripDate.Text.Trim().ToString())),
Convert.ToInt32(ddlCompFromCity.SelectedValue),
Convert.ToInt32(ddlTruckNo.SelectedValue),
Convert.ToInt32(ddlSender.SelectedValue),
Convert.ToInt32(ddlLane.SelectedValue),
Convert.ToString(txtDriverName.Text),
Convert.ToInt64(txtdriverno.Text),
Convert.ToString(txtVehicleSize.Text),
Convert.ToString(txkStartKms.Text),
Convert.ToString(txkEndKms.Text),
Convert.ToString(txtTotalKms.Text),
Convert.ToInt32(ddlDateRange.SelectedValue),
Convert.ToDouble(txtdslqty.Text == "" ? "0" : txtdslqty.Text),
Convert.ToDouble(txtdslrate.Text == "" ? "0" : txtdslrate.Text),
Convert.ToDouble(txtdslamt.Text == "" ? "0" : txtdslamt.Text),
Convert.ToDouble(txtcash.Text == "" ? "0" : txtcash.Text),
Convert.ToDouble(txtdslcardamt.Text == "" ? "0" : txtdslcardamt.Text),
Convert.ToString(txtdslcardrate.Text == "" ? "0" : txtdslcardrate.Text),
Convert.ToString(txtdslcardltr.Text),
Convert.ToDouble(txttoll.Text == "" ? "0" : txttoll.Text),
Convert.ToDouble(txtwages.Text == "" ? "0" : txtwages.Text),
Convert.ToDouble(txtfoodexp.Text == "" ? "0" : txtfoodexp.Text),
Convert.ToDouble(txtrepair.Text == "" ? "0" : txtrepair.Text),
Convert.ToDouble(txtexdslamt.Text == "" ? "0" : txtexdslamt.Text),
Convert.ToDouble(txtexdslltr.Text == "" ? "0" : txtexdslltr.Text),
Convert.ToDouble(txttotaldslqty.Text == "" ? "0" : txttotaldslqty.Text),
Convert.ToDouble(txttotaldslamt.Text == "" ? "0" : txttotaldslamt.Text),
Convert.ToDouble(txtmilage.Text == "" ? "0" : txtmilage.Text),
Convert.ToDouble(txtadvdriver.Text == "" ? "0" : txtadvdriver.Text),
Convert.ToDouble(txtother.Text == "" ? "0" : txtother.Text),
Convert.ToString(txtremark.Text),
Convert.ToDouble(txttotalamt.Text == "" ? "0" : txttotalamt.Text));
}
if (return_status > 0)
{
if (string.IsNullOrEmpty(hidtripid.Value) == false)
{
ShowMessage("Trip sheet is updated successfully.");
}
else
{
ShowMessage("Trip sheet is saved successfully.");
}
ClearFields();
}
else if (return_status == -1)
{
ShowMessageErr("Trip sheet already exists.");
}
else
{
ShowMessageErr("Trip sheet SAVED FAILURE.");
}
}
else
{
ShowMessageErr("Please fill all the fields.");
}
}
