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