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();
    }
Exemple #2
0
    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);
        }
    }