Esempio n. 1
0
        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)
            //  {

            //   }
        }