protected void FillVehicleNumber() { var fmsGeneral = new FMSGeneral(); if (Session["UserdistrictId"] != null) { fmsGeneral.UserDistrictId = Convert.ToInt32(Session["UserdistrictId"].ToString()); } Accordion_VehicleNumber.DataSource = fmsGeneral.GetVehicleDetails().Tables[0].DefaultView; Accordion_VehicleNumber.DataBind(); }
protected void Save_Click(object sender, EventArgs e) { var dsOdo = ObjFuelEntry.ICheckFuelEntryOdo(Convert.ToInt32(ddlVehicleNumber.SelectedValue)); if (dsOdo == null) { throw new ArgumentNullException(nameof(dsOdo)); } try { switch (dsOdo.Tables[0].Rows.Count) { case 0: maxOdo.Value = "0"; break; default: if (dsOdo.Tables[0].Rows[0]["ODO"].ToString() == string.Empty) { maxOdo.Value = "0"; } else { maxOdo.Value = dsOdo.Tables[0].Rows[0]["ODO"].ToString(); ViewState["maxodometer"] = dsOdo.Tables[0].Rows[0]["ODO"].ToString(); } break; } var entrydate = DateTime.ParseExact(txtFuelEntryDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture); if (entrydate > DateTime.Now) { Show("Fuel entry date should not be greater than current date "); return; } Save.Enabled = false; var fmsGeneral = new FMSGeneral(); var ds = fmsGeneral.GetRegistrationDate(int.Parse(ddlVehicleNumber.SelectedItem.Value)); if (ds == null) { throw new ArgumentNullException(nameof(ds)); } Save.Enabled = true; switch (ds.Tables[0].Rows.Count) { case 0: Show("Fuel Entry cannot be done as vehicle is not yet Registered"); break; default: if (txtOdometer.Text.Trim() == string.Empty) { Show("Enter Odo value"); return; } else { if (Convert.ToInt32(ViewState["maxodometer"].ToString()) != 0) { var 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"] + " And " + maxno); txtOdometer.Text = ""; txtOdometer.Focus(); return; } } } var dtofRegistration = DateTime.ParseExact(ds.Tables[0].Rows[0]["RegDate"].ToString(), "MM/dd/yyyy", CultureInfo.InvariantCulture); var fuelEntry = DateTime.ParseExact(txtFuelEntryDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture); if (dtofRegistration > fuelEntry) { Show("Fuel entry date should be greater than date of registration "); return; } var dtpreviousentryDate = GetpreviousOdo(int.Parse(ddlVehicleNumber.SelectedItem.Value)); if (dtpreviousentryDate.Rows.Count > 0 && dtpreviousentryDate.Rows[0]["maxentry"].ToString() != "") { var dtprvrefill = Convert.ToDateTime(dtpreviousentryDate.Rows[0]["maxentry"].ToString()); if (dtprvrefill > DateTime.ParseExact(txtFuelEntryDate.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture)) { Show("Fuel entry date must be greater than previous fuel entry date"); return; } } Save.Enabled = false; if (Save.Text == "Save" && ddlPetroCardNumber.Enabled) { _bunkname = ddlBunkName.Visible ? ddlBunkName.SelectedItem.Text : txtBunkName.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)); FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"])); } else if (Save.Text == "Save" && ddlPetroCardNumber.Enabled == false) { _bunkname = ddlBunkName.Visible ? ddlBunkName.SelectedItem.Text : 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)); FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"])); } else if (Save.Text == "Update" && ddlPetroCardNumber.Enabled) { _bunkname = ddlBunkName.Visible ? ddlBunkName.SelectedItem.Text : 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)); FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"])); } else { _bunkname = ddlBunkName.Visible ? ddlBunkName.SelectedItem.Text : 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)); FillGridFuelEntry(Convert.ToInt32(ViewState["VehicleID"])); } break; } } catch (Exception ex) { _helper.ErrorsEntry(ex); } }