/// <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>
/// To Add Affected Acreage Valuation
/// </summary>
/// <param name="objAffectedAcreageValuation"></param>
/// <returns></returns>
public string AddAffectedAcreageValuation(AffectedAcreageValuationBO objAffectedAcreageValuation)
{
string result = "";
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_TRN_PAP_LND_VALUATION", myConnection);
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("HHID_", objAffectedAcreageValuation.HouseholdID);
myCommand.Parameters.Add("LANDOWNER_", objAffectedAcreageValuation.Landowner);
myCommand.Parameters.Add("LANDBLOCK_", objAffectedAcreageValuation.Landblock);
myCommand.Parameters.Add("LANDPLOT_", objAffectedAcreageValuation.Landplot);
if (objAffectedAcreageValuation.Proprietorid > 0)
{
myCommand.Parameters.Add("PROPRIETORID_", objAffectedAcreageValuation.Proprietorid);
}
else
{
myCommand.Parameters.Add("PROPRIETORID_", DBNull.Value);
}
myCommand.Parameters.Add("WHOLEACREAGEACRES_", objAffectedAcreageValuation.Wholeacreageacres);
myCommand.Parameters.Add("ROWACRES_", objAffectedAcreageValuation.Rowacres);
myCommand.Parameters.Add("ROWLANDVALUESHARE_", objAffectedAcreageValuation.Rowlandvalueshare);
myCommand.Parameters.Add("ROWRATEPERACRE_", objAffectedAcreageValuation.Rowrateperacre);
myCommand.Parameters.Add("ROWLANDVALUE_", objAffectedAcreageValuation.Rowlandvalue);
myCommand.Parameters.Add("WLACRES_", objAffectedAcreageValuation.Wlacres);
myCommand.Parameters.Add("DIMUNITIONLEVEL_", objAffectedAcreageValuation.Dimunitionlevel);
myCommand.Parameters.Add("WLRATEPERACRE_", objAffectedAcreageValuation.Wlrateperacre);
myCommand.Parameters.Add("WLLANDVALUESHARE_", objAffectedAcreageValuation.Wllandvalueshare);
myCommand.Parameters.Add("WLLANDVALUE_", objAffectedAcreageValuation.Wllandvalue);
myCommand.Parameters.Add("UPDATEDBY_", objAffectedAcreageValuation.UpdatedBy);
myCommand.Parameters.Add("Class_", objAffectedAcreageValuation.LocClassification);
myCommand.Parameters.Add("errormessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
myConnection.Open();
myCommand.ExecuteNonQuery();
if (myCommand.Parameters["errormessage_"].Value != null)
{
result = myCommand.Parameters["errormessage_"].Value.ToString();
}
myConnection.Close();
return(result);
}
/// <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>
/// To Get Affected Acreage Valuation
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public AffectedAcreageValuationBO GetAffectedAcreageValuation(int HHID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_GET_TRN_PAP_LND_VALUATION";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", HHID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
AffectedAcreageValuationBO obSurvey = null;
while (dr.Read())
{
obSurvey = new AffectedAcreageValuationBO();
if (!dr.IsDBNull(dr.GetOrdinal("LANDOWNER")))
{
obSurvey.Landowner = dr.GetString(dr.GetOrdinal("LANDOWNER"));
}
if (!dr.IsDBNull(dr.GetOrdinal("LANDBLOCK")))
{
obSurvey.Landblock = dr.GetString(dr.GetOrdinal("LANDBLOCK"));
}
if (!dr.IsDBNull(dr.GetOrdinal("LANDPLOT")))
{
obSurvey.Landplot = dr.GetString(dr.GetOrdinal("LANDPLOT"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PROPRIETORID")))
{
obSurvey.Proprietorid = dr.GetInt32(dr.GetOrdinal("PROPRIETORID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("WHOLEACREAGEACRES")))
{
obSurvey.Wholeacreageacres = dr.GetString(dr.GetOrdinal("WHOLEACREAGEACRES"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ROWACRES")))
{
obSurvey.Rowacres = dr.GetDecimal(dr.GetOrdinal("ROWACRES"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ROWLANDVALUESHARE")))
{
obSurvey.Rowlandvalueshare = dr.GetDecimal(dr.GetOrdinal("ROWLANDVALUESHARE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ROWRATEPERACRE")))
{
obSurvey.Rowrateperacre = dr.GetDecimal(dr.GetOrdinal("ROWRATEPERACRE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ROWLANDVALUE")))
{
obSurvey.Rowlandvalue = dr.GetDecimal(dr.GetOrdinal("ROWLANDVALUE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("WLACRES")))
{
obSurvey.Wlacres = dr.GetDecimal(dr.GetOrdinal("WLACRES"));
}
if (!dr.IsDBNull(dr.GetOrdinal("DIMUNITIONLEVEL")))
{
obSurvey.Dimunitionlevel = dr.GetDecimal(dr.GetOrdinal("DIMUNITIONLEVEL"));
}
if (!dr.IsDBNull(dr.GetOrdinal("WLRATEPERACRE")))
{
obSurvey.Wlrateperacre = dr.GetDecimal(dr.GetOrdinal("WLRATEPERACRE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("WLLANDVALUESHARE")))
{
obSurvey.Wllandvalueshare = dr.GetDecimal(dr.GetOrdinal("WLLANDVALUESHARE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("WLLANDVALUE")))
{
obSurvey.Wllandvalue = dr.GetDecimal(dr.GetOrdinal("WLLANDVALUE"));
}
}
dr.Close();
return(obSurvey);
}
/// <summary>
/// To Add Affected Acreage Valuation
/// </summary>
/// <param name="objAffectedAcreageValuation"></param>
/// <returns></returns>
public string AddAffectedAcreageValuation(AffectedAcreageValuationBO objAffectedAcreageValuation)
{
SurveyDAL objAddAffectedAcreageValuationDAL = new SurveyDAL();
return(objAddAffectedAcreageValuationDAL.AddAffectedAcreageValuation(objAffectedAcreageValuation));
}
