/// <summary>
/// to get the data from the database and bind it to the gridview
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>
private void BindGrid(bool addRow, bool deleteRow)
{
try
{
objSurveyBLL = new SurveyBLL();
objLandLivingOffList = new LandLivingOffList();
objLandLivingOffList = objSurveyBLL.GetLivingOFF(Convert.ToInt32(Session["HH_ID"]));
grdLandInfoRespondentsOff.DataSource = objLandLivingOffList;
grdLandInfoRespondentsOff.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// to save the data to the database
/// call ClearDetails() to clear the Details Fields
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
objSurveyLandLivingOff = new LandLivingOffBO();
objSurveyBLL = new SurveyBLL();
try
{
objSurveyLandLivingOff.LivingOffID = Convert.ToInt32(ViewState["LIVINGOFFID"]);
objSurveyLandLivingOff.HouseholdID = Convert.ToInt32(Session["HH_ID"]);
objSurveyLandLivingOff.DwellingID = Convert.ToInt32(ddlDwelling.SelectedValue);
objSurveyLandLivingOff.NoofRooms = txtNoRooms.Text.Trim();
objSurveyLandLivingOff.Str_TenureID = Convert.ToInt32(ddlTenureType.SelectedValue);
objSurveyLandLivingOff.RoofID = Convert.ToInt32(ddlRoof.SelectedValue);
objSurveyLandLivingOff.WallID = Convert.ToInt32(ddlWalls.SelectedValue);
objSurveyLandLivingOff.FloorID = Convert.ToInt32(ddlFloor.SelectedValue);
objSurveyLandLivingOff.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
if (!string.IsNullOrEmpty(txttenure.Text))
{
objSurveyLandLivingOff.Tenure = Convert.ToInt32(txttenure.Text);
}
else
{
objSurveyLandLivingOff.Tenure = 0;
}
int i = objSurveyBLL.AddLandLivingOFF(objSurveyLandLivingOff);
if (btnSave.Text == "Save")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('Data saved successfully');", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('Data updated successfully');", true);
}
ChangeRequestStatusLandInfoResOFF();
ClearDetails();
BindGrid(true, false);
SetUpdateMode(false);
projectFrozen();
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertError", "alert('Error: " + ex.Message + "');", true);
}
}
/// <summary>
/// Save and Update Data into Database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string message = string.Empty;
try
{
ChangeRequestStatusAcrValuation();
objAcreageValuation = new AffectedAcreageValuationBO();
objSurveyBLL = new SurveyBLL();
objAcreageValuation.HouseholdID = Convert.ToInt32(Session["HH_ID"]);
objAcreageValuation.Landowner = txtLandOwner.Text.Trim();
objAcreageValuation.Landblock = txtLandBlock.Text.Trim();
objAcreageValuation.Landplot = txtLandPlot.Text.Trim();
objAcreageValuation.Proprietorid = Convert.ToInt32(ddlCurrentOperation.SelectedValue);
objAcreageValuation.Wholeacreageacres = txtAcreageAcres.Text.Trim();
objAcreageValuation.Rowacres = Convert.ToDecimal(lblAcres.Text);
objAcreageValuation.Rowlandvalueshare = Convert.ToDecimal(ddlRowLandvalshare.SelectedValue);
objAcreageValuation.Rowrateperacre = Convert.ToDecimal(txtRatePerAcres.Text.Trim());
objAcreageValuation.Rowlandvalue = Convert.ToDecimal(lblRowLandVal.Text);
objAcreageValuation.Wlacres = Convert.ToDecimal(lblWayleavesAcres.Text);
objAcreageValuation.Wllandvalueshare = Convert.ToDecimal(ddlWayleaveShareLandVal.SelectedValue);
objAcreageValuation.Dimunitionlevel = Convert.ToDecimal(ddlDimunition.SelectedValue);
objAcreageValuation.Wlrateperacre = Convert.ToDecimal(txtWayleaveRateperAcres.Text.Trim());
objAcreageValuation.Wllandvalue = Convert.ToDecimal(lblWayleavelandVal.Text);
objAcreageValuation.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
objAcreageValuation.LocClassification = ddlLocClassification.SelectedValue;
message = objSurveyBLL.AddAffectedAcreageValuation(objAcreageValuation);
if (btnSave.Text == "Save")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "ShowSaveMessage('');", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "ShowUpdateMessage('');", true);
}
projectFrozen();
SetUpdateMode(true);
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('Error: " + ex.Message + "');", true);
}
}
/// <summary>
/// Get Affected Acreage Valuation Data
/// </summary>
private void GetAffectedAcreageValuation()
{
objSurveyBLL = new SurveyBLL();
objAcreageValuation = objSurveyBLL.GetAffectedAcreageValuation(Convert.ToInt32(Session["HH_ID"]));
if (objAcreageValuation != null)
{
txtLandOwner.Text = objAcreageValuation.Landowner;
txtLandBlock.Text = objAcreageValuation.Landblock;
txtLandPlot.Text = objAcreageValuation.Landplot;
//BindProprietor();
ddlCurrentOperation.ClearSelection();
if (ddlCurrentOperation.Items.FindByValue(objAcreageValuation.Proprietorid.ToString()) != null)
{
ddlCurrentOperation.Items.FindByValue(objAcreageValuation.Proprietorid.ToString()).Selected = true;
}
txtAcreageAcres.Text = objAcreageValuation.Wholeacreageacres;
txtRightWay.Text = Convert.ToString(objAcreageValuation.Rowacres);
lblAcres.Text = Convert.ToString(objAcreageValuation.Rowacres);
if (ddlRowLandvalshare.Items.FindByValue(objAcreageValuation.Rowlandvalueshare.ToString()) != null)
{
ddlRowLandvalshare.Items.FindByValue(objAcreageValuation.Rowlandvalueshare.ToString()).Selected = true;
}
txtRatePerAcres.Text = UtilBO.CurrencyFormat(objAcreageValuation.Rowrateperacre);
lblRowLandVal.Text = UtilBO.CurrencyFormat(objAcreageValuation.Rowlandvalue);//Convert.ToString(objAcreageValuation.Rowlandvalue);
txtWayleave.Text = Convert.ToString(objAcreageValuation.Wlacres);
lblWayleavesAcres.Text = Convert.ToString(objAcreageValuation.Wlacres);
if (ddlDimunition.Items.FindByValue(objAcreageValuation.Dimunitionlevel.ToString()) != null)
{
ddlDimunition.Items.FindByValue(objAcreageValuation.Dimunitionlevel.ToString()).Selected = true;
}
if (ddlWayleaveShareLandVal.Items.FindByValue(objAcreageValuation.Wllandvalueshare.ToString()) != null)
{
ddlWayleaveShareLandVal.Items.FindByValue(objAcreageValuation.Wllandvalueshare.ToString()).Selected = true;
}
txtWayleaveRateperAcres.Text = UtilBO.CurrencyFormat(objAcreageValuation.Wlrateperacre);
lblWayleavelandVal.Text = UtilBO.CurrencyFormat(objAcreageValuation.Wllandvalue);// Convert.ToString(objAcreageValuation.Wllandvalue);
if (txtRightWay.Text.Trim() != "" && txtWayleave.Text.Trim() != "")
{
lblTotal.Text = Math.Round((Convert.ToDecimal(txtRightWay.Text.Trim()) + Convert.ToDecimal(txtWayleave.Text.Trim())), 2).ToString("N2");
}
string str1 = txtAcreageAcres.Text.Trim();
if (string.IsNullOrEmpty(str1) == false)
{
double t = Convert.ToDouble(txtAcreageAcres.Text.Trim());
double Ha = Math.Round((t / acrehaconvert), 4);
txtAcreageHA.Text = Ha.ToString();
}
upnAcreageHA.Update();
RightOfWayUnitConversion(ddlMeasure.SelectedItem.Value);
WayLeaveUnitConversion(ddlMeasure.SelectedItem.Value);
TotalUnitConversion(ddlMeasure.SelectedItem.Value);
if (txtLandOwner.Text.Trim() == "")
{
SetUpdateMode(false);
}
else
{
SetUpdateMode(true);
}
}
}
/// <summary>
/// For Edit and delete command
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdLandInfoRespondentsOff_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["LIVINGOFFID"] = e.CommandArgument;
objSurveyBLL = new SurveyBLL();
objSurveyLandLivingOff = objSurveyBLL.GetLivingOFFByID(Convert.ToInt32(ViewState["LIVINGOFFID"]));
//bindDDLDwelling();
//bindDDLTenure();
//bindDDLRoofs();
//bindDDLWall();
//bindDDLFloor();
ddlDwelling.ClearSelection();
if (ddlDwelling.Items.FindByValue(objSurveyLandLivingOff.DwellingID.ToString()) != null)
{
ddlDwelling.Items.FindByValue(objSurveyLandLivingOff.DwellingID.ToString()).Selected = true;
}
ddlTenureType.ClearSelection();
if (ddlTenureType.Items.FindByValue(objSurveyLandLivingOff.Str_TenureID.ToString()) != null)
{
ddlTenureType.Items.FindByValue(objSurveyLandLivingOff.Str_TenureID.ToString()).Selected = true;
}
ddlRoof.ClearSelection();
if (ddlRoof.Items.FindByValue(objSurveyLandLivingOff.RoofID.ToString()) != null)
{
ddlRoof.Items.FindByValue(objSurveyLandLivingOff.RoofID.ToString()).Selected = true;
}
ddlWalls.ClearSelection();
if (ddlWalls.Items.FindByValue(objSurveyLandLivingOff.WallID.ToString()) != null)
{
ddlWalls.Items.FindByValue(objSurveyLandLivingOff.WallID.ToString()).Selected = true;
}
ddlFloor.ClearSelection();
if (ddlFloor.Items.FindByValue(objSurveyLandLivingOff.FloorID.ToString()) != null)
{
ddlFloor.Items.FindByValue(objSurveyLandLivingOff.FloorID.ToString()).Selected = true;
}
txtNoRooms.Text = objSurveyLandLivingOff.NoofRooms;
//ddlTenureType.ClearSelection();
//if (ddlTenureType.Items.FindByValue(objSurveyLandLivingOff.Str_Tenure.ToString()) != null)
// ddlTenureType.Items.FindByValue(objSurveyLandLivingOff.Str_Tenure.ToString()).Selected = true;
if (objSurveyLandLivingOff.Tenure > 0)
{
txttenure.Text = objSurveyLandLivingOff.Tenure.ToString();
}
SetUpdateMode(true);
}
else if (e.CommandName == "DeleteRow")
{
int livingoffID = Convert.ToInt32(e.CommandArgument);
objSurveyBLL = new SurveyBLL();
objSurveyBLL.DeleteLivingOFF(livingoffID);
ClearDetails();
BindGrid(false, true);
SetUpdateMode(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data deleted successfully');", true);
}
}
/// <summary>
/// to get the Land info fro the database
/// </summary>
private void GetLandInfo()
{
SurveyBLL objSurveyBLL = new SurveyBLL();
LandLivingOnBO objSurvey = objSurveyBLL.GetLandLivingOnByHHID(Convert.ToInt32(Session["HH_ID"]));
if (objSurvey != null)
{
txtLivingbefore.Text = objSurvey.WhereLivedBefore;
//txtVillage.Text = objSurvey.PreferredVillege;
if (objSurvey.IsOtherLandHold == "Yes")
{
chkLandHold.Checked = true;
txtYesLandHold.Text = objSurvey.WhichLandHold;
txtYesLandHold.Enabled = true;
}
else if (objSurvey.IsOtherLandHold == "No")
{
chkLandHold.Checked = false;
txtYesLandHold.Text = "";
txtYesLandHold.Enabled = false;
}
if (objSurvey.RequireTransport == "Yes")
{
chkTransport.Checked = true;
}
else if (objSurvey.RequireTransport == "No")
{
chkTransport.Checked = false;
}
if (objSurvey.MovenearRelatives == "Yes")
{
chkRelative.Checked = true;
}
else if (objSurvey.MovenearRelatives == "No")
{
chkRelative.Checked = false;
}
if (objSurvey.BuriedFamilyMemonLand == "Yes")
{
chkFamilyMember.Checked = true;
txtBuried.Enabled = true;
}
else if (objSurvey.BuriedFamilyMemonLand == "No")
{
chkFamilyMember.Checked = false;
txtBuried.Enabled = false;
}
txtBuried.Text = objSurvey.HowmanyBuried;
if (objSurvey.RelocateAncestors == "Yes")
{
chkAncestors.Checked = true;
}
else if (objSurvey.RelocateAncestors == "No")
{
chkAncestors.Checked = false;
}
ddlDistrict.ClearSelection();
if (ddlDistrict.Items.FindByText(objSurvey.District) != null)
{
ddlDistrict.Items.FindByText(objSurvey.District).Selected = true;
}
if (ddlDistrict.SelectedIndex > 0)
{
BindCounties(ddlDistrict.SelectedItem.Value);
if (Convert.ToString(objSurvey.County) != "")
{
ddlCounty.ClearSelection();
if (ddlCounty.Items.FindByText(objSurvey.County) != null)
{
ddlCounty.Items.FindByText(objSurvey.County).Selected = true;
}
}
}
if (ddlCounty.SelectedIndex > 0)
{
BindSubCounties(ddlCounty.SelectedItem.Value);
if (Convert.ToString(objSurvey.Subcounty) != "")
{
ddlSubCounty.ClearSelection();
if (ddlSubCounty.Items.FindByText(objSurvey.Subcounty) != null)
{
ddlSubCounty.Items.FindByText(objSurvey.Subcounty).Selected = true;
}
}
}
if (ddlSubCounty.SelectedIndex > 0)
{
BindVillages(ddlSubCounty.SelectedItem.Value);
if (Convert.ToString(objSurvey.Village) != "")
{
ddlVillage.ClearSelection();
if (ddlVillage.Items.FindByText(objSurvey.Village) != null)
{
ddlVillage.Items.FindByText(objSurvey.Village).Selected = true;
}
}
}
}
}
/// <summary>
/// to save the data to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
ChangeRequestStatusLandInfoResOn();
LandLivingOnBO objLand = new LandLivingOnBO();
try
{
string message = string.Empty;
objLand.HouseholdID = Convert.ToInt32(Session["HH_ID"]);
objLand.WhereLivedBefore = txtLivingbefore.Text.Trim();
//objLand.PreferredVillege = txtVillage.Text.Trim();
objLand.District = ddlDistrict.SelectedItem.Text;
objLand.County = ddlCounty.SelectedItem.Text;
objLand.Subcounty = ddlSubCounty.SelectedItem.Text;
objLand.Village = ddlVillage.SelectedItem.Text;
if (chkLandHold.Checked == true)
{
objLand.IsOtherLandHold = "Yes";
objLand.WhichLandHold = txtYesLandHold.Text.Trim();
txtYesLandHold.Enabled = true;
}
else if (chkLandHold.Checked == false)
{
objLand.IsOtherLandHold = "No";
objLand.WhichLandHold = "";
txtYesLandHold.Enabled = false;
}
if (chkTransport.Checked == true)
{
objLand.RequireTransport = "Yes";
}
else if (chkTransport.Checked == false)
{
objLand.RequireTransport = "No";
}
if (chkRelative.Checked == true)
{
objLand.MovenearRelatives = "Yes";
}
else if (chkRelative.Checked == false)
{
objLand.MovenearRelatives = "No";
}
if (chkFamilyMember.Checked == true)
{
objLand.BuriedFamilyMemonLand = "Yes";
objLand.HowmanyBuried = txtBuried.Text.Trim();
txtBuried.Enabled = true;
}
else if (chkFamilyMember.Checked == false)
{
objLand.BuriedFamilyMemonLand = "No";
objLand.HowmanyBuried = "";
txtBuried.Enabled = false;
}
if (chkAncestors.Checked == true)
{
objLand.RelocateAncestors = "Yes";
}
else if (chkAncestors.Checked == false)
{
objLand.RelocateAncestors = "No";
}
objLand.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
SurveyBLL objSurveyBLL = new SurveyBLL();
message = objSurveyBLL.AddLandLivingOn(objLand);
if (message == "I")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('Data saved successfully');", true);
}
else if (message == "U")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('Data updated successfully');", true);
}
projectFrozen();
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertError", "alert('Error: " + ex.Message + "');", true);
}
}
