public ValuationResult GetValuationSheetDetailsByAdjId(Guid AdjudicationId)
{
ValuationRequest Request = new ValuationRequest();
ValuationSheetRow row = (ValuationSheetRow)IgrssAdapters.ValuationSheetAdapter.GetValuationSheetDetailsByAdjId(AdjudicationId).Rows[0];
Request.AdjudicationId = AdjudicationId;
Request.ValuationId = row.ValuationFormId;
Request.IsConstructedProperty = row.IsConstructedProperty;
Request.EstimatedPrice = Convert.ToDecimal(row.EstimatedPrice);
Request.TalukaCode = row.TalukaCode;
Request.VillageCode = row.VillageCode;
Request.DistrictCode = row.DistrictCode;
Request.SchemeNo = row.SchemeNo;
Request.AreaOfPlot = row.AreaOfPlot;
Request.SchemeType = row.SchemeType;
Request.TypeOfLand = row.TypeOfLand;
Request.InternalElectrificationRate = row.InternalElectrificationRate;
Request.DevelopmentRate = row.DevelopmentRate;
Request.OtherFeeRate = row.OtherFeeRate;
Request.SpecialDeductionRate = row.SpecialDeductionRate;
Request.YearOfConstruction = row.YearOfConstruction;
StampDutyCalculator calc = new StampDutyCalculator();
ValuationResult Result = calc.GetStampDutyCalculation(Request);
return(Result);
}
public ValuationResult GetStampDutyCalculation(ValuationRequest Request)
{
ValuationResult Result = new ValuationResult();
Result.TalukaCode = Request.TalukaCode;
Result.DistrictCode = Request.DistrictCode;
Result.VillageCode = Request.VillageCode;
#region Calculate Value of Land
Result.AdjudicationId = Request.AdjudicationId;
Result.ValuationId = Request.ValuationId;
Result.ValuationDate = DateTime.Now;
Result.SchemeNo = Request.SchemeNo;
Result.PlotNo = Request.PlotNo;
Result.AreaOfPlot = Request.AreaOfPlot;
Result.LandRate = GetLandRate(Request.TypeOfLand,
Request.DistrictCode,
Request.TalukaCode,
Request.VillageCode,
Request.SchemeNo,
Request.SchemeType);
Result.ValueOfLand = Result.AreaOfPlot * Result.LandRate;
#endregion
Result.IsConstructedProperty = Request.IsConstructedProperty;
#region Calculate Value of Construction
if (Result.IsConstructedProperty)
{
Result.AreaOfConstruction = Request.AreaOfConstruction;
Result.TypeOfLand = Request.TypeOfLand;
Result.EstimatedPrice = Request.EstimatedPrice;
Result.InternalElectrificationExpense = (Result.EstimatedPrice
* Request.InternalElectrificationRate)
/ 100;
Result.DevelopmentExpense = (Result.EstimatedPrice
* Request.DevelopmentRate)
/ 100;
Result.OtherFees = (Result.EstimatedPrice
* Request.OtherFeeRate)
/ 100;
Result.LiftExpense = Request.LiftExpense;
Result.ValuationOfConstruction = Result.InternalElectrificationExpense
+ Result.DevelopmentExpense
+ Result.OtherFees
+ Result.LiftExpense;
Result.EstimatedPriceOfConstruction = Result.EstimatedPrice
+ Result.ValuationOfConstruction;
Result.YearOfConstruction = Request.YearOfConstruction;
Result.LifeOfConstruction = DateTime.Now.Year - Result.YearOfConstruction;
Result.Depreciation = (Convert.ToDecimal(0.9) * Result.EstimatedPriceOfConstruction)
/ Result.LifeOfConstruction;
Result.NetPrice = Result.EstimatedPriceOfConstruction
- Result.Depreciation;
Result.SpecialDeduction = Result.NetPrice * (Request.SpecialDeductionRate / 100);
Result.ValueOfConstruction = Result.NetPrice - Result.SpecialDeduction;
}
else
{
Result.ValueOfConstruction = 0.00M;
}
#endregion
Result.ValuationOfConstruction = Result.ValueOfConstruction + Result.ValueOfLand;
Result.StampDutyRate = GetStampDutyRate();
Result.StampDuty = Result.StampDutyRate * Result.ValuationOfConstruction;
Result.Remarks = "Valuation Complete";
return(Result);
}
public bool UpdateValuationSheetDetails(ValuationResult Result)
{
try
{
IgrssAdapters.ValuationSheetAdapter.UpdateQuery(Result.AdjudicationId,
Result.ValuationId,
Result.DistrictCode,
Result.TalukaCode,
Result.VillageCode,
Result.SchemeType,
Result.EstimatedPrice,
Result.IsConstructedProperty,
Result.SchemeNo,
Result.PlotNo,
Result.AreaOfPlot,
Result.AreaOfConstruction,
Result.TypeOfLand,
Result.InternalElectrificationRate,
Result.DevelopmentRate,
Result.OtherFeeRate,
Result.SpecialDeductionRate,
Result.YearOfConstruction,
Result.LiftExpense,
Result.LandRate,
Result.ValueOfLand,
Result.InternalElectrificationExpense,
Result.DevelopmentExpense,
Result.OtherFees,
Result.SpecialDeduction,
DateTime.Now,
Result.EstimatedPriceOfConstruction,
Result.LifeOfConstruction,
Result.Depreciation,
Result.NetPrice,
Result.ValueOfConstruction,
Result.ValuationOfConstruction,
Result.StampDuty,
Result.StampDutyRate,
Result.Remarks);
}
catch (Exception e)
{
throw;
}
return(true);
//IgrssAdapters.ValuationSheetAdapter.UpdateValuationSheetDetails(Result.AdjudicationId,
// Result.ValuationId, Result.ReceivedDate, Result.ValuationDate, Result.AreaOfPlot,
// Result.PlinthAreaOfConstruction, Result.ConstructionRate, Result.EstimatedPriceOfConstruction,
// Result.DevelopmentRate, Result.LiftExpense, Result.ConstructionExpense,
// Result.LifeOfConstruction, Result.Depreciation, Result.NetPrice, Result.SpecialDeduction,
// Result.ValuationOfProperty, Result.StampDuty, Result.Remarks, Result.DistrictCode,
// Result.TalukaCode, Result.VillageCode, Result.PlotNo, Result.TpSchemeNo, Result.YearOfConstruction,
// Result.DevelopmentExpense, Result.InternalElectrificationExpense, Result.IsConstructedProperty, Result.SchemeType,
// Result.YearOfConstruction, Result.TypeOfLand, Result.DevelopmentRate, Result.OtherFeeRate);
//IgrssAdapters.ValuationSheetAdapter.UpdateValuationSheetDetails(Result.AdjudicationId,
// Result.ValuationId,
// Result.ReceivedDate,Result.ValuationDate,
// Convert.ToDecimal(Result.AreaOfPlot), Result.PlinthAreaOfConstruction, Result.ConstructionRate,
// Result.EstimatedPriceOfConstruction,Convert.ToDecimal(Result.InternalElectrificationRate),
// Result.DevelopmentExpense,null, Convert.ToDecimal(Result.LiftExpense), Convert.ToDecimal(Result.ConstructionExpense), Convert.ToInt16(Result.LifeOfConstruction),
// Convert.ToDecimal(Result.Depreciation),
// Result.NetPrice, Result.SpecialDeduction, Result.ValuationOfProperty, Result.StampDuty,
// Result.Remarks, Convert.ToInt32(Result.DistrictCode), Convert.ToInt32(Result.TalukaCode),
// Convert.ToInt32(Result.VillageCode),
// Convert.ToDecimal(Result.PlotNo), Convert.ToString(Result.TpSchemeNo), Convert.ToString(Result.YearOfConstruction));
//return true;
}
public ValuationResult GetStampDutyCalculation(ValuationRequest Request)
{
ValuationResult Result = new ValuationResult();
Result.TalukaCode = Request.TalukaCode;
Result.DistrictCode = Request.DistrictCode;
Result.VillageCode = Request.VillageCode;
#region Calculate Value of Land
Result.AdjudicationId = Request.AdjudicationId;
Result.ValuationId = Request.ValuationId;
Result.ValuationDate = DateTime.Now;
Result.SchemeNo = Request.SchemeNo;
Result.PlotNo = Request.PlotNo;
Result.AreaOfPlot = Request.AreaOfPlot;
Result.LandRate = GetLandRate(Request.TypeOfLand,
Request.DistrictCode,
Request.TalukaCode,
Request.VillageCode,
Request.SchemeNo,
Request.SchemeType);
Result.ValueOfLand = Result.AreaOfPlot * Result.LandRate;
#endregion
Result.IsConstructedProperty = Request.IsConstructedProperty;
#region Calculate Value of Construction
if (Result.IsConstructedProperty)
{
Result.AreaOfConstruction = Request.AreaOfConstruction;
Result.TypeOfLand = Request.TypeOfLand;
Result.EstimatedPrice = Request.EstimatedPrice;
Result.InternalElectrificationExpense = (Result.EstimatedPrice
* Request.InternalElectrificationRate)
/ 100;
Result.DevelopmentExpense = (Result.EstimatedPrice
* Request.DevelopmentRate)
/ 100;
Result.OtherFees = (Result.EstimatedPrice
* Request.OtherFeeRate)
/ 100;
Result.LiftExpense = Request.LiftExpense;
Result.ValuationOfConstruction = Result.InternalElectrificationExpense
+ Result.DevelopmentExpense
+ Result.OtherFees
+ Result.LiftExpense;
Result.EstimatedPriceOfConstruction = Result.EstimatedPrice
+ Result.ValuationOfConstruction;
Result.YearOfConstruction = Request.YearOfConstruction;
Result.LifeOfConstruction = DateTime.Now.Year - Result.YearOfConstruction;
Result.Depreciation = (Convert.ToDecimal(0.9) * Result.EstimatedPriceOfConstruction)
/ Result.LifeOfConstruction;
Result.NetPrice = Result.EstimatedPriceOfConstruction
- Result.Depreciation;
Result.SpecialDeduction = Result.NetPrice * (Request.SpecialDeductionRate / 100);
Result.ValueOfConstruction = Result.NetPrice - Result.SpecialDeduction;
}
else
Result.ValueOfConstruction = 0.00M;
#endregion
Result.ValuationOfConstruction = Result.ValueOfConstruction + Result.ValueOfLand;
Result.StampDutyRate = GetStampDutyRate();
Result.StampDuty = Result.StampDutyRate * Result.ValuationOfConstruction;
Result.Remarks = "Valuation Complete";
return Result;
}