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);
}
}
