protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Master.MasterControlbtnFarmerPlantation(); ListItemCollection items = MudarApp.BindYear(); foreach (ListItem item in items) { ddlFarmerYear.Items.Add(item); ddlAllFarmerYear.Items.Add(item); ddlFPYear.Items.Add(item); } ddlUnitDetails.DataSource = fp.BindDropDownChild(); ddlUnitDetails.DataTextField = "Name"; ddlUnitDetails.DataValueField = "UnitId"; ddlUnitDetails.DataBind(); BindddlCultivation(1); gvFarmerList.DataSource = far.FamerDetails(); gvFarmerList.DataBind(); } }
private void BindSeasonYear() { //ListItemCollection items = MudarApp.BindYear(); //foreach (ListItem item in items) // ddlSeasonYear.Items.Add(item); ////for (int count = 0; count < Convert.ToInt32(WebConfigurationManager.AppSettings["SeasonYearCount"].ToString()); count++) //// ddlSeasonYear.Items.Add((new ListItem()).Text = DateTime.Now.AddYears(count).Year.ToString()); //ddlSeasonYear.DataBind(); //ddlSeasonYear.SelectedValue = DateTime.Now.Year.ToString(); DataTable Seasond = cpObj.GetSeasonDetails(); if (Seasond.Rows.Count > 0) { ddlSeasonYear.DataSource = Seasond.DefaultView.ToTable(true, "SeasonYear"); ddlSeasonYear.DataTextField = "SeasonYear"; ddlSeasonYear.DataValueField = "SeasonYear"; ddlSeasonYear.DataBind(); ddlSeasonYear.Items.Insert(0, MudarApp.AddListItem()); ddlSeasonYear.SelectedValue = DateTime.Now.Year.ToString(); } }
//private void BindSeaDetailsList() //{ // ddlSelectSeason.DataSource = cp.GetSeasonDetails(); // ddlSelectSeason.DataTextField = "SeasonName"; // ddlSelectSeason.DataValueField = "SeasonID"; // ddlSelectSeason.DataBind(); // ddlSelectSeason.Items.Insert(0, MudarApp.AddListItem()); //} private void BindSeasonYear() { ListItemCollection items = MudarApp.BindYear(); foreach (ListItem item in items) { ddlSeasonYear.Items.Add(item); } ddlSeasonYear.DataBind(); ddlSeasonYear.SelectedValue = DateTime.Now.Year.ToString(); //ListItemCollection items = MudarApp.BindYear(); //foreach (ListItem item in items) // ddlSeasonYear.Items.Add(item); //for (int count = 0; count < Convert.ToInt32(WebConfigurationManager.AppSettings["SeasonYearCount"].ToString()); count++) // ddlSeasonYear.Items.Add((new ListItem()).Text = DateTime.Now.AddYears(count).Year.ToString()); //ddlSeasonYear.DataBind(); //ddlSeasonYear.SelectedValue = DateTime.Now.Year.ToString(); //DataTable temp = cp.GetSeasonDetails(); //if (temp.Rows.Count > 0) //{ // ddlSeasonYear.DataSource = temp.DefaultView.ToTable(true, "SeasonYear"); // ddlSeasonYear.DataTextField = "SeasonYear"; // ddlSeasonYear.DataValueField = "SeasonYear"; // ddlSeasonYear.DataBind(); // string currYear = Convert.ToString(DateTime.Now.Year); // IEnumerable<DataRow> query = temp.AsEnumerable().Where(m => m.Field<int>("SeasonYear") == DateTime.Now.Year); // if (query.Count() <= 0) // { // ListItem lstItem = new ListItem(currYear, currYear); // ddlSeasonYear.Items.Add(lstItem); // ddlSeasonYear.DataBind(); // } // ddlSeasonYear.SelectedValue = currYear; //} }
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); } }