Пример #1
0
    protected void btnFPSave_Click(object sender, EventArgs e)
    {
        DataTable dtBasicFInfo = farmingObj.GetBasicFarmingInfo(Convert.ToInt32(ddlFPYear.SelectedValue), Convert.ToInt32(ddlFPProduct.SelectedValue), Convert.ToInt32(ddlFPSeason.SelectedValue));

        string[] strFarmer = txtFPFarmerN.Text.Split('-');
        string   farmerID  = string.Empty;
        //if (strFarmer.Length >= 2)
        //{
        DataTable dtFarmerDetails = far.FamerDetails(strFarmer[0].Trim(), strFarmer[1].Trim(), strFarmer[2].Trim());

        farmerID = txtFPFarmerN.Text;    //dtFarmerDetails.Rows[0]["FarmerID"].ToString() ;
        //}
        if (dtBasicFInfo.Rows.Count > 0)
        {
            for (int count = 0; count < dlMainFP.Items.Count; count++)
            {
                int      PFarmID = Convert.ToInt32(dlMainFP.DataKeys[count].ToString());
                GridView gv      = (dlMainFP.Items[count].FindControl("gvCrops") as GridView);
                if (gv.Rows.Count > 0)
                {
                    decimal PTotalArea = Convert.ToDecimal((dlMainFP.Items[count].FindControl("lblPlotArea") as Label).Text);
                    decimal TotalArea  = 0;
                    for (int gvCount = 0; gvCount < gv.Rows.Count; gvCount++)
                    {
                        DataKey dk           = gv.DataKeys[gvCount];
                        int     FarmId       = !string.IsNullOrEmpty(dk.Values["FarmId"].ToString()) ? Convert.ToInt32(dk.Values["FarmId"].ToString()) : 0;
                        int     PlantationId = !string.IsNullOrEmpty(dk.Values["PlantationId"].ToString()) ? Convert.ToInt32(dk.Values["PlantationId"].ToString()) : 0;
                        string  PA           = (gv.Rows[gvCount].FindControl("txtPlotArea") as TextBox).Text;
                        decimal PlotArea     = !string.IsNullOrEmpty(PA) ? Convert.ToDecimal(PA) : 0;
                        TotalArea += PlotArea;
                        DateTime PlantationDate = objMudarApp.GenerateRandomDate(dtBasicFInfo.Rows[0]["PlantationFrom"].ToString(), dtBasicFInfo.Rows[0]["PlantationTo"].ToString());
                        int      FHCount        = MudarApp.RandomNumber(Convert.ToInt32(dtBasicFInfo.Rows[0]["1stCutFrom"].ToString()), Convert.ToInt32(dtBasicFInfo.Rows[0]["1stCutTo"].ToString()));
                        int      SHCount        = MudarApp.RandomNumber(Convert.ToInt32(dtBasicFInfo.Rows[0]["2ndCutFrom"].ToString()), Convert.ToInt32(dtBasicFInfo.Rows[0]["2ndCutTo"].ToString()));
                        string   unitid         = Guid.NewGuid().ToString();

                        if (TotalArea <= PTotalArea)
                        {
                            if (FarmId == 0 && PlantationId == 0)
                            {
                                //IsInterCrop is constant false.
                                bool resutl = fp.Farm_PlantationDetails_INSandUPDandDEL(farmerID, FarmId, PlotArea, string.Empty, 0, 0, PFarmID, Convert.ToInt32(ddlFPProduct.SelectedValue),
                                                                                        unitid, PlantationDate, PlantationDate.AddDays(FHCount), 0, PlantationDate.AddDays(FHCount + 2), 0, 0, PlantationDate.AddDays(FHCount + SHCount), 0,
                                                                                        PlantationDate.AddDays(FHCount + SHCount + 2), 0, 0, 0, false, false, "Aslam", string.Empty,
                                                                                        Convert.ToInt32(ddlFPSeason.SelectedValue), PlotArea, MudarApp.Insert, 0, unitid, unitid, 0, 0, string.Empty, string.Empty,
                                                                                        Convert.ToInt32(ddlFPYear.SelectedValue), false, 0, 0, 0, 0);
                            }
                        }
                    }
                }
            }
            if (ddlFPProduct.SelectedIndex > 0)
            {
                BindDlMainFP();
            }
        }
        else
        {
            //no Basic Information is not schedule. ok
        }
    }
 protected void btnFarmerInfosumbit_Click(object sender, EventArgs e)
 {
     try
     {
         bool result        = false;
         int  FarmingInfoID = 0;
         FarmingInfoID = Convert.ToInt32(hfBFID.Value);
         //DateTime FDate = System.DateTime.Parse(txtPlantationFDate.Text);
         //DateTime TDate = System.DateTime.Parse(txtPlantationTDate.Text);
         bool resutl = false;
         if (FarmingInfoID > 0)
         {
             result = farmingObj.FarmingInfo_INSandUPDandDEL(Convert.ToInt32(ddlYear.SelectedValue), Convert.ToInt32(ddlProduct.SelectedValue), Convert.ToInt32(ddlSeason.SelectedValue), Convert.ToDateTime(txtPlantationFDate.Text), Convert.ToDateTime(txtPlantationTDate.Text), Convert.ToInt32(txt1stCutF.Text), Convert.ToInt32(txt1stCutT.Text), Convert.ToDecimal(txt1stHCF.Text), Convert.ToDecimal(txt1stHCT.Text), Convert.ToDecimal(txt1stOilF.Text), Convert.ToDecimal(txt1stOilT.Text), Convert.ToInt32(txt2ndCutF.Text), Convert.ToInt32(txt2ndCutT.Text), Convert.ToDecimal(txt2ndHCF.Text), Convert.ToDecimal(txt2ndHCT.Text), Convert.ToDecimal(txt2ndOilF.Text), Convert.ToDecimal(txt2ndOilT.Text), Convert.ToInt32(txtActualF.Text), Convert.ToInt32(txtActualTo.Text), "", "Aslam", MudarApp.Update, FarmingInfoID);
             if (result)
             {
                 DataTable dt = new DataTable();
                 dt = farmingObj.GetProductionInfo(Convert.ToInt32(ddlProduct.SelectedValue), Convert.ToInt32(ddlSeason.SelectedValue));
                 if (dt.Rows.Count > 0)
                 {
                     DataTable dtBasicFInfo = farmingObj.GetBasicFarmingInfo(Convert.ToInt32(ddlYear.SelectedValue), Convert.ToInt32(ddlProduct.SelectedValue), Convert.ToInt32(ddlSeason.SelectedValue));
                     for (int i = 0; i < dt.Rows.Count; i++)
                     {
                         DateTime PlantationDate = objMudarApp.GenerateRandomDate(dtBasicFInfo.Rows[0]["PlantationFrom"].ToString(), dtBasicFInfo.Rows[0]["PlantationTo"].ToString());
                         int      FHCount        = MudarApp.RandomNumber(Convert.ToInt32(dtBasicFInfo.Rows[0]["1stCutFrom"].ToString()), Convert.ToInt32(dtBasicFInfo.Rows[0]["1stCutTo"].ToString()));
                         int      SHCount        = MudarApp.RandomNumber(Convert.ToInt32(dtBasicFInfo.Rows[0]["2ndCutFrom"].ToString()), Convert.ToInt32(dtBasicFInfo.Rows[0]["2ndCutTo"].ToString()));
                         // First Cut Estimation Herbage Qty
                         int FEHQty = MudarApp.RandomNumber(Convert.ToInt32(dtBasicFInfo.Rows[0]["Qty1stCutHCFrom"].ToString()), Convert.ToInt32(dtBasicFInfo.Rows[0]["Qty1stCutHCTo"].ToString()));
                         // Total Herbage firstcut (estimated)
                         decimal FHerQty = Math.Round((Convert.ToDecimal(dt.Rows[i]["PlantationArea"].ToString()) * FEHQty), 1);
                         // firstcut oil Estimation kgs
                         decimal FEoil = MudarApp.RandomNumber(Convert.ToDecimal(dtBasicFInfo.Rows[0]["1stRecoveryOilFrom"].ToString()), Convert.ToDecimal(dtBasicFInfo.Rows[0]["1stRecoveryOilTo"].ToString()));
                         // Total Oil firstcut(estimated)
                         decimal FOilEsti = Math.Round((FHerQty * FEoil), 1);
                         //  firstcut Estimation vs Actual Percentage
                         decimal FEsvsAt = (MudarApp.RandomNumber(Convert.ToDecimal(dtBasicFInfo.Rows[0]["EsvsAc_From"].ToString()), Convert.ToDecimal(dtBasicFInfo.Rows[0]["EsvsAc_To"].ToString()))) / 100;
                         // firstcut Actual Herbage
                         decimal FTHqty = Math.Round((FHerQty * FEsvsAt), 1);
                         // firstcut oil kgs
                         decimal FTOil = Math.Round((FOilEsti * FEsvsAt), 1);
                         // Second Cut Estimation Herbage Qty
                         int SEHQty = MudarApp.RandomNumber(Convert.ToInt32(dtBasicFInfo.Rows[0]["Qty2ndCutHCFrom"].ToString()), Convert.ToInt32(dtBasicFInfo.Rows[0]["Qty2ndCutHCTo"].ToString()));
                         // Total Herbage second cut (estimated)
                         decimal SHerQty = Math.Round((Convert.ToDecimal(dt.Rows[i]["PlantationArea"].ToString()) * SEHQty), 1);
                         // Second Cut oil Estimation kgs
                         decimal SEoil = MudarApp.RandomNumber(Convert.ToDecimal(dtBasicFInfo.Rows[0]["2ndRecoveryOilFrom"].ToString()), Convert.ToDecimal(dtBasicFInfo.Rows[0]["2ndRecoveryOilTo"].ToString()));
                         // Second Cut Total Oil (estimated)
                         decimal SOilEsti = Math.Round((SHerQty * SEoil), 1);
                         // Second Cut Estimation vs Actual  Percentage
                         decimal SEsvsAt = (MudarApp.RandomNumber(Convert.ToDecimal(dtBasicFInfo.Rows[0]["EsvsAc_From"].ToString()), Convert.ToDecimal(dtBasicFInfo.Rows[0]["EsvsAc_To"].ToString()))) / 100;
                         // Second Cut Actual Herbage Percentage
                         decimal STHqty = Math.Round((SHerQty * SEsvsAt), 1);
                         // Second Cut oil kgs
                         decimal STOil = Math.Round((SOilEsti * SEsvsAt), 1);
                         resutl = fp.sp_FarmerProduction_UPD(PlantationDate, PlantationDate.AddDays(FHCount), FTHqty, PlantationDate.AddDays(FHCount + 1), FTOil, PlantationDate.AddDays(FHCount + SHCount), SHerQty,
                                                             PlantationDate.AddDays(FHCount + SHCount + 1), STOil, FTOil + STOil, Convert.ToInt32(dt.Rows[i]["PlantationId"].ToString()), FHerQty, FOilEsti, SHerQty, SOilEsti);
                     }
                     if (resutl)
                     {
                         ClientScript.RegisterStartupScript(typeof(Page), "alert", "<script language=JavaScript>alert('!!! Update Data Successfully !!!');</script>");
                     }
                 }
             }
         }
         else
         {
             result = farmingObj.FarmingInfo_INSandUPDandDEL(Convert.ToInt32(ddlYear.SelectedValue), Convert.ToInt32(ddlProduct.SelectedValue), Convert.ToInt32(ddlSeason.SelectedValue), Convert.ToDateTime(txtPlantationFDate.Text), Convert.ToDateTime(txtPlantationTDate.Text), Convert.ToInt32(txt1stCutF.Text), Convert.ToInt32(txt1stCutT.Text), Convert.ToDecimal(txt1stHCF.Text), Convert.ToDecimal(txt1stHCT.Text), Convert.ToDecimal(txt1stOilF.Text), Convert.ToDecimal(txt1stOilT.Text), Convert.ToInt32(txt2ndCutF.Text), Convert.ToInt32(txt2ndCutT.Text), Convert.ToDecimal(txt2ndHCF.Text), Convert.ToDecimal(txt2ndHCT.Text), Convert.ToDecimal(txt2ndOilF.Text), Convert.ToDecimal(txt2ndOilT.Text), Convert.ToInt32(txtActualF.Text), Convert.ToInt32(txtActualTo.Text), "Aslam", "", MudarApp.Insert, 0);
             ClientScript.RegisterStartupScript(typeof(Page), "alert", "<script language=JavaScript>alert('!!! Saved Data Successfully !!!');</script>");
         }
         divBasicForm.Visible      = false;
         btnAddBasic.Visible       = false;
         divAllSeasonNames.Visible = true;
         btnAddBasic.Visible       = true;
         ClearControls();
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }