public void lnkbtnSubmit_OnClick(object sender, EventArgs e)
{
if (CheckEmptyFields())
{
CalculateAll();
Int64 return_status = 0;
ManualTripSheetDAL obj = new ManualTripSheetDAL();
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(ddlFromCity.SelectedValue), Convert.ToInt32(ddlToCity.SelectedValue), Convert.ToString(txtDriverName.Text), Convert.ToString(txkStartKms.Text), Convert.ToString(txkEndKms.Text), Convert.ToInt32(ddlDateRange.SelectedValue),
Convert.ToString(txtItemName.Text), Convert.ToString(txtItemSize.Text), Convert.ToInt32(ddlRateType.SelectedValue), Convert.ToDouble(txtQuantity.Text == "" ? "0" : txtQuantity.Text), Convert.ToDouble(txtGweight.Text == "" ? "0" : txtGweight.Text), Convert.ToDouble(txtAweight.Text == "" ? "0" : txtAweight.Text), Convert.ToDouble(txtrate.Text == "" ? "0" : txtrate.Text), Convert.ToDouble(txtAdvance.Text == "" ? "0" : txtAdvance.Text), Convert.ToDouble(txtCommission.Text == "" ? "0" : txtCommission.Text), Convert.ToDouble(txtTotalPartyAdv.Text == "" ? "0" : txtTotalPartyAdv.Text), Convert.ToDouble(txtRTOChallan.Text == "" ? "0" : txtRTOChallan.Text), Convert.ToDouble(txtDetention.Text == "" ? "0" : txtDetention.Text),
Convert.ToDouble(txtTotalAmount.Text == "" ? "0" : txtTotalAmount.Text), Convert.ToDouble(txtTotalFreight.Text == "" ? "0" : txtTotalFreight.Text), Convert.ToDouble(txtReceived.Text == "" ? "0" : txtReceived.Text), Convert.ToInt32(ddlRecType.SelectedValue), Convert.ToDouble(txtTotalPartyBalance.Text == "" ? "0" : txtTotalPartyBalance.Text), Convert.ToDouble(txtDriver.Text == "" ? "0" : txtDriver.Text), Convert.ToDouble(txtDiesel.Text == "" ? "0" : txtDiesel.Text), Convert.ToDouble(txtDriverAc.Text == "" ? "0" : txtDriverAc.Text), Convert.ToDouble(txtTotalVehAdv.Text == "" ? "0" : txtTotalVehAdv.Text), Convert.ToDouble(txtNetTripProfit.Text == "" ? "0" : txtNetTripProfit.Text), chkFixRate.Checked);
}
else
{
Int64 intTripIdno = Convert.ToInt64(Request.QueryString["TripId"]);
return_status = obj.UpdateTripSheet(intTripIdno, Convert.ToInt64(txtTripNo.Text == "" ? "0" : txtTripNo.Text), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtTripDate.Text.Trim().ToString())), Convert.ToInt32(ddlCompFromCity.SelectedValue), Convert.ToInt32(ddlTruckNo.SelectedValue), Convert.ToInt32(ddlSender.SelectedValue), Convert.ToInt32(ddlFromCity.SelectedValue), Convert.ToInt32(ddlToCity.SelectedValue), Convert.ToString(txtDriverName.Text), Convert.ToString(txkStartKms.Text), Convert.ToString(txkEndKms.Text), Convert.ToInt32(ddlDateRange.SelectedValue),
Convert.ToString(txtItemName.Text), Convert.ToString(txtItemSize.Text), Convert.ToInt32(ddlRateType.SelectedValue), Convert.ToDouble(txtQuantity.Text == "" ? "0" : txtQuantity.Text), Convert.ToDouble(txtGweight.Text == "" ? "0" : txtGweight.Text), Convert.ToDouble(txtAweight.Text == "" ? "0" : txtAweight.Text), Convert.ToDouble(txtrate.Text), Convert.ToDouble(txtAdvance.Text == "" ? "0" : txtAdvance.Text), Convert.ToDouble(txtCommission.Text == "" ? "0" : txtCommission.Text), Convert.ToDouble(txtTotalPartyAdv.Text == "" ? "0" : txtTotalPartyAdv.Text), Convert.ToDouble(txtRTOChallan.Text == "" ? "0" : txtRTOChallan.Text), Convert.ToDouble(txtDetention.Text == "" ? "0" : txtDetention.Text),
Convert.ToDouble(txtTotalAmount.Text == "" ? "0" : txtTotalAmount.Text), Convert.ToDouble(txtTotalFreight.Text == "" ? "0" : txtTotalFreight.Text), Convert.ToDouble(txtReceived.Text == "" ? "0" : txtReceived.Text), Convert.ToInt32(ddlRecType.SelectedValue), Convert.ToDouble(txtTotalPartyBalance.Text), Convert.ToDouble(txtDriver.Text == "" ? "0" : txtDriver.Text), Convert.ToDouble(txtDiesel.Text == "" ? "0" : txtDiesel.Text), Convert.ToDouble(txtDriverAc.Text == "" ? "0" : txtDriverAc.Text), Convert.ToDouble(txtTotalVehAdv.Text == "" ? "0" : txtTotalVehAdv.Text), Convert.ToDouble(txtNetTripProfit.Text == "" ? "0" : txtNetTripProfit.Text), chkFixRate.Checked);
}
if (return_status > 0)
{
ShowMessage("Trip sheet is saved successfully.");
Response.Redirect("ManualTripSheet.aspx");
}
else if (return_status == -1)
{
ShowMessageErr("Trip sheet already exists.");
}
else
{
ShowMessageErr("Trip sheet SAVED FAILURE.");
}
}
else
{
ShowMessageErr("Please fill all the fields.");
}
}
