protected void Save_Click(object sender, EventArgs e) { DataSet dsOdo = new DataSet(); dsOdo = objFuelEntry.ICheckFuelEntryOdo(Convert.ToInt32(ddlVehicleNumber.SelectedValue)); if (dsOdo.Tables[0].Rows.Count != 0) { if (dsOdo.Tables[0].Rows[0]["ODO"].ToString() != string.Empty) { maxOdo.Value = dsOdo.Tables[0].Rows[0]["ODO"].ToString(); ViewState["maxodometer"] = dsOdo.Tables[0].Rows[0]["ODO"].ToString(); } else { maxOdo.Value = "0"; } } else { maxOdo.Value = "0"; } TraceService(txtFuelEntryDate.Text.ToString()); DateTime entrydate = DateTime.ParseExact(txtFuelEntryDate.Text, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture); if (entrydate > System.DateTime.Now) { Show("Fuel entry date should be greater than current date "); return; } Save.Enabled = false; GvkFMSAPP.BLL.FMSGeneral fmsGeneral = new GvkFMSAPP.BLL.FMSGeneral(); DataSet ds = fmsGeneral.GetRegistrationDate(int.Parse(ddlVehicleNumber.SelectedItem.Value)); Save.Enabled = true; if (ds.Tables[0].Rows.Count == 0) { Show("Fuel Entry cannot be done as vehicle is not yet Registered"); } else { if (txtOdometer.Text.Trim() != string.Empty) { if (Convert.ToInt32(ViewState["maxodometer"].ToString()) != 0) { int maxno = Convert.ToInt32(ViewState["maxodometer"].ToString()) + 1000; if (maxno <= Convert.ToInt32(txtOdometer.Text) || Convert.ToInt32(txtOdometer.Text) <= Convert.ToInt32(ViewState["maxodometer"].ToString())) { Show("Odo value between " + ViewState["maxodometer"].ToString() + " And " + maxno); txtOdometer.Text = ""; txtOdometer.Focus(); return; } else { // Show(ViewState["maxodometer"].ToString()); } } } else { Show("Enter Odo value"); return; } // Show(ds.Tables[0].Rows[0]["RegDate"].ToString()); DateTime dtofRegistration = DateTime.ParseExact(ds.Tables[0].Rows[0]["RegDate"].ToString(), "dd-MM-yyyy", CultureInfo.InvariantCulture); DateTime.Now.ToString(); DateTime FuelEntry = DateTime.ParseExact(txtFuelEntryDate.Text, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture); if (dtofRegistration > FuelEntry) { Show("Fuel entry date should be greater than date of registration "); return; } DataTable dtpreviousentryDate = new DataTable(); dtpreviousentryDate = getpreviousODO(int.Parse(ddlVehicleNumber.SelectedItem.Value)); if (dtpreviousentryDate != null) { if (dtpreviousentryDate.Rows.Count > 0) { if (dtpreviousentryDate.Rows[0]["maxentry"].ToString() != "") { DateTime dtprvrefill = Convert.ToDateTime(dtpreviousentryDate.Rows[0]["maxentry"].ToString()); if (dtprvrefill > DateTime.ParseExact(txtFuelEntryDate.Text, "dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture)) { Show("Fuel entry date must be greater than previous fuel entry date"); return; } } } } //Shiva end Save.Enabled = false; if (Save.Text == "Save" && ddlPetroCardNumber.Enabled == true) { if (ddlBunkName.Visible == true) { bunkname = ddlBunkName.SelectedItem.Text; } else { bunkname = txtBunkName.Text; } // int distid = Convert.ToInt32(Session["UserdistrictId"].ToString()); // int ddlVehicleNumberz = Convert.ToInt32(ddlVehicleNumber.SelectedValue); // int ddlDistrictz = Convert.ToInt32(ddlDistrict.SelectedValue); // DateTime txtFuelEntryDatez = Convert.ToDateTime(txtFuelEntryDate.Text); // Int64 txtBillNumberz = Convert.ToInt64(txtBillNumber.Text); // Int64 txtOdometerz = Convert.ToInt64(txtOdometer.Text); // string bunknamez = bunkname; // int ddlPaymodez = Convert.ToInt32(ddlPaymode.SelectedValue); // decimal txtQuantityz = Convert.ToDecimal(txtQuantity.Text); // Int64 ddlPetroCardNumberz = Convert.ToInt64(ddlPetroCardNumber.SelectedValue); // decimal txtUnitPricez = Convert.ToDecimal(txtUnitPrice.Text); // int ddlAgencyz = Convert.ToInt32(ddlAgency.SelectedValue); // string txtLocationz = Convert.ToString(txtLocation.Text); // int User_Idz = Convert.ToInt32(Session["User_Id"].ToString()); // decimal txtAmountz = Convert.ToDecimal(txtAmount.Text); // int txtPilotIDz = Convert.ToInt32(txtPilotID.Text); // string txtPilotNamez = Convert.ToString(txtPilotName.Text); // int ddlCardSwipedz = Convert.ToInt32(ddlCardSwiped.SelectedValue); // string txtRemarksz = Convert.ToString(txtRemarks.Text); InsFuelEntry(Convert.ToInt32(Session["UserdistrictId"].ToString()), Convert.ToInt32(ddlVehicleNumber.SelectedValue), Convert.ToInt32(ddlDistrict.SelectedValue), FuelEntry, Convert.ToInt64(txtBillNumber.Text), Convert.ToInt64(txtOdometer.Text), bunkname, Convert.ToInt32(ddlPaymode.SelectedValue), Convert.ToDecimal(txtQuantity.Text), Convert.ToInt64(ddlPetroCardNumber.SelectedValue), Convert.ToDecimal(txtUnitPrice.Text), Convert.ToInt32(ddlAgency.SelectedValue), Convert.ToString(txtLocation.Text), Convert.ToInt32(Session["User_Id"].ToString()), DateTime.Now, 1, Convert.ToDecimal(txtAmount.Text), Convert.ToInt32(txtPilotID.Text), Convert.ToString(txtPilotName.Text), Convert.ToInt32(ddlCardSwiped.SelectedValue), Convert.ToString(txtRemarks.Text)); // Convert.ToInt32(txtSegmentID.Text), Convert.ToString(txtBaseLocation.Text), //ShowKMPL(); FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"])); } else { if (Save.Text == "Save" && ddlPetroCardNumber.Enabled == false) { if (ddlBunkName.Visible == true) { bunkname = ddlBunkName.SelectedItem.Text; } else { bunkname = txtBunkName.Text; } InsFuelEntry1(Convert.ToInt32(Session["UserdistrictId"].ToString()), Convert.ToInt32(ddlVehicleNumber.SelectedValue), FuelEntry, Convert.ToInt64(txtBillNumber.Text), Convert.ToInt64(txtOdometer.Text), bunkname, Convert.ToInt32(ddlPaymode.SelectedValue), Convert.ToDecimal(txtQuantity.Text), Convert.ToDecimal(txtUnitPrice.Text), Convert.ToString(txtLocation.Text), Convert.ToInt32(Session["User_Id"].ToString()), DateTime.Now, 1, Convert.ToDecimal(txtAmount.Text), Convert.ToInt32(txtPilotID.Text), Convert.ToString(txtPilotName.Text), Convert.ToInt32(ddlCardSwiped.SelectedValue), Convert.ToString(txtRemarks.Text)); // Convert.ToInt32(txtSegmentID.Text), Convert.ToString(txtBaseLocation.Text), //ShowKMPL(); FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"])); } else if (Save.Text == "Update" && ddlPetroCardNumber.Enabled == true) { if (ddlBunkName.Visible == true) { bunkname = ddlBunkName.SelectedItem.Text; } else { bunkname = txtBunkName.Text; } UpdFuelEntry(Convert.ToInt32(txtEdit.Text), Convert.ToInt32(Session["UserdistrictId"].ToString()), Convert.ToInt32(ddlVehicleNumber.SelectedValue), Convert.ToInt32(ddlDistrict.SelectedValue), FuelEntry, Convert.ToInt64(txtBillNumber.Text), Convert.ToInt64(txtOdometer.Text), bunkname, Convert.ToInt32(ddlPaymode.SelectedValue), Convert.ToDecimal(txtQuantity.Text), Convert.ToInt64(ddlPetroCardNumber.SelectedValue), Convert.ToDecimal(txtUnitPrice.Text), Convert.ToInt32(ddlAgency.SelectedValue), Convert.ToString(txtLocation.Text), Convert.ToDecimal(txtAmount.Text), Convert.ToInt32(txtPilotID.Text), Convert.ToString(txtPilotName.Text), Convert.ToInt32(ddlCardSwiped.SelectedValue), Convert.ToString(txtRemarks.Text)); //Convert.ToInt32(txtSegmentID.Text), Convert.ToString(txtBaseLocation.Text), FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"])); } else { if (ddlBunkName.Visible == true) { bunkname = ddlBunkName.SelectedItem.Text; } else { bunkname = txtBunkName.Text; } UpdFuelEntry1(Convert.ToInt32(txtEdit.Text), Convert.ToInt32(Session["UserdistrictId"].ToString()), Convert.ToInt32(ddlVehicleNumber.SelectedValue), FuelEntry, Convert.ToInt64(txtBillNumber.Text), Convert.ToInt64(txtOdometer.Text), bunkname, Convert.ToInt32(ddlPaymode.SelectedValue), Convert.ToDecimal(txtQuantity.Text), Convert.ToDecimal(txtUnitPrice.Text), Convert.ToString(txtLocation.Text), Convert.ToDecimal(txtAmount.Text), Convert.ToInt32(txtPilotID.Text), Convert.ToString(txtPilotName.Text), Convert.ToInt32(ddlCardSwiped.SelectedValue), Convert.ToString(txtRemarks.Text)); // Convert.ToInt32(txtSegmentID.Text), Convert.ToString(txtBaseLocation.Text), FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"])); } } } // } // catch(Exception ex) // { // } }