/// <summary>
/// To Get Compensation Financial By ID
/// </summary>
/// <param name="CompensationFinancialID"></param>
/// <returns></returns>
public CompensationFinancialBO GetCompensationFinancialByID(int CompensationFinancialID)
{
proc = "USP_MST_GET_CompensationFinancialBYID";
cnn = new OracleConnection(con);
CompensationFinancialBO objCompensationFinancial = null;
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CompensationFinancialID_", CompensationFinancialID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objCompensationFinancial = new CompensationFinancialBO();
objCompensationFinancial = MapData(dr);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(objCompensationFinancial);
}
/// <summary>
/// To Update Compensation Financial Closing Info
/// </summary>
/// <param name="oCompensationFinancial"></param>
/// <returns></returns>
public string AddPackageDeliveryInfo(CompensationFinancialBO oCompensationFinancial)
{
cnn = new OracleConnection(con);
string returnResult = string.Empty;
proc = "USP_TRN_CMP_INS_DELIVERY";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("HHID_", oCompensationFinancial.HHID);
if (oCompensationFinancial.DeliveredBy != 0)
{
cmd.Parameters.Add("deliveredby_", oCompensationFinancial.DeliveredBy);
}
else
{
cmd.Parameters.Add("deliveredby_", DBNull.Value);
}
cmd.Parameters.Add("PAPAction_", oCompensationFinancial.PAPAction);
if (!string.IsNullOrEmpty(oCompensationFinancial.DeliveryComments))
{
cmd.Parameters.Add("deliverycomments_", oCompensationFinancial.DeliveryComments);
}
else
{
cmd.Parameters.Add("deliverycomments_", DBNull.Value);
}
string dt = oCompensationFinancial.DeliveryDate.ToString().Substring(0, 8);
if (dt == "1/1/0001")
{
cmd.Parameters.Add("deliverydate_", DBNull.Value);
}
else
{
cmd.Parameters.Add("deliverydate_", oCompensationFinancial.DeliveryDate);
}
cmd.Parameters.Add("createdby_", oCompensationFinancial.CreatedBy);
cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["errorMessage_"].Value != null)
{
returnResult = cmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
cmd.Connection.Close();
return(returnResult);
}
/// <summary>
/// To Add Compensation Financial
/// </summary>
/// <param name="oCompensationFinancial"></param>
/// <returns></returns>
public string AddCompensationFinancial(CompensationFinancialBO oCompensationFinancial)
{
CompensationFinancialDAL oCompensationFinancialDAL = new CompensationFinancialDAL();
try
{
return(oCompensationFinancialDAL.AddCompensationFinancial(oCompensationFinancial));
}
catch (Exception ex)
{
throw ex;
}
finally
{
oCompensationFinancial = null;
}
}
/// <summary>
/// To Update Compensation Financial Closing Info
/// </summary>
/// <param name="oCompensationFinancial"></param>
/// <returns></returns>
public string UpdateCompFinancial_ClosingInfo(CompensationFinancialBO oCompensationFinancial)
{
//From Clsoing Info Summery:
CompensationFinancialDAL oCompensationFinancialDAL = new CompensationFinancialDAL();
try
{
return(oCompensationFinancialDAL.UpdateCompFinancial_ClosingInfo(oCompensationFinancial));
}
catch (Exception ex)
{
throw ex;
}
finally
{
oCompensationFinancial = null;
}
}
/// <summary>
/// To Get Compensation Financial
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public CompensationFinancialBO GetCompensationFinancial(int HHID)
{
proc = "USP_TRN_GET_CMP_FINANCIALS";
cnn = new OracleConnection(con);
CompensationFinancialBO oCompensationFinancial = null;
CompensationFinancialList lstCompensationFinancial = new CompensationFinancialList();
CompensationFinancialBO OCompensationFinancial = new CompensationFinancialBO();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("hhid_", HHID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oCompensationFinancial = new CompensationFinancialBO();
oCompensationFinancial = MapData(dr);
lstCompensationFinancial.Add(oCompensationFinancial);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
if (lstCompensationFinancial.Count > 0)
{
return(lstCompensationFinancial[lstCompensationFinancial.Count - 1]);
}
else
{
return(oCompensationFinancial);
}
}
/// <summary>
/// To Update Compensation Financial Closing Info
/// </summary>
/// <param name="objCompensationFinancial"></param>
/// <returns></returns>
public string UpdateCompFinancial_ClosingInfo(CompensationFinancialBO objCompensationFinancial)
{
cnn = new OracleConnection(con);
string returnResult = string.Empty;
proc = "USP_TRN_CMP_UPD_FINCLOSINGINFO";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("hhid_", objCompensationFinancial.HHID);
cmd.Parameters.Add("resinkindcompensation_", objCompensationFinancial.ResInKindCompensation);
cmd.Parameters.Add("updatedby", objCompensationFinancial.UpdatedBy);
cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
if (cmd.Parameters["errorMessage_"].Value != null)
{
returnResult = cmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch (Exception ex)
{
throw;
}
finally
{
cmd.Connection.Close();
}
return(returnResult);
}
/// <summary>
/// To Update Compensation Financial Payment
/// </summary>
/// <param name="objCompensationFinancialBO"></param>
public void UpdateCompensationFinancialPayment(CompensationFinancialBO objCompensationFinancialBO)
{
cnn = new OracleConnection(con);
string returnResult = string.Empty;
proc = "USP_TRN_UPD_CMP_FIN_PAYMENT";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("HHID_", objCompensationFinancialBO.HHID);
cmd.Parameters.Add("CMP_PAYMENTID_", objCompensationFinancialBO.CompPaymentId);
cmd.Parameters.Add("LANDVALUATIONPAID_", objCompensationFinancialBO.LandPaidValuation);
cmd.Parameters.Add("RESVALUATIONPAID_", objCompensationFinancialBO.ResPaidValuation);
cmd.Parameters.Add("FIXTUREVALUATIONPAID_", objCompensationFinancialBO.FixturePaidValuation);
cmd.Parameters.Add("CROPVALUATIONPAID_", objCompensationFinancialBO.CropPaidValuation);
cmd.Parameters.Add("CULTUREVALUATIONPAID_", objCompensationFinancialBO.CulturePropPaidValuation);
cmd.Parameters.Add("DAMAGEDCROPVALUATIONPAID_", objCompensationFinancialBO.DamagedCropPaidValuation);
cmd.Parameters.Add("FACILITATIONALLOWANCEPAID_", objCompensationFinancialBO.FacilitationAllowancePaid);
cmd.Parameters.Add("NEGOTIATEDAMOUNTPAID_", objCompensationFinancialBO.NegotiatedAmountPaid);
cmd.ExecuteNonQuery();
}
/// <summary>
/// To Update Compensation Financial Payment
/// </summary>
/// <param name="objCompensationFinancialBO"></param>
public void UpdateCompensationFinancialPayment(CompensationFinancialBO objCompensationFinancialBO)
{
CompensationFinancialDAL CompensationFinancialDALObj = new CompensationFinancialDAL();
CompensationFinancialDALObj.UpdateCompensationFinancialPayment(objCompensationFinancialBO);
}
/// <summary>
/// To Add Package Delivery Info
/// </summary>
/// <param name="oCompensationFinancial"></param>
/// <returns></returns>
public string AddPackageDeliveryInfo(CompensationFinancialBO oCompensationFinancial)
{
CompensationFinancialDAL oCompensationFinancialDAL = new CompensationFinancialDAL();
return(oCompensationFinancialDAL.AddPackageDeliveryInfo(oCompensationFinancial));
}
/// <summary>
/// Get the data from data base
/// </summary>
private void LoadData()
{
CompensationFinancialBO oCompensationFinancial = new CompensationFinancialBO();
//oCompensationFinancial.Cmp_FinancialID = "";
oCompensationFinancial.HHID = Convert.ToInt32(Session["HH_ID"]);
CompensationFinancialBLL oCompensationFinancialBLL = new CompensationFinancialBLL();
oCompensationFinancial = oCompensationFinancialBLL.GetCompensationFinancial(Convert.ToInt32(Session["HH_ID"]));
if (oCompensationFinancial != null)
{
//LAND SECTION
#region Land Section
txtLandValuation.Text = UtilBO.CurrencyFormat(oCompensationFinancial.LandValuation);//oCompensationFinancial.LandValuation.ToString();
if (oCompensationFinancial.LandDA > 0)
{
txtLandDAinPercentage.Text = oCompensationFinancial.LandDA.ToString();
}
txtAcreageDifferencePayment.Text = UtilBO.CurrencyFormat(oCompensationFinancial.LandDiffPayment); //oCompensationFinancial.LandDiffPayment.ToString();
//if (!string.IsNullOrEmpty(txtLandValuation.Text) && !string.IsNullOrEmpty(txtLandDAinAmount.Text))
// oCompensationFinancial.LandTotalValuation = Convert.ToDecimal(txtLandValuation.Text.Trim()) + Convert.ToDecimal(txtLandDAinAmount.Text.Trim());
txtLandTotal.Text = UtilBO.CurrencyFormat(oCompensationFinancial.LandTotalValuation); //oCompensationFinancial.LandTotalValuation.ToString();
txtLandDAinAmount.Text = UtilBO.CurrencyFormat(oCompensationFinancial.LandTotalValuation - oCompensationFinancial.LandValuation); //(oCompensationFinancial.LandTotalValuation - oCompensationFinancial.LandValuation).ToString();
txtLandComments.Text = oCompensationFinancial.LandValComments;
#endregion
//RESIDENTIAL STRUCTURE
#region Residencial Structure
txtRSDepreciatedValue.Text = UtilBO.CurrencyFormat(oCompensationFinancial.ResDepreciatedValue); //oCompensationFinancial.ResDepreciatedValue.ToString();
txtRSReplacementValue.Text = UtilBO.CurrencyFormat(oCompensationFinancial.ResReplacementValue); //oCompensationFinancial.ResReplacementValue.ToString();
if (oCompensationFinancial.ResDA > 0)
{
txtRSDAinPercentage.Text = oCompensationFinancial.ResDA.ToString();
}
txtRSMovingAllowance.Text = UtilBO.CurrencyFormat(oCompensationFinancial.ResMovingAllowance); //oCompensationFinancial.ResMovingAllowance.ToString();
txtRSLabourCost.Text = UtilBO.CurrencyFormat(oCompensationFinancial.ResLabourCost); //oCompensationFinancial.ResLabourCost.ToString();
txtRSPaymentHighHouseValue.Text = UtilBO.CurrencyFormat(oCompensationFinancial.ResPayment); //oCompensationFinancial.ResPayment.ToString();
//if (!string.IsNullOrEmpty(txtRSReplacementValue.Text) && !string.IsNullOrEmpty(txtResidentialDAinAmount.Text))//Calculated mannually
// oCompensationFinancial.ResTotalValuation = Convert.ToDecimal(txtRSReplacementValue.Text.Trim()) + Convert.ToDecimal(txtResidentialDAinAmount.Text.Trim());
//txtResidentialDAinAmount.Text = UtilBO.CurrencyFormat(oCompensationFinancial.ResTotalValuation - oCompensationFinancial.ResReplacementValue); //(oCompensationFinancial.ResTotalValuation - oCompensationFinancial.ResReplacementValue).ToString();
txtResidentialStructureComments.Text = oCompensationFinancial.ResComments;
#endregion
//FIXTURES
#region Fixture Section
txtFixturesValuation.Text = UtilBO.CurrencyFormat(oCompensationFinancial.FixtureValuation); //oCompensationFinancial.FixtureValuation.ToString();
if (oCompensationFinancial.FixtureDA > 0)
{
txtFixturesDAinPercentage.Text = oCompensationFinancial.FixtureDA.ToString();
}
//if (!string.IsNullOrEmpty(txtFixturesDAinAmount.Text) && !string.IsNullOrEmpty(txtFixturesValuation.Text))
// oCompensationFinancial.FixtureTotalValuation = Convert.ToDecimal(txtFixturesDAinAmount.Text.Trim()) + Convert.ToDecimal(txtFixturesValuation.Text.Trim());
txtFixturesDAinAmount.Text = UtilBO.CurrencyFormat(oCompensationFinancial.FixtureTotalValuation - oCompensationFinancial.FixtureValuation); //(oCompensationFinancial.FixtureTotalValuation - oCompensationFinancial.FixtureValuation).ToString();
txtRSDepreciatedValue.Text = UtilBO.CurrencyFormat(oCompensationFinancial.ResDepreciatedValue); //oCompensationFinancial.ResDepreciatedValue.ToString();
txtFixturesComments.Text = oCompensationFinancial.FixtureComments;
#endregion
//CROPS
#region Crops Section
txtCropsValuation.Text = UtilBO.CurrencyFormat(oCompensationFinancial.CropValuation); //oCompensationFinancial.CropValuation.ToString();
//CheckBox
if (oCompensationFinancial.CropMaxCapCase != null)
{
if (oCompensationFinancial.CropMaxCapCase.ToUpper() == "YES")
{
chkMaxCapCase.Checked = true;
}
else
{
chkMaxCapCase.Checked = false;
}
}
else
{
chkMaxCapCase.Checked = false;
}
txtValuationAfterMaxCap.Text = UtilBO.CurrencyFormat(oCompensationFinancial.CropValAftMaxCap); //oCompensationFinancial.CropValAftMaxCap.ToString();
if (oCompensationFinancial.CropDA > 0)
{
txtCropsDAinPercentage.Text = oCompensationFinancial.CropDA.ToString();
}
//if (!string.IsNullOrEmpty(txtCropsValuation.Text) && !string.IsNullOrEmpty(txtCropsDAinAmount.Text))
// oCompensationFinancial.CropTotalValuation = Convert.ToDecimal(txtCropsValuation.Text.Trim()) + Convert.ToDecimal(txtCropsDAinAmount.Text.Trim());
if (oCompensationFinancial.CropMaxCapCase.ToUpper() == "YES")
{
if (!string.IsNullOrEmpty(txtValuationAfterMaxCap.Text) && !string.IsNullOrEmpty(txtCropsDAinAmount.Text))
{
oCompensationFinancial.CropTotalValuation = Convert.ToDecimal(txtValuationAfterMaxCap.Text.Trim()) + Convert.ToDecimal(txtCropsDAinAmount.Text.Trim());
}
}
else
{
if (!string.IsNullOrEmpty(txtCropsValuation.Text) && !string.IsNullOrEmpty(txtCropsDAinAmount.Text))
{
oCompensationFinancial.CropTotalValuation = Convert.ToDecimal(txtCropsValuation.Text.Trim()) + Convert.ToDecimal(txtCropsDAinAmount.Text.Trim());
}
}
txtCropsDAinAmount.Text = UtilBO.CurrencyFormat(oCompensationFinancial.CropTotalValuation - oCompensationFinancial.CropValuation); //(oCompensationFinancial.CropTotalValuation - oCompensationFinancial.CropValuation).ToString();
txtCropsComments.Text = oCompensationFinancial.CropComments;
#endregion
//OTHERS
#region Others
txtCompensationForCultureProperty.Text = UtilBO.CurrencyFormat(oCompensationFinancial.CulturePropValuation); //oCompensationFinancial.CulturePropValuation.ToString();
txtOtherDamagedCrops.Text = UtilBO.CurrencyFormat(oCompensationFinancial.DamagedCropValuation); //oCompensationFinancial.DamagedCropValuation.ToString();
//if (!string.IsNullOrEmpty(txtCulturePropertyValue.Text) && !string.IsNullOrEmpty(txtOtherDamagedCrops.Text))
// oCompensationFinancial.TotalOtherValuation = Convert.ToDecimal(txtCulturePropertyValue.Text.Trim()) + Convert.ToDecimal(txtOtherDamagedCrops.Text.Trim());
txtOthersTotal.Text = UtilBO.CurrencyFormat(oCompensationFinancial.CulturePropValuation + oCompensationFinancial.DamagedCropValuation); //(oCompensationFinancial.CulturePropValuation + oCompensationFinancial.DamagedCropValuation).ToString();
#endregion
//SUMMERY
#region Summery Section
txtNegotiatedAmount.Text = UtilBO.CurrencyFormat(oCompensationFinancial.NegotiatedAmount);
decimal RDAllowance = (oCompensationFinancial.ResDepreciatedValue * oCompensationFinancial.FixtureDA) / 100;
decimal SummeryFixturesValue = (((oCompensationFinancial.FixtureValuation * oCompensationFinancial.FixtureDA) / 100) + oCompensationFinancial.FixtureValuation);
txtSummeryFixturesValue.Text = UtilBO.CurrencyFormat(SummeryFixturesValue); //SummeryFixturesValue.ToString();
decimal DamagedCropsValue = (((oCompensationFinancial.CropValuation * oCompensationFinancial.CropDA) / 100) + oCompensationFinancial.CropValuation);
txtDamagedCropsValue.Text = UtilBO.CurrencyFormat(DamagedCropsValue); // DamagedCropsValue.ToString();
txtDamagedCropsValue.Text = txtOtherDamagedCrops.Text;
txtCulturePropertyValue.Text = txtCompensationForCultureProperty.Text;
txtInKindLand.Text = oCompensationFinancial.LandInKindCompensation.ToString().Trim();
ddlResidentialStructure.ClearSelection();
if (string.IsNullOrEmpty(oCompensationFinancial.ResInKindCompensation))
{
ddlResidentialStructure.SelectedValue = "0";
}
else
{
ddlResidentialStructure.SelectedValue = oCompensationFinancial.ResInKindCompensation.ToString();
}
txtFacilitationallowances.Text = UtilBO.CurrencyFormat(oCompensationFinancial.FacilitationAllowance);
//if (!string.IsNullOrEmpty(txtRSDepreciatedValue.Text))
// oCompensationFinancial.ResDepreciatedValue = Convert.ToDecimal(txtRSDepreciatedValue.Text.Trim());
#endregion
//PACKAGE DELIVERY INFO
#region Package Delivery Section
CompensationFinancialBO ooCompensationFinancial = new CompensationFinancialBO();
ooCompensationFinancial = oCompensationFinancialBLL.getPackageDeliveryInfo(SessionHHID);
if (ooCompensationFinancial != null)
{
if (ooCompensationFinancial.DeliveryDate != DateTime.MinValue)
{
dpDeliveryDate.Text = ooCompensationFinancial.DeliveryDate.ToString(UtilBO.DateFormat);
}
else
{
dpDeliveryDate.Text = "";
}
if (ooCompensationFinancial.PAPAction == "Y")
{
rdoActionAccepted.Checked = true;
}
else if (ooCompensationFinancial.PAPAction == "N")
{
rdoActionRejected.Checked = true;
}
ddlDeliveredBy.SelectedValue = ooCompensationFinancial.DeliveredBy.ToString();
txtPackageDeliveryInfoComments.Text = ooCompensationFinancial.DeliveryComments;
}
#endregion Package Delivery Section
hdnDoCalc.Value = "1";
btnSave.Text = "Update";
}
else
{
FinalValuationBLL oFinalValuationBLL = new FinalValuationBLL();
FinalValuationBO oFinalValuationBO = new FinalValuationBO();
if (SessionHHID > 0)
{
oFinalValuationBO = oFinalValuationBLL.getFinalValuatin(SessionHHID);
if (oFinalValuationBO != null)
{
txtLandValuation.Text = UtilBO.CurrencyFormat(oFinalValuationBO.LandValue); //oFinalValuationBO.LandValue.ToString();
txtCropsValuation.Text = UtilBO.CurrencyFormat(oFinalValuationBO.CropValue); //oFinalValuationBO.CropValue.ToString();
txtFixturesValuation.Text = UtilBO.CurrencyFormat(oFinalValuationBO.FixtureValue); //oFinalValuationBO.FixtureValue.ToString();
txtHouseValues.Text = UtilBO.CurrencyFormat(oFinalValuationBO.HouseValue); //oFinalValuationBO.HouseValue.ToString();
txtReplacementHouseValue.Text = UtilBO.CurrencyFormat(oFinalValuationBO.ReplacementValue); //oFinalValuationBO.ReplacementValue.ToString();
txtCompensationForCultureProperty.Text = UtilBO.CurrencyFormat(oFinalValuationBO.CulturalpropertyValue); //oFinalValuationBO.CulturalpropertyValue.ToString();
txtOtherDamagedCrops.Text = UtilBO.CurrencyFormat(oFinalValuationBO.DamagedcropValue); // oFinalValuationBO.DamagedcropValue.ToString();
txtOthersTotal.Text = UtilBO.CurrencyFormat(oFinalValuationBO.CulturalpropertyValue + oFinalValuationBO.DamagedcropValue); //(oFinalValuationBO.CulturalpropertyValue + oFinalValuationBO.DamagedcropValue).ToString();
txtDamagedCropsValue.Text = UtilBO.CurrencyFormat(oFinalValuationBO.DamagedcropValue); //oFinalValuationBO.DamagedcropValue.ToString();
txtCulturePropertyValue.Text = UtilBO.CurrencyFormat(oFinalValuationBO.CulturalpropertyValue); //oFinalValuationBO.CulturalpropertyValue.ToString();
txtRSDepreciatedValue.Text = UtilBO.CurrencyFormat(oFinalValuationBO.HouseValue); //oFinalValuationBO.HouseValue.ToString();
txtRSReplacementValue.Text = UtilBO.CurrencyFormat(oFinalValuationBO.ReplacementValue); //oFinalValuationBO.ReplacementValue.ToString();
txtNegotiatedAmount.Text = UtilBO.CurrencyFormat(oFinalValuationBO.NegotiatedAmount); //oFinalValuationBO.NegotiatedAmount.ToString();
txtRSLabourCost.Text = UtilBO.CurrencyFormat(oFinalValuationBO.ResLabourCost);
//txtFacilitationallowances.Text = "0";
txtFacilitationallowances.Text = UtilBO.CurrencyFormat(oFinalValuationBO.GOUAllowance);
if (oFinalValuationBO.Crop_Max_Cap_Case.ToLower() == "yes")
{
chkMaxCapCase.Checked = true;
}
else
{
chkMaxCapCase.Checked = false;
}
txtValuationAfterMaxCap.Text = UtilBO.CurrencyFormat(oFinalValuationBO.Crop_Val_Aft_Max_Cap);
hdnDoCalc.Value = "1";
ScriptManager.RegisterStartupScript(this, this.GetType(), "CalTotal", "CalcLandTotal();CalcResidenitalTotal();CalcFixtureTotal();CalcCropTotal();CalcOtherTotal();FindTotalAmount();", true);
}
}
}
}
public string UpdateCompensationFinancial(CompensationFinancialBO oCompensationFinancialBO)
{
string returnResult = string.Empty;
OracleConnection OCon = new OracleConnection(con);
OCon.Open();
OracleCommand oCmd = new OracleCommand("USP_TRN_UPD_CMP_PAYMENTSUMMERY", OCon);
oCmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(oCmd.CommandType);
try
{
oCmd.Parameters.Add("hhid_", oCompensationFinancialBO.HHID);
oCmd.Parameters.Add("facilitationallowance_", oCompensationFinancialBO.FacilitationAllowance);
if (oCompensationFinancialBO.LandInKindCompensation == 0 || oCompensationFinancialBO.LandInKindCompensation == -1)
{
oCmd.Parameters.Add("resinkindcompensation_", DBNull.Value);
}
else
{
oCmd.Parameters.Add("resinkindcompensation_", oCompensationFinancialBO.LandInKindCompensation);
}
if (oCompensationFinancialBO.ResInKindCompensation == "0" || oCompensationFinancialBO.ResInKindCompensation == "-1")
{
oCmd.Parameters.Add("resinkindcompensation_", DBNull.Value);
}
else
{
oCmd.Parameters.Add("resinkindcompensation_", oCompensationFinancialBO.ResInKindCompensation);
}
oCmd.Parameters.Add("updatedby_", oCompensationFinancialBO.UpdatedBy);
oCmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
oCmd.ExecuteNonQuery(); //Executing Query
if (oCmd.Parameters["errorMessage_"].Value != null)
{
returnResult = oCmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch
{
throw;
}
finally
{
oCmd.Dispose();
OCon.Close();
OCon.Dispose();
}
return(returnResult);
}
/// <summary>
/// To get Package Delivery Info
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public CompensationFinancialBO getPackageDeliveryInfo(int HHID)
{
proc = "USP_TRN_CMP_GET_DELIVERY";
cnn = new OracleConnection(con);
CompensationFinancialBO objCompensationFinancial = null;
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("hhid_", HHID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objCompensationFinancial = new CompensationFinancialBO();
if (!dr.IsDBNull(dr.GetOrdinal("Cmp_DeliveryId")))
{
objCompensationFinancial.Cmp_DeliveryId = dr.GetInt32(dr.GetOrdinal("Cmp_DeliveryId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
{
objCompensationFinancial.HHID = dr.GetInt32(dr.GetOrdinal("HHID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("DeliveryDate")))
{
objCompensationFinancial.DeliveryDate = dr.GetDateTime(dr.GetOrdinal("DeliveryDate"));
}
if (!dr.IsDBNull(dr.GetOrdinal("DeliveredBy")))
{
objCompensationFinancial.DeliveredBy = dr.GetInt32(dr.GetOrdinal("DeliveredBy"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PAPAction")))
{
objCompensationFinancial.PAPAction = dr.GetString(dr.GetOrdinal("PAPAction"));
}
if (!dr.IsDBNull(dr.GetOrdinal("DeliveryComments")))
{
objCompensationFinancial.DeliveryComments = dr.GetString(dr.GetOrdinal("DeliveryComments"));
}
// Edwin: 30JUN2016 - Fix wrong delivery date issue
if (!dr.IsDBNull(dr.GetOrdinal("CreatedDate")))
{
objCompensationFinancial.DeliveryCreatedDate = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("CreatedDate")));
}
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(objCompensationFinancial);
}
/// <summary>
/// To Map Data
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private CompensationFinancialBO MapData(IDataReader reader)
{
CompensationFinancialBO oCompFinancial = new CompensationFinancialBO();
try
{
if (ColumnExists(reader, "Cmp_FinancialID") && !reader.IsDBNull(reader.GetOrdinal("Cmp_FinancialID")))
{
oCompFinancial.Cmp_FinancialID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Cmp_FinancialID")));
}
if (ColumnExists(reader, "HHID") && !reader.IsDBNull(reader.GetOrdinal("HHID")))
{
oCompFinancial.HHID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("HHID")));
}
#region Land Section
if (ColumnExists(reader, "LandValuation") && !reader.IsDBNull(reader.GetOrdinal("LandValuation")))
{
oCompFinancial.LandValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("LandValuation")));
}
if (ColumnExists(reader, "LANDVALUATIONPAID") && !reader.IsDBNull(reader.GetOrdinal("LANDVALUATIONPAID")))
{
oCompFinancial.LandPaidValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("LANDVALUATIONPAID")));
}
if (ColumnExists(reader, "LandDA") && !reader.IsDBNull(reader.GetOrdinal("LandDA")))
{
oCompFinancial.LandDA = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("LandDA")));
}
if (ColumnExists(reader, "LandInKindCompensation") && !reader.IsDBNull(reader.GetOrdinal("LandInKindCompensation")))
{
oCompFinancial.LandInKindCompensation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("LandInKindCompensation")));
}
if (ColumnExists(reader, "LandDiffPayment") && !reader.IsDBNull(reader.GetOrdinal("LandDiffPayment")))
{
oCompFinancial.LandDiffPayment = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("LandDiffPayment")));
}
if (ColumnExists(reader, "LandValComments") && !reader.IsDBNull(reader.GetOrdinal("LandValComments")))
{
oCompFinancial.LandValComments = reader.GetString(reader.GetOrdinal("LandValComments"));
}
if (ColumnExists(reader, "LANDTOTALVALUATION") && !reader.IsDBNull(reader.GetOrdinal("LANDTOTALVALUATION")))
{
oCompFinancial.LandTotalValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("LANDTOTALVALUATION")));
}
#endregion
#region Residential Structure Section
if (ColumnExists(reader, "ResDepreciatedValue") && !reader.IsDBNull(reader.GetOrdinal("ResDepreciatedValue")))
{
oCompFinancial.ResDepreciatedValue = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("ResDepreciatedValue")));
}
if (ColumnExists(reader, "RESVALUATIONPAID") && !reader.IsDBNull(reader.GetOrdinal("RESVALUATIONPAID")))
{
oCompFinancial.ResPaidValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("RESVALUATIONPAID")));
}
if (ColumnExists(reader, "ResReplacementValue") && !reader.IsDBNull(reader.GetOrdinal("ResReplacementValue")))
{
oCompFinancial.ResReplacementValue = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("ResReplacementValue")));
}
if (ColumnExists(reader, "ResDA") && !reader.IsDBNull(reader.GetOrdinal("ResDA")))
{
oCompFinancial.ResDA = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("ResDA")));
}
if (ColumnExists(reader, "ResMovingAllowance") && !reader.IsDBNull(reader.GetOrdinal("ResMovingAllowance")))
{
oCompFinancial.ResMovingAllowance = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("ResMovingAllowance")));
}
if (ColumnExists(reader, "ResLabourCost") && !reader.IsDBNull(reader.GetOrdinal("ResLabourCost")))
{
oCompFinancial.ResLabourCost = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("ResLabourCost")));
}
if (ColumnExists(reader, "ResPayment") && !reader.IsDBNull(reader.GetOrdinal("ResPayment")))
{
oCompFinancial.ResPayment = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("ResPayment")));
}
if (ColumnExists(reader, "ResInKindCompensation") && !reader.IsDBNull(reader.GetOrdinal("ResInKindCompensation")))
{
// string testing = reader.GetString(reader.GetOrdinal("ResInKindCompensation"));
oCompFinancial.ResInKindCompensation = reader.GetString(reader.GetOrdinal("ResInKindCompensation"));
}
if (ColumnExists(reader, "ResComments") && !reader.IsDBNull(reader.GetOrdinal("ResComments")))
{
oCompFinancial.ResComments = reader.GetString(reader.GetOrdinal("ResComments"));
}
if (ColumnExists(reader, "RESTOTALVALUATION") && !reader.IsDBNull(reader.GetOrdinal("RESTOTALVALUATION")))
{
oCompFinancial.ResTotalValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("RESTOTALVALUATION")));
}
#endregion
#region Fixture Section
if (ColumnExists(reader, "FixtureValuation") && !reader.IsDBNull(reader.GetOrdinal("FixtureValuation")))
{
oCompFinancial.FixtureValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("FixtureValuation")));
}
if (ColumnExists(reader, "FIXTUREVALUATIONPAID") && !reader.IsDBNull(reader.GetOrdinal("FIXTUREVALUATIONPAID")))
{
oCompFinancial.FixturePaidValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("FIXTUREVALUATIONPAID")));
}
if (ColumnExists(reader, "FixtureDA") && !reader.IsDBNull(reader.GetOrdinal("FixtureDA")))
{
oCompFinancial.FixtureDA = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("FixtureDA")));
}
if (ColumnExists(reader, "FixtureTotalValuation") && !reader.IsDBNull(reader.GetOrdinal("FixtureTotalValuation")))
{
oCompFinancial.FixtureTotalValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("FixtureTotalValuation")));
}
if (ColumnExists(reader, "FixtureComments") && !reader.IsDBNull(reader.GetOrdinal("FixtureComments")))
{
oCompFinancial.FixtureComments = reader.GetString(reader.GetOrdinal("FixtureComments"));
}
if (ColumnExists(reader, "FIXTURETOTALVALUATION") && !reader.IsDBNull(reader.GetOrdinal("FIXTURETOTALVALUATION")))
{
oCompFinancial.FixtureTotalValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("FIXTURETOTALVALUATION")));
}
#endregion
#region Crops Section
if (ColumnExists(reader, "CropValuation") && !reader.IsDBNull(reader.GetOrdinal("CropValuation")))
{
oCompFinancial.CropValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("CropValuation")));
}
if (ColumnExists(reader, "CROPVALUATIONPAID") && !reader.IsDBNull(reader.GetOrdinal("CROPVALUATIONPAID")))
{
oCompFinancial.CropPaidValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("CROPVALUATIONPAID")));
}
if (ColumnExists(reader, "CropMaxCapCase") && !reader.IsDBNull(reader.GetOrdinal("CropMaxCapCase")))
{
oCompFinancial.CropMaxCapCase = reader.GetString(reader.GetOrdinal("CropMaxCapCase"));
}
if (ColumnExists(reader, "CropValAftMaxCap") && !reader.IsDBNull(reader.GetOrdinal("CropValAftMaxCap")))
{
oCompFinancial.CropValAftMaxCap = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("CropValAftMaxCap")));
}
if (ColumnExists(reader, "CropDA") && !reader.IsDBNull(reader.GetOrdinal("CropDA")))
{
oCompFinancial.CropDA = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("CropDA")));
}
if (ColumnExists(reader, "CropComments") && !reader.IsDBNull(reader.GetOrdinal("CropComments")))
{
oCompFinancial.CropComments = reader.GetString(reader.GetOrdinal("CropComments"));
}
if (ColumnExists(reader, "CROPTOTALVALUATION") && !reader.IsDBNull(reader.GetOrdinal("CROPTOTALVALUATION")))
{
oCompFinancial.CropTotalValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("CROPTOTALVALUATION")));
}
#endregion
#region Summery Section
if (ColumnExists(reader, "CulturePropValuation") && !reader.IsDBNull(reader.GetOrdinal("CulturePropValuation")))
{
oCompFinancial.CulturePropValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("CulturePropValuation")));
}
if (ColumnExists(reader, "DamagedCropValuation") && !reader.IsDBNull(reader.GetOrdinal("DamagedCropValuation")))
{
oCompFinancial.DamagedCropValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("DamagedCropValuation")));
}
if (ColumnExists(reader, "CULTUREVALUATIONPAID") && !reader.IsDBNull(reader.GetOrdinal("CULTUREVALUATIONPAID")))
{
oCompFinancial.CulturePropPaidValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("CULTUREVALUATIONPAID")));
}
if (ColumnExists(reader, "DAMAGEDCROPVALUATIONPAID") && !reader.IsDBNull(reader.GetOrdinal("DAMAGEDCROPVALUATIONPAID")))
{
oCompFinancial.DamagedCropPaidValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("DAMAGEDCROPVALUATIONPAID")));
}
if (ColumnExists(reader, "TotalValuation"))
{
if (!reader.IsDBNull(reader.GetOrdinal("TotalValuation")))
{
oCompFinancial.TotalValuation = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("TotalValuation")));
}
}
if (ColumnExists(reader, "NegotiatedAmount") && !reader.IsDBNull(reader.GetOrdinal("NegotiatedAmount")))
{
oCompFinancial.NegotiatedAmount = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("NegotiatedAmount")));
}
if (ColumnExists(reader, "NEGOTIATEDAMOUNTPAID") && !reader.IsDBNull(reader.GetOrdinal("NEGOTIATEDAMOUNTPAID")))
{
oCompFinancial.NegotiatedAmountPaid = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("NEGOTIATEDAMOUNTPAID")));
}
if (ColumnExists(reader, "FACILITATIONALLOWANCE") && !reader.IsDBNull(reader.GetOrdinal("FACILITATIONALLOWANCE")))
{
oCompFinancial.FacilitationAllowance = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("FACILITATIONALLOWANCE")));
}
if (ColumnExists(reader, "FACILITATIONALLOWANCEPAID") && !reader.IsDBNull(reader.GetOrdinal("FACILITATIONALLOWANCEPAID")))
{
oCompFinancial.FacilitationAllowancePaid = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("FACILITATIONALLOWANCEPAID")));
}
#endregion
#region Common Section
/* if (ColumnExists(reader, "IsDeleted") && !reader.IsDBNull(reader.GetOrdinal("IsDeleted")))
* oCompFinancial.IsDeleted = reader.GetString(reader.GetOrdinal("IsDeleted"));
*
* if (ColumnExists(reader, "CreatedDate") && !reader.IsDBNull(reader.GetOrdinal("CreatedDate")))
* oCompFinancial.CreatedDate = reader.GetString(reader.GetOrdinal("CreatedDate"));
*
* if (ColumnExists(reader, "CreatedBy") && !reader.IsDBNull(reader.GetOrdinal("CreatedBy")))
* oCompFinancial.CreatedBy = Convert.ToInt32(reader.GetString(reader.GetOrdinal("CreatedBy")));
*
* if (ColumnExists(reader, "UpdatedDate") && !reader.IsDBNull(reader.GetOrdinal("UpdatedDate")))
* oCompFinancial.UpdatedDate = reader.GetString(reader.GetOrdinal("UpdatedDate"));
*
* if (ColumnExists(reader, "UpdatedBy") && !reader.IsDBNull(reader.GetOrdinal("UpdatedBy")))
* oCompFinancial.UpdatedBy = Convert.ToInt32(reader.GetString(reader.GetOrdinal("UpdatedBy")));*/
#endregion
if (ColumnExists(reader, "LAND_APPROVAL_STATUS") && !reader.IsDBNull(reader.GetOrdinal("LAND_APPROVAL_STATUS")))
{
oCompFinancial.Land_Approval_Status = reader.GetString(reader.GetOrdinal("LAND_APPROVAL_STATUS"));
}
if (ColumnExists(reader, "REPLACMENT_APPROVAL_STATUS") && !reader.IsDBNull(reader.GetOrdinal("REPLACMENT_APPROVAL_STATUS")))
{
oCompFinancial.Replacment_Approval_Status = reader.GetString(reader.GetOrdinal("REPLACMENT_APPROVAL_STATUS"));
}
if (ColumnExists(reader, "FIXTURE_APPROVAL_STATUS") && !reader.IsDBNull(reader.GetOrdinal("FIXTURE_APPROVAL_STATUS")))
{
oCompFinancial.Fixture_Approval_Status = reader.GetString(reader.GetOrdinal("FIXTURE_APPROVAL_STATUS"));
}
if (ColumnExists(reader, "CROP_APPROVAL_STATUS") && !reader.IsDBNull(reader.GetOrdinal("CROP_APPROVAL_STATUS")))
{
oCompFinancial.Crop_Approval_Status = reader.GetString(reader.GetOrdinal("CROP_APPROVAL_STATUS"));
}
//if (ColumnExists(reader, "LandValComments") && !reader.IsDBNull(reader.GetOrdinal("LandValComments")))
// oCompFinancial.LandValComments = reader.GetString(reader.GetOrdinal("LandValComments"));
if (ColumnExists(reader, "CULTURE_APPROVAL_STATUS") && !reader.IsDBNull(reader.GetOrdinal("CULTURE_APPROVAL_STATUS")))
{
oCompFinancial.Culture_Approval_Status = reader.GetString(reader.GetOrdinal("CULTURE_APPROVAL_STATUS"));
}
if (ColumnExists(reader, "DAMAGED_APPROVAL_STATUS") && !reader.IsDBNull(reader.GetOrdinal("DAMAGED_APPROVAL_STATUS")))
{
oCompFinancial.Damaged_Approval_Status = reader.GetString(reader.GetOrdinal("DAMAGED_APPROVAL_STATUS"));
}
if (!reader.IsDBNull(reader.GetOrdinal("FACI_APPROVAL_STATUS")))
{
oCompFinancial.Facilitation_Approval_Status = reader.GetValue(reader.GetOrdinal("FACI_APPROVAL_STATUS")).ToString();
}
if (ColumnExists(reader, "FINAL_APPROVAL_STATUS") && !reader.IsDBNull(reader.GetOrdinal("FINAL_APPROVAL_STATUS")))
{
oCompFinancial.Final_Approval_Status = reader.GetString(reader.GetOrdinal("FINAL_APPROVAL_STATUS"));
}
if (ColumnExists(reader, "NEGO_AMOUNT_APPROVAL_STATUS") && !reader.IsDBNull(reader.GetOrdinal("NEGO_AMOUNT_APPROVAL_STATUS")))
{
oCompFinancial.Nego_Amount_Approval_Status = reader.GetString(reader.GetOrdinal("NEGO_AMOUNT_APPROVAL_STATUS"));
}
}
catch (Exception ex)
{ throw ex; }
return(oCompFinancial);
}
/// <summary>
/// To Add Compensation Financial
/// </summary>
/// <param name="oCompensationFinancial"></param>
/// <returns></returns>
public string AddCompensationFinancial(CompensationFinancialBO oCompensationFinancial)
{
cnn = new OracleConnection(con);
string returnResult = string.Empty;
proc = "USP_TRN_INS_CMP_FINANCIALS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("HHID_", oCompensationFinancial.HHID);
//LAND SECTION
cmd.Parameters.Add("LandValuation_", oCompensationFinancial.LandValuation);
cmd.Parameters.Add("LandDA_", oCompensationFinancial.LandDA);
cmd.Parameters.Add("landtotalvaluation_", oCompensationFinancial.LandTotalValuation);
cmd.Parameters.Add("LandDiffPayment_", oCompensationFinancial.LandDiffPayment);
cmd.Parameters.Add("LandValComments_", oCompensationFinancial.LandValComments);
//RESIDENTIAL STRUCTURE SECTION
cmd.Parameters.Add("ResDepreciatedValue_", oCompensationFinancial.ResDepreciatedValue);
cmd.Parameters.Add("ResReplacementValue_", oCompensationFinancial.ResReplacementValue);
cmd.Parameters.Add("ResDA_", oCompensationFinancial.ResDA);
cmd.Parameters.Add("ResMovingAllowance_", oCompensationFinancial.ResMovingAllowance);
cmd.Parameters.Add("ResLabourCost_", oCompensationFinancial.ResLabourCost);
cmd.Parameters.Add("ResPayment_", oCompensationFinancial.ResPayment);
cmd.Parameters.Add("rescomments_", oCompensationFinancial.ResComments);
cmd.Parameters.Add("restotalvaluation_", oCompensationFinancial.ResTotalValuation);
//FIXTURES SECTION
cmd.Parameters.Add("FixtureValuation_", oCompensationFinancial.FixtureValuation);
cmd.Parameters.Add("FixtureDA_", oCompensationFinancial.FixtureDA);
cmd.Parameters.Add("FixtureTotalValuation_", oCompensationFinancial.FixtureTotalValuation);
cmd.Parameters.Add("FixtureComments_", oCompensationFinancial.FixtureComments);
//CROP SECTION
cmd.Parameters.Add("CropValuation_", oCompensationFinancial.CropValuation);
cmd.Parameters.Add("CropMaxCapCase_", oCompensationFinancial.CropMaxCapCase);
cmd.Parameters.Add("CropValAftMaxCap_", oCompensationFinancial.CropValAftMaxCap);
cmd.Parameters.Add("CropDA_", oCompensationFinancial.CropDA);
cmd.Parameters.Add("croptotalvaluation_", oCompensationFinancial.CropTotalValuation);
cmd.Parameters.Add("CropComments_", oCompensationFinancial.CropComments);
//SUMMERY SECTION
cmd.Parameters.Add("CulturePropValuation_", oCompensationFinancial.CulturePropValuation);
cmd.Parameters.Add("DamagedCropValuation_", oCompensationFinancial.DamagedCropValuation);
cmd.Parameters.Add("totalothervaluation_", oCompensationFinancial.TotalOtherValuation);
cmd.Parameters.Add("NegotiatedAmount_", oCompensationFinancial.NegotiatedAmount);
cmd.Parameters.Add("LandInKindCompensation_", oCompensationFinancial.LandInKindCompensation);
cmd.Parameters.Add("resinkindcompensation_", oCompensationFinancial.ResInKindCompensation);
cmd.Parameters.Add("FacilitationAllowance_", oCompensationFinancial.FacilitationAllowance);
//COMMON SECTION
cmd.Parameters.Add("isdeleted_", oCompensationFinancial.IsDeleted);
cmd.Parameters.Add("createdby_", oCompensationFinancial.CreatedBy);
cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["errorMessage_"].Value != null)
{
returnResult = cmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
cmd.Connection.Close();
return(returnResult);
}
/// <summary>
/// Load Summery Details
/// </summary>
private void LoadSummery()
{
CompensationFinancialBLL oCompensationFinancialBLL = new CompensationFinancialBLL();
CompensationFinancialBO oCompensationFinancial = oCompensationFinancialBLL.GetCompensationFinancial(Convert.ToInt32(Session["HH_ID"]));
// Replaced on 08jan2013 ResPayment as ResTotalValuation
if (oCompensationFinancial != null)
{
txtLandValuation.Text = UtilBO.CurrencyFormat(oCompensationFinancial.LandTotalValuation); //oCompensationFinancial.LandTotalValuation.ToString();
txtFixturesValuation.Text = UtilBO.CurrencyFormat(oCompensationFinancial.FixtureTotalValuation); //oCompensationFinancial.FixtureTotalValuation.ToString();
txtCropsValuation.Text = UtilBO.CurrencyFormat(oCompensationFinancial.CropTotalValuation); //oCompensationFinancial.CropTotalValuation.ToString();
//decimal ReplacementHouseValue = oCompensationFinancial.ResReplacementValue + (oCompensationFinancial.ResReplacementValue * oCompensationFinancial.ResDA) / 100;
txtReplacementHouseValue.Text = UtilBO.CurrencyFormat(oCompensationFinancial.ResPayment); //UtilBO.CurrencyFormat(oCompensationFinancial.ResTotalValuation);ResPayment //oCompensationFinancial.ResTotalValuation.ToString();//ReplacementHouseValue.ToString();
txtDamagedCropValue.Text = UtilBO.CurrencyFormat(oCompensationFinancial.DamagedCropValuation); //oCompensationFinancial.DamagedCropValuation.ToString();
txtCultureProperty.Text = UtilBO.CurrencyFormat(oCompensationFinancial.CulturePropValuation); //oCompensationFinancial.DamagedCropValuation.ToString();
txtFacilitation.Text = UtilBO.CurrencyFormat(oCompensationFinancial.FacilitationAllowance);
txtFinalCompensation.Text = UtilBO.CurrencyFormat(oCompensationFinancial.LandTotalValuation + oCompensationFinancial.FixtureTotalValuation +
oCompensationFinancial.CropTotalValuation + oCompensationFinancial.ResPayment +
oCompensationFinancial.DamagedCropValuation + oCompensationFinancial.CulturePropValuation + oCompensationFinancial.FacilitationAllowance); //oCompensationFinancial.TotalValuation.ToString();
txtNegotiatedAmount.Text = UtilBO.CurrencyFormat(oCompensationFinancial.NegotiatedAmount); //oCompensationFinancial.NegotiatedAmount.ToString();//Newly Added
txtInKindLand.Text = oCompensationFinancial.LandInKindCompensation.ToString().Trim();
ddlResidentialStructure.ClearSelection();
if (string.IsNullOrEmpty(oCompensationFinancial.ResInKindCompensation))
{
ddlResidentialStructure.ClearSelection();
}
else
{
if (ddlResidentialStructure.Items.FindByValue(oCompensationFinancial.ResInKindCompensation.ToString()) != null)
{
ddlResidentialStructure.ClearSelection();
ddlResidentialStructure.Items.FindByValue(oCompensationFinancial.ResInKindCompensation.ToString()).Selected = true;
}
}
txtResidentialStructure.Text = "";
if (ddlResidentialStructure.SelectedIndex > 0)
{
txtResidentialStructure.Text = ddlResidentialStructure.SelectedItem.Text;
}
//Displaying LABEL APPROVAL STATUS
//--------------------------------------------LAND STATUS-----------------------------------------------------
if (oCompensationFinancial.Land_Approval_Status != null && oCompensationFinancial.Land_Approval_Status.ToUpper() == "APPROVED")
{
lblLandValuationMsg.Text = "<font class='StatusApproved'>" + oCompensationFinancial.Land_Approval_Status + "</font>";
}
else
{
lblLandValuationMsg.Text = "<font class='StatusPending'>" + oCompensationFinancial.Land_Approval_Status + "</font>";
}
//--------------------------------------------FIXTURE STATUS-----------------------------------------------------
if (oCompensationFinancial.Fixture_Approval_Status != null && oCompensationFinancial.Fixture_Approval_Status.ToUpper() == "APPROVED")
{
lblFixturesValuationMsg.Text = "<font class='StatusApproved'>" + oCompensationFinancial.Fixture_Approval_Status + "</font>";
}
else
{
lblFixturesValuationMsg.Text = "<font class='StatusPending'>" + oCompensationFinancial.Fixture_Approval_Status + "</font>";
}
//--------------------------------------------CROP STATUS-----------------------------------------------------
if (oCompensationFinancial.Crop_Approval_Status != null && oCompensationFinancial.Crop_Approval_Status.ToUpper() == "APPROVED")
{
lblCropsValuationMsg.Text = "<font class='StatusApproved'>" + oCompensationFinancial.Crop_Approval_Status + "</font>";
}
else
{
lblCropsValuationMsg.Text = "<font class='StatusPending'>" + oCompensationFinancial.Crop_Approval_Status + "</font>";
}
//--------------------------------------------REPLACEMENT STATUS-----------------------------------------------------
if (oCompensationFinancial.Replacment_Approval_Status != null && oCompensationFinancial.Replacment_Approval_Status.ToUpper() == "APPROVED")
{
lblReplacementHouseValueMsg.Text = "<font class='StatusApproved'>" + oCompensationFinancial.Replacment_Approval_Status + "</font>";
}
else
{
lblReplacementHouseValueMsg.Text = "<font class='StatusPending'>" + oCompensationFinancial.Replacment_Approval_Status + "</font>";
}
//--------------------------------------------DAMAGED STATUS-----------------------------------------------------
if (oCompensationFinancial.Damaged_Approval_Status != null && oCompensationFinancial.Damaged_Approval_Status.ToUpper() == "APPROVED")
{
lblDamagedCropValueMsg.Text = "<font class='StatusApproved'>" + oCompensationFinancial.Damaged_Approval_Status + "</font>";
}
else
{
lblDamagedCropValueMsg.Text = "<font class='StatusPending'>" + oCompensationFinancial.Damaged_Approval_Status + "</font>";
}
//--------------------------------------------CULTURE PROPERTIES STATUS-----------------------------------------------------
if (oCompensationFinancial.Culture_Approval_Status != null && oCompensationFinancial.Culture_Approval_Status.ToUpper() == "APPROVED")
{
lblCulturePropertyMsg.Text = "<font class='StatusApproved'>" + oCompensationFinancial.Culture_Approval_Status + "</font>";
}
else
{
lblCulturePropertyMsg.Text = "<font class='StatusPending'>" + oCompensationFinancial.Culture_Approval_Status + "</font>";
}
//--------------------------------------------FACILITATION PROPERTIES STATUS-----------------------------------------------------
if (oCompensationFinancial.Facilitation_Approval_Status != null && oCompensationFinancial.Facilitation_Approval_Status.ToUpper() == "APPROVED")
{
lblFacilitationMsg.Text = "<font class='StatusApproved'>" + oCompensationFinancial.Facilitation_Approval_Status + "</font>";
}
else
{
lblFacilitationMsg.Text = "<font class='StatusPending'>" + oCompensationFinancial.Facilitation_Approval_Status + "</font>";
}
//--------------------------------------------FINAL STATUS-----------------------------------------------------
if (oCompensationFinancial.Final_Approval_Status != null && oCompensationFinancial.Final_Approval_Status.ToUpper() == "APPROVED")
{
lblFinalCompensationMsg.Text = "<font class='StatusApproved'>" + oCompensationFinancial.Final_Approval_Status + "</font>";
}
else
{
lblFinalCompensationMsg.Text = "<font class='StatusPending'>" + oCompensationFinancial.Final_Approval_Status + "</font>";
}
//--------------------------------------------NEGOTIATED STATUS-----------------------------------------------------
if (oCompensationFinancial.Nego_Amount_Approval_Status != null && oCompensationFinancial.Nego_Amount_Approval_Status.ToUpper() == "APPROVED")
{
lblNegotiatedAmountMsg.Text = "<font class='StatusApproved'>" + oCompensationFinancial.Nego_Amount_Approval_Status + "</font>";
}
else
{
lblNegotiatedAmountMsg.Text = "<font class='StatusPending'>" + oCompensationFinancial.Nego_Amount_Approval_Status + "</font>";
}
//Disabling Checkbox For Approved & Request Pending & Submitted
string LAS = oCompensationFinancial.Land_Approval_Status;
string FAS = oCompensationFinancial.Fixture_Approval_Status;
string CAL = oCompensationFinancial.Crop_Approval_Status;
string RAL = oCompensationFinancial.Replacment_Approval_Status;
string DAL = oCompensationFinancial.Damaged_Approval_Status;
string CPAL = oCompensationFinancial.Culture_Approval_Status;
string OPAL = oCompensationFinancial.Facilitation_Approval_Status;
string FCAL = oCompensationFinancial.Final_Approval_Status;
string NAAS = oCompensationFinancial.Nego_Amount_Approval_Status;
int statusCount = 0;
int chkcount = 7;
int cl = 1, cf = 1, cc = 1, cd = 1, cr = 1, cneg = 0, ccu = 1, co = 1;
// start
if ((txtLandValuation.Text.Trim() == "" || oCompensationFinancial.LandTotalValuation == 0) &&
(txtInKindLand.Text.Trim() == "" || oCompensationFinancial.LandInKindCompensation == 0))
{
chkLandValuation.Style.Add("display", "none");
chkcount--;
cl = 0;
}
if (txtFixturesValuation.Text.Trim() == "" || oCompensationFinancial.FixtureTotalValuation == 0)
{
chkFixtureValuation.Style.Add("display", "none");
chkcount--;
cf = 0;
}
if (txtCropsValuation.Text.Trim() == "" || oCompensationFinancial.CropTotalValuation == 0)
{
chkCropsValuation.Style.Add("display", "none");
chkcount--;
cc = 0;
}
if ((txtReplacementHouseValue.Text.Trim() == "" || oCompensationFinancial.ResPayment == 0) && (txtResidentialStructure.Text.Trim() == "" || txtResidentialStructure.Text.Trim().ToUpper() == "NA"))
{
chkReplacementHouseValue.Style.Add("display", "none");
chkcount--;
cr = 0;
}
if (txtDamagedCropValue.Text.Trim() == "" || oCompensationFinancial.DamagedCropValuation == 0)
{
chkDamagedCropValue.Style.Add("display", "none");
chkcount--;
cd = 0;
}
if (txtCultureProperty.Text.Trim() == "" || oCompensationFinancial.CulturePropValuation == 0)
{
chkCulturePropertyValue.Style.Add("display", "none");
chkcount--;
ccu = 0;
}
if (txtFacilitation.Text.Trim() == "" || oCompensationFinancial.FacilitationAllowance == 0)
{
chkFacilitationValue.Style.Add("display", "none");
chkcount--;
co = 0;
}
if ((cl + cf + cc + cd + cr + ccu + co) <= 0)
{
ChkAll.Style.Add("display", "none");
}
chkcount = 7;
//if (txtFinalCompensation.Text.Trim() == "" || oCompensationFinancial.TotalValuation == 0)
// chkFinalCompensation.Style.Add("display", "none");
if (txtNegotiatedAmount.Text.Trim() == "" || oCompensationFinancial.NegotiatedAmount == 0)
{
chkNegotiatedAmount.Style.Add("display", "none");
}
else
{
cneg++;
chkLandValuation.Style.Add("display", "none");
chkFixtureValuation.Style.Add("display", "none");
chkCropsValuation.Style.Add("display", "none");
chkReplacementHouseValue.Style.Add("display", "none");
chkDamagedCropValue.Style.Add("display", "none");
chkCulturePropertyValue.Style.Add("display", "none");
chkFacilitationValue.Style.Add("display", "none");
ChkAll.Style.Add("display", "none");
}
//end
if ((!string.IsNullOrEmpty(LAS) && LAS.Length > 3) && (LAS.Substring(0, 3).ToUpper() == "APP" || LAS.Substring(0, 3).ToUpper() == "SUB" || LAS.Substring(0, 3).ToUpper() == "REQ"))//LAS.Substring(0, 3).ToUpper() == "DEC" ||
{
chkLandValuation.Style.Add("display", "none");
statusCount++;
chkcount--;
cl = 0;
}
if ((!string.IsNullOrEmpty(FAS) && FAS.Length > 3) && (FAS.Substring(0, 3).ToUpper() == "APP" || FAS.Substring(0, 3).ToUpper() == "SUB" || FAS.Substring(0, 3).ToUpper() == "REQ"))//FAS.Substring(0, 3).ToUpper() == "DEC" ||
{
chkFixtureValuation.Style.Add("display", "none");
statusCount++;
chkcount--;
cf = 0;
}
if ((!string.IsNullOrEmpty(CAL) && CAL.Length > 3) && (CAL.Substring(0, 3).ToUpper() == "APP" || CAL.Substring(0, 3).ToUpper() == "SUB" || CAL.Substring(0, 3).ToUpper() == "REQ"))//CAL.Substring(0, 3).ToUpper() == "DEC" ||
{
chkCropsValuation.Style.Add("display", "none");
statusCount++;
chkcount--;
cc = 0;
}
if ((!string.IsNullOrEmpty(RAL) && RAL.Length > 3) && (RAL.Substring(0, 3).ToUpper() == "APP" || RAL.Substring(0, 3).ToUpper() == "SUB" || RAL.Substring(0, 3).ToUpper() == "REQ"))//RAL.Substring(0, 3).ToUpper() == "DEC" ||
{
chkReplacementHouseValue.Style.Add("display", "none");
statusCount++;
chkcount--;
cr = 0;
}
if ((!string.IsNullOrEmpty(DAL) && DAL.Length > 3) && (DAL.Substring(0, 3).ToUpper() == "APP" || DAL.Substring(0, 3).ToUpper() == "SUB" || DAL.Substring(0, 3).ToUpper() == "REQ"))//DAL.Substring(0, 3).ToUpper() == "DEC" ||
{
chkDamagedCropValue.Style.Add("display", "none");
statusCount++;
chkcount--;
cd = 0;
}
if ((!string.IsNullOrEmpty(CPAL) && CPAL.Length > 3) && (CPAL.Substring(0, 3).ToUpper() == "APP" || CPAL.Substring(0, 3).ToUpper() == "SUB" || CPAL.Substring(0, 3).ToUpper() == "REQ"))//CPAL.Substring(0, 3).ToUpper() == "DEC" ||
{
chkCulturePropertyValue.Style.Add("display", "none");
statusCount++;
chkcount--;
ccu = 0;
}
if ((!string.IsNullOrEmpty(OPAL) && OPAL.Length > 3) && (OPAL.Substring(0, 3).ToUpper() == "APP" || OPAL.Substring(0, 3).ToUpper() == "SUB" || OPAL.Substring(0, 3).ToUpper() == "REQ"))//CPAL.Substring(0, 3).ToUpper() == "DEC" ||
{
chkFacilitationValue.Style.Add("display", "none");
statusCount++;
chkcount--;
co = 0;
}
if ((cl + cf + cc + cd + cr + ccu + co) <= 0)
{
ChkAll.Style.Add("display", "none");
pnlPaymentRequest.Visible = false;
}
if ((!string.IsNullOrEmpty(FCAL) && FCAL.Length > 3) && (FCAL.Substring(0, 3).ToUpper() == "APP" || FCAL.Substring(0, 3).ToUpper() == "SUB" || FCAL.Substring(0, 3).ToUpper() == "REQ"))//FCAL.Substring(0, 3).ToUpper() == "DEC" ||
{
DisableAllCheckBox();
}
if ((!string.IsNullOrEmpty(NAAS) && NAAS.Length > 3) && (NAAS.Substring(0, 3).ToUpper() == "APP" || NAAS.Substring(0, 3).ToUpper() == "SUB" || NAAS.Substring(0, 3).ToUpper() == "REQ"))//NAAS.Substring(0, 3).ToUpper() == "DEC" ||
{
DisableAllCheckBox();
}
if (statusCount > 0)
{
//chkFinalCompensation.Style.Add("display", "none");
chkNegotiatedAmount.Style.Add("display", "none");
cneg = 0;
}
if (cneg > 0)
{
pnlPaymentRequest.Visible = true;
}
GetPAPValuationSummery_NegotiatedAmount((oCompensationFinancial.LandTotalValuation + oCompensationFinancial.FixtureTotalValuation +
oCompensationFinancial.CropTotalValuation + oCompensationFinancial.ResPayment +
oCompensationFinancial.DamagedCropValuation + oCompensationFinancial.CulturePropValuation + oCompensationFinancial.FacilitationAllowance), oCompensationFinancial.NegotiatedAmount);
if ((!string.IsNullOrEmpty(LAS) && LAS.Length > 3) && (LAS.Substring(0, 3).ToUpper() == "SUB" || LAS.Substring(0, 3).ToUpper() == "REQ") ||
(!string.IsNullOrEmpty(FAS) && FAS.Length > 3) && (FAS.Substring(0, 3).ToUpper() == "SUB" || FAS.Substring(0, 3).ToUpper() == "REQ") ||
(!string.IsNullOrEmpty(CAL) && CAL.Length > 3) && (CAL.Substring(0, 3).ToUpper() == "SUB" || CAL.Substring(0, 3).ToUpper() == "REQ") ||
(!string.IsNullOrEmpty(RAL) && RAL.Length > 3) && (RAL.Substring(0, 3).ToUpper() == "SUB" || RAL.Substring(0, 3).ToUpper() == "REQ") ||
(!string.IsNullOrEmpty(DAL) && DAL.Length > 3) && (DAL.Substring(0, 3).ToUpper() == "SUB" || DAL.Substring(0, 3).ToUpper() == "REQ") ||
(!string.IsNullOrEmpty(CPAL) && CPAL.Length > 3) && (CPAL.Substring(0, 3).ToUpper() == "SUB" || CPAL.Substring(0, 3).ToUpper() == "REQ") ||
(!string.IsNullOrEmpty(OPAL) && OPAL.Length > 3) && (OPAL.Substring(0, 3).ToUpper() == "SUB" || OPAL.Substring(0, 3).ToUpper() == "REQ") ||
(!string.IsNullOrEmpty(NAAS) && NAAS.Length > 3) && (NAAS.Substring(0, 3).ToUpper() == "SUB" || NAAS.Substring(0, 3).ToUpper() == "REQ"))
{
ViewState["Valuation_Status"] = "Request Pending";
}
else
{
ViewState["Valuation_Status"] = "None";
}
}
else
{
DisableAllCheckBox();
}
}
/// <summary>
/// To Update Compensation Financial
/// </summary>
/// <param name="oCompensationFinancialBO"></param>
/// <returns></returns>
public string UpdateCompensationFinancial(CompensationFinancialBO oCompensationFinancialBO)//(int HHID,string ResStructInKindCompensation,decimal FacilitationAllowance,int UpdatedBy)
{
oPaymentDAL = new PaymentDAL();
return(oPaymentDAL.UpdateCompensationFinancial(oCompensationFinancialBO));
}
/// <summary>
/// To Get Compensation Financial By Id
/// </summary>
/// <param name="CompPaymentId"></param>
/// <param name="HHID"></param>
/// <returns></returns>
public CompensationFinancialBO GetCompensationFinancialById(int CompPaymentId, int HHID)
{
proc = "USP_TRN_GET_CMP_FIN_PAYBYID";
cnn = new OracleConnection(con);
CompensationFinancialBO objCompensationFinancial = null;
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", HHID);
cmd.Parameters.Add("CMP_PAYMENTID_", CompPaymentId);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objCompensationFinancial = new CompensationFinancialBO();
if (!dr.IsDBNull(dr.GetOrdinal("CMP_PAYMENTID")))
{
objCompensationFinancial.CompPaymentId = dr.GetInt32(dr.GetOrdinal("CMP_PAYMENTID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
{
objCompensationFinancial.HHID = dr.GetInt32(dr.GetOrdinal("HHID"));
}
if (ColumnExists(dr, "LANDVALUATIONPAID") && !dr.IsDBNull(dr.GetOrdinal("LANDVALUATIONPAID")))
{
objCompensationFinancial.LandPaidValuation = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("LANDVALUATIONPAID")));
}
if (ColumnExists(dr, "RESVALUATIONPAID") && !dr.IsDBNull(dr.GetOrdinal("RESVALUATIONPAID")))
{
objCompensationFinancial.ResPaidValuation = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("RESVALUATIONPAID")));
}
if (ColumnExists(dr, "FIXTUREVALUATIONPAID") && !dr.IsDBNull(dr.GetOrdinal("FIXTUREVALUATIONPAID")))
{
objCompensationFinancial.FixturePaidValuation = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("FIXTUREVALUATIONPAID")));
}
if (ColumnExists(dr, "CROPVALUATIONPAID") && !dr.IsDBNull(dr.GetOrdinal("CROPVALUATIONPAID")))
{
objCompensationFinancial.CropPaidValuation = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CROPVALUATIONPAID")));
}
if (ColumnExists(dr, "CULTUREVALUATIONPAID") && !dr.IsDBNull(dr.GetOrdinal("CULTUREVALUATIONPAID")))
{
objCompensationFinancial.CulturePropPaidValuation = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CULTUREVALUATIONPAID")));
}
if (ColumnExists(dr, "DAMAGEDCROPVALUATIONPAID") && !dr.IsDBNull(dr.GetOrdinal("DAMAGEDCROPVALUATIONPAID")))
{
objCompensationFinancial.DamagedCropPaidValuation = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DAMAGEDCROPVALUATIONPAID")));
}
if (ColumnExists(dr, "NEGOTIATEDAMOUNTPAID") && !dr.IsDBNull(dr.GetOrdinal("NEGOTIATEDAMOUNTPAID")))
{
objCompensationFinancial.NegotiatedAmountPaid = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("NEGOTIATEDAMOUNTPAID")));
}
if (ColumnExists(dr, "FACILITATIONALLOWANCEPAID") && !dr.IsDBNull(dr.GetOrdinal("FACILITATIONALLOWANCEPAID")))
{
objCompensationFinancial.FacilitationAllowancePaid = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("FACILITATIONALLOWANCEPAID")));
}
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(objCompensationFinancial);
}
public CompensationFinancialBO getCompnesationFinancial(int HHID)
{
OracleConnection cnn = new OracleConnection(con);
OracleCommand cmd;
string proc = "USP_TRN_GET_CMP_PAYMENTSUMMERY";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("hhid_", HHID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CompensationFinancialBO oCompensationFinancialBO = null;
//CompensationFinancialList lstCompensationFinancial = new CompensationFinancialList();
while (dr.Read())
{
oCompensationFinancialBO = new CompensationFinancialBO();
if (ColumnExists(dr, "cmp_financialid") && !dr.IsDBNull(dr.GetOrdinal("cmp_financialid")))
{
oCompensationFinancialBO.Cmp_FinancialID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("cmp_financialid")));
}
if (ColumnExists(dr, "HHID") && !dr.IsDBNull(dr.GetOrdinal("HHID")))
{
oCompensationFinancialBO.HHID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID")));
}
if (ColumnExists(dr, "FacilitationAllowance") && !dr.IsDBNull(dr.GetOrdinal("FacilitationAllowance")))
{
oCompensationFinancialBO.FacilitationAllowance = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("FacilitationAllowance")));
}
if (ColumnExists(dr, "FACILITATIONALLOWANCEPAID") && !dr.IsDBNull(dr.GetOrdinal("FACILITATIONALLOWANCEPAID")))
{
oCompensationFinancialBO.FacilitationAllowancePaid = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("FACILITATIONALLOWANCEPAID")));
}
if (ColumnExists(dr, "TotalValuation") && !dr.IsDBNull(dr.GetOrdinal("TotalValuation")))
{
oCompensationFinancialBO.TotalValuation = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("TotalValuation")));
}
if (ColumnExists(dr, "ResInKindCompensation") && !dr.IsDBNull(dr.GetOrdinal("ResInKindCompensation")))
{
oCompensationFinancialBO.ResInKindCompensation = dr.GetString(dr.GetOrdinal("ResInKindCompensation"));
}
if (ColumnExists(dr, "LandInKindCompensation") && !dr.IsDBNull(dr.GetOrdinal("LandInKindCompensation")))
{
oCompensationFinancialBO.LandInKindCompensation = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("LandInKindCompensation")));
}
}
dr.Close();
return(oCompensationFinancialBO);
}
/// <summary>
/// to Add data to Datat base
/// </summary>
/// <returns></returns>
private string AddData()
{
oCompensationFinancial = new WIS_BusinessObjects.CompensationFinancialBO();
string strMax = string.Empty;
//oCompensationFinancial.Cmp_FinancialID = "";
if (Session["HH_ID"] != null)
{
oCompensationFinancial.HHID = Convert.ToInt32(Session["HH_ID"]);
}
oCompensationFinancialBLL = new CompensationFinancialBLL();
oCompensationFinancial.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString());
oCompensationFinancial.IsDeleted = "False";
//LAND SECTION
#region Land Section
if (!string.IsNullOrEmpty(txtLandValuation.Text))
{
oCompensationFinancial.LandValuation = Convert.ToDecimal(txtLandValuation.Text.Trim());
}
if (!string.IsNullOrEmpty(txtLandDAinPercentage.Text))
{
oCompensationFinancial.LandDA = Convert.ToDecimal(txtLandDAinPercentage.Text.Trim());
}
if (!string.IsNullOrEmpty(txtAcreageDifferencePayment.Text))
{
oCompensationFinancial.LandDiffPayment = Convert.ToDecimal(txtAcreageDifferencePayment.Text.Trim());
}
if (!string.IsNullOrEmpty(txtLandValuation.Text) && !string.IsNullOrEmpty(txtLandDAinAmount.Text))
{
oCompensationFinancial.LandTotalValuation = Convert.ToDecimal(txtLandValuation.Text.Trim()) + Convert.ToDecimal(txtLandDAinAmount.Text.Trim());
}
strMax = txtLandComments.Text.Trim();
if (strMax.Trim().Length > 1000)
{
strMax = txtLandComments.Text.Trim().Substring(0, 999);
}
oCompensationFinancial.LandValComments = strMax;
#endregion
//RESIDENTIAL STRUCTURE
#region Residencial Structure
if (!string.IsNullOrEmpty(txtRSDepreciatedValue.Text))
{
oCompensationFinancial.ResDepreciatedValue = Convert.ToDecimal(txtRSDepreciatedValue.Text.Trim());
}
if (!string.IsNullOrEmpty(txtRSReplacementValue.Text))
{
oCompensationFinancial.ResReplacementValue = Convert.ToDecimal(txtRSReplacementValue.Text.Trim());
}
if (!string.IsNullOrEmpty(txtRSDAinPercentage.Text))
{
oCompensationFinancial.ResDA = Convert.ToDecimal(txtRSDAinPercentage.Text.Trim());
}
if (!string.IsNullOrEmpty(txtRSMovingAllowance.Text))
{
oCompensationFinancial.ResMovingAllowance = Convert.ToDecimal(txtRSMovingAllowance.Text.Trim());
}
if (!string.IsNullOrEmpty(txtRSLabourCost.Text))
{
oCompensationFinancial.ResLabourCost = Convert.ToDecimal(txtRSLabourCost.Text.Trim());
}
if (!string.IsNullOrEmpty(txtRSPaymentHighHouseValue.Text))
{
oCompensationFinancial.ResPayment = Convert.ToDecimal(txtRSPaymentHighHouseValue.Text.Trim());
}
if (!string.IsNullOrEmpty(txtRSReplacementValue.Text)) // && !string.IsNullOrEmpty(txtResidentialDAinAmount.Text))//Calculated mannually
{
oCompensationFinancial.ResTotalValuation = Convert.ToDecimal(txtRSReplacementValue.Text.Trim()); // +Convert.ToDecimal(txtResidentialDAinAmount.Text.Trim());
}
strMax = txtResidentialStructureComments.Text.Trim();
if (strMax.Trim().Length >= 1000)
{
strMax = txtLandComments.Text.Trim().Substring(0, 999);
}
oCompensationFinancial.ResComments = strMax;
#endregion
//FIXTURES
#region Fixture Section
if (!string.IsNullOrEmpty(txtFixturesValuation.Text))
{
oCompensationFinancial.FixtureValuation = Convert.ToDecimal(txtFixturesValuation.Text.Trim());
}
if (!string.IsNullOrEmpty(txtFixturesDAinPercentage.Text))
{
oCompensationFinancial.FixtureDA = Convert.ToDecimal(txtFixturesDAinPercentage.Text.Trim());
}
if (!string.IsNullOrEmpty(txtFixturesDAinAmount.Text) && !string.IsNullOrEmpty(txtFixturesValuation.Text))
{
oCompensationFinancial.FixtureTotalValuation = Convert.ToDecimal(txtFixturesDAinAmount.Text.Trim()) + Convert.ToDecimal(txtFixturesValuation.Text.Trim());
}
if (!string.IsNullOrEmpty(txtRSDepreciatedValue.Text))
{
oCompensationFinancial.ResDepreciatedValue = Convert.ToDecimal(txtRSDepreciatedValue.Text.Trim());
}
strMax = txtFixturesComments.Text.Trim();
if (strMax.Trim().Length >= 1000)
{
strMax = txtLandComments.Text.Trim().Substring(0, 999);
}
oCompensationFinancial.FixtureComments = strMax;
#endregion
//CROPS
#region Crops Section
if (!string.IsNullOrEmpty(txtCropsValuation.Text))
{
oCompensationFinancial.CropValuation = Convert.ToDecimal(txtCropsValuation.Text.Trim());
}
//CheckBox
if (chkMaxCapCase.Checked)
{
oCompensationFinancial.CropMaxCapCase = "Yes";
}
else
{
oCompensationFinancial.CropMaxCapCase = "No";
}
if (!string.IsNullOrEmpty(txtValuationAfterMaxCap.Text))
{
oCompensationFinancial.CropValAftMaxCap = Convert.ToDecimal(txtValuationAfterMaxCap.Text.Trim());
}
if (!string.IsNullOrEmpty(txtCropsDAinPercentage.Text))
{
oCompensationFinancial.CropDA = Convert.ToDecimal(txtCropsDAinPercentage.Text.Trim());
}
if (chkMaxCapCase.Checked)
{
if (!string.IsNullOrEmpty(txtValuationAfterMaxCap.Text) && !string.IsNullOrEmpty(txtCropsDAinAmount.Text))
{
oCompensationFinancial.CropTotalValuation = Convert.ToDecimal(txtValuationAfterMaxCap.Text.Trim()) + Convert.ToDecimal(txtCropsDAinAmount.Text.Trim());
}
}
else
{
if (!string.IsNullOrEmpty(txtCropsValuation.Text) && !string.IsNullOrEmpty(txtCropsDAinAmount.Text))
{
oCompensationFinancial.CropTotalValuation = Convert.ToDecimal(txtCropsValuation.Text.Trim()) + Convert.ToDecimal(txtCropsDAinAmount.Text.Trim());
}
}
strMax = txtCropsComments.Text.Trim();
if (strMax.Trim().Length >= 1000)
{
strMax = txtLandComments.Text.Trim().Substring(0, 999);
}
oCompensationFinancial.CropComments = strMax;
#endregion
//OTHERS
#region Others
if (!string.IsNullOrEmpty(txtCulturePropertyValue.Text))
{
oCompensationFinancial.CulturePropValuation = Convert.ToDecimal(txtCulturePropertyValue.Text.Trim());
}
if (!string.IsNullOrEmpty(txtOtherDamagedCrops.Text))
{
oCompensationFinancial.DamagedCropValuation = Convert.ToDecimal(txtOtherDamagedCrops.Text.Trim());
}
if (!string.IsNullOrEmpty(txtCulturePropertyValue.Text) && !string.IsNullOrEmpty(txtOtherDamagedCrops.Text))
{
oCompensationFinancial.TotalOtherValuation = Convert.ToDecimal(txtCulturePropertyValue.Text.Trim()) + Convert.ToDecimal(txtOtherDamagedCrops.Text.Trim());
}
#endregion
//SUMMERY
#region Summery Section
if (!string.IsNullOrEmpty(txtNegotiatedAmount.Text))
{
oCompensationFinancial.NegotiatedAmount = Convert.ToDecimal(txtNegotiatedAmount.Text.Trim());
}
if (!string.IsNullOrEmpty(txtInKindLand.Text))
{
oCompensationFinancial.LandInKindCompensation = Convert.ToDecimal(txtInKindLand.Text.Trim());
}
if (ddlResidentialStructure.SelectedItem.ToString() == "0")
{
oCompensationFinancial.ResInKindCompensation = "-1";
}
else
{
oCompensationFinancial.ResInKindCompensation = ddlResidentialStructure.SelectedItem.ToString();
}
if (txtFacilitationallowances.Text.Trim() != "")
{
oCompensationFinancial.FacilitationAllowance = Convert.ToDecimal(txtFacilitationallowances.Text.Trim());
}
//if (!string.IsNullOrEmpty(txtRSDepreciatedValue.Text))
// oCompensationFinancial.ResDepreciatedValue = Convert.ToDecimal(txtRSDepreciatedValue.Text.Trim());
#endregion
string message = oCompensationFinancialBLL.AddCompensationFinancial(oCompensationFinancial);
if (message == "null" || message == null || message == "")
{
CompensationFinancialBO objCompensationFinancialBO = new CompensationFinancialBO();
if (dpDeliveryDate.Text != null)
{
objCompensationFinancialBO.DeliveryDate = Convert.ToDateTime(dpDeliveryDate.Text);
}
if (Convert.ToInt32(ddlDeliveredBy.SelectedValue.ToString()) > 0)
{
objCompensationFinancialBO.DeliveredBy = Convert.ToInt32(ddlDeliveredBy.SelectedValue.ToString());
}
objCompensationFinancialBO.HHID = SessionHHID;
objCompensationFinancialBO.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString());
if (rdoActionRejected.Checked)
{
objCompensationFinancialBO.PAPAction = "N";
}
else
{
objCompensationFinancialBO.PAPAction = "Y";
}
string sDeliveryComments = txtPackageDeliveryInfoComments.Text.Trim();
if (sDeliveryComments.Trim().Length >= 1000)
{
sDeliveryComments = sDeliveryComments.Trim().Substring(0, 999);
}
objCompensationFinancialBO.DeliveryComments = sDeliveryComments;
oCompensationFinancialBLL.AddPackageDeliveryInfo(objCompensationFinancialBO);
}
return(message);
}
