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