public bool AddNewValuationFormForRegistration(FormViewParameter Parameter, Guid Id)
{
IGRSS.DataAccessLayer.Adjudication.ValuationFormRow row = (IGRSS.DataAccessLayer.Adjudication.ValuationFormRow)Parameter.Values;
Guid ValuationFormId = Id;
string curUser = Thread.CurrentPrincipal.Identity.Name;
//Guid ValuationFormId=ViewState["ValuationFormId"];
IgrssAdapters.ValuationAdapter.AddNewValuationFormForRegistration(ValuationFormId,
row.Village_CityName, row.TPSchemeNo, row.TPSchemeName, row.FinalPlotNo, row.CitySurveyNo,
row.RevenueSurveyNo, row.Ward_SubWardNo, row.NameOfOwner, row.AddressOfOwner, row.NameOfClaimingParty,
row.AddressOfClaimingParty, row.AreaOfPlot, row.AreaOfConstruction, row.YearOfConstruction,
row.NoOfFloors, row.TypeOfProperty,
row.HeightOfCeiling, row.TypeOfTiles,
row.WallFurnishing, row.NoOfBathrooms, row.BathroomTilesHeight,
row.NoOfToilets, row.ToiletTilesHeight, row.Parking, row.DescOfProperty,
row.ShopsOnGroundFloor, row.IsPropertyInCommercial,
row.TypeOfElectricfication,
row.CompoundWallType, row.IsLightsOnCompoundWall,
row.WaterStorageFacility, row.DrainageSystem, row.NoOfLifts,
row.AreaOfEachLift, row.InternalRoad, row.ValuatedBefore, curUser, DateTime.Now);
return(true);
}
public bool UpdateValuationForm(FormViewParameter ValFormParameter, DataTable DocDetails)
{
try
{
string curUser = Thread.CurrentPrincipal.Identity.Name;
ValuationFormRow ValFormrow = (IGRSS.DataAccessLayer.Adjudication.ValuationFormRow)ValFormParameter.Values;
Guid ValuationFormId = ValFormrow.OfficeId;
IgrssAdapters.ValuationAdapter.UpdateValuationFormByValFormId(
ValFormrow.Village_CityName, ValFormrow.TPSchemeNo, ValFormrow.TPSchemeName, ValFormrow.FinalPlotNo, ValFormrow.CitySurveyNo,
ValFormrow.RevenueSurveyNo, ValFormrow.Ward_SubWardNo, ValFormrow.NameOfOwner, ValFormrow.AddressOfOwner,
ValFormrow.NameOfClaimingParty, ValFormrow.AddressOfClaimingParty, ValFormrow.AreaOfPlot, ValFormrow.AreaOfConstruction,
ValFormrow.YearOfConstruction, ValFormrow.NoOfFloors, ValFormrow.TypeOfProperty, ValFormrow.HeightOfCeiling,
ValFormrow.TypeOfTiles, ValFormrow.WallFurnishing, ValFormrow.NoOfBathrooms, ValFormrow.BathroomTilesHeight,
ValFormrow.NoOfToilets, ValFormrow.ToiletTilesHeight, ValFormrow.Parking, ValFormrow.DescOfProperty,
ValFormrow.ShopsOnGroundFloor, ValFormrow.IsPropertyInCommercial, ValFormrow.TypeOfElectricfication, ValFormrow.CompoundWallType,
ValFormrow.IsLightsOnCompoundWall, ValFormrow.WaterStorageFacility, ValFormrow.DrainageSystem, ValFormrow.NoOfLifts,
ValFormrow.AreaOfEachLift, ValFormrow.InternalRoad, ValFormrow.ValuatedBefore, ValFormrow.ValuationFormId, curUser, DateTime.Now);
// Delete and Insert all the documents that are attached to this ValuationForm
IgrssAdapters.AdjudicationDocumentAdapter.DeleteDocumentDetailByValuationFormId(ValuationFormId);
foreach (DataRow DocDetail in DocDetails.Rows)
{
IgrssAdapters.AdjudicationDocumentAdapter.AddAdjudicationDocument(ValuationFormId, (Guid)DocDetail["DocumentTypeId"], Convert.ToBoolean(DocDetail["Submitted"]), Convert.ToString(DocDetail["DocumentNumber"]), Convert.ToString(DocDetail["Remarks"]));
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public AdjudicationApplicationUpdatedEventArgs(Guid InstanceId, AdjudicationRequestRow UpdatedAdjudicationRow, ValuationFormRow UpdatedValuationFormRow, DataTable FeeDetails, DataTable DocumentDetails)
: base(InstanceId)
{
this.UpdatedAdjudicationRows = (AdjudicationRequestTable) UpdatedAdjudicationRow.Table;
UpdatedAdjudicationRow.AdjudicationId = new Guid();
this.UpdatedAdjudicationRows.Rows.Add(UpdatedAdjudicationRow);
this.UpdatedValuationFormRows = (ValuationFormTable) UpdatedValuationFormRow.Table;
UpdatedAdjudicationRow.ValuationFormId = new Guid();
this.UpdatedValuationFormRows.Rows.Add(UpdatedValuationFormRow);
this.m_FeeDetails = FeeDetails;
this.m_DocumentDetails = DocumentDetails;
}
private void OnApplicationUpdated_Invoked(object sender, ExternalDataEventArgs e)
{
string curUser = Thread.CurrentPrincipal.Identity.Name;
// Type cast the event args to the required type
AdjudicationApplicationUpdatedEventArgs args = (AdjudicationApplicationUpdatedEventArgs)e;
// Retrive the row to be updated (always the frist row i.e. Rows[0])
AdjudicationRequestRow AdjReqRow = (AdjudicationRequestRow)args.UpdatedAdjudicationRows[0];
// Get the ValuationFormRow from the event arguments
ValuationFormRow ValFormRow = (ValuationFormRow)args.UpdatedValuationFormRows.Rows[0];
// Getr the Fee Details changed during update operation
DataTable FeeDetails = args.FeeDetails;
// Getr the Document Details changed during update operation
DataTable DocDetails = args.DocumentDetails;
// Update the ValuationFormRow
IgrssAdapters.ValuationAdapter.UpdateValuationFormByValFormId(ValFormRow.Village_CityName, ValFormRow.TPSchemeNo, ValFormRow.TPSchemeName, ValFormRow.FinalPlotNo,
ValFormRow.CitySurveyNo, ValFormRow.RevenueSurveyNo, ValFormRow.Ward_SubWardNo, ValFormRow.NameOfOwner,
ValFormRow.AddressOfOwner, ValFormRow.NameOfClaimingParty, ValFormRow.AddressOfClaimingParty,
ValFormRow.AreaOfPlot, ValFormRow.AreaOfConstruction, ValFormRow.YearOfConstruction, ValFormRow.NoOfFloors,
ValFormRow.TypeOfProperty, ValFormRow.HeightOfCeiling, ValFormRow.TypeOfTiles, ValFormRow.WallFurnishing,
ValFormRow.NoOfBathrooms, ValFormRow.BathroomTilesHeight, ValFormRow.NoOfToilets, ValFormRow.ToiletTilesHeight,
ValFormRow.Parking, ValFormRow.DescOfProperty, ValFormRow.ShopsOnGroundFloor, ValFormRow.IsPropertyInCommercial,
ValFormRow.TypeOfElectricfication, ValFormRow.CompoundWallType, ValFormRow.IsLightsOnCompoundWall,
ValFormRow.WaterStorageFacility, ValFormRow.DrainageSystem, ValFormRow.NoOfLifts, ValFormRow.AreaOfEachLift,
ValFormRow.InternalRoad, ValFormRow.ValuatedBefore, ValuationFormId, curUser, DateTime.Now);
IgrssAdapters.AdjudicationAdapter.UpdateAdjudicationRequest(AdjudicationId, ValuationFormId, null, AdjReqRow.OfficeId, AdjReqRow.ApplicationDate, AdjReqRow.ReceiptNumber, AdjReqRow.AdjudicationTotalFees);
// Delete and Insert all the fees for this Adjudication Form
IgrssAdapters.AdjudicationFeeAdapter.DeleteFeesByAdjudicationId(AdjudicationId);
foreach (DataRow FeeDetail in FeeDetails.Rows)
{
IgrssAdapters.AdjudicationFeeAdapter.AddAdjudicationFees(AdjudicationId, (Guid)FeeDetail["FeeId"], Convert.ToDecimal(FeeDetail["Amount"]));
}
// Delete and Insert all the document details for this Adjudication Form
IgrssAdapters.AdjudicationDocumentAdapter.DeleteDocumentDetailByValuationFormId(ValuationFormId);
foreach (DataRow DocDetail in DocDetails.Rows)
{
IgrssAdapters.AdjudicationDocumentAdapter.AddAdjudicationDocument(ValuationFormId, (Guid)DocDetail["DocumentTypeId"], Convert.ToBoolean(DocDetail["Submitted"]), Convert.ToString(DocDetail["DocumentNumber"]), Convert.ToString(DocDetail["Remarks"]));
}
// The Application has been modified and will require verification from all again
this.verificationIndex = 0;
}
public ValuationRequest GetValuationFormDetails(Guid AdjudicationId)
{
ValuationRequest RetRequest = new ValuationRequest();
ValuationFormRow row = (ValuationFormRow) new AdjudicationRequest().GetValuationFormRowByAdjudicationId(AdjudicationId).Rows[0];
RetRequest.AdjudicationId = AdjudicationId;
RetRequest.ValuationId = row.ValuationFormId;
RetRequest.TalukaCode = 1;
RetRequest.VillageCode = 1;
RetRequest.DistrictCode = 1;
RetRequest.SchemeNo = row.TPSchemeNo;
RetRequest.SchemeType = "TP Scheme";
RetRequest.PlotNo = row.FinalPlotNo;
RetRequest.AreaOfPlot = row.AreaOfPlot;
RetRequest.AreaOfConstruction = row.AreaOfConstruction;
RetRequest.TypeOfLand = "APrate";
RetRequest.YearOfConstruction = row.YearOfConstruction;
return(RetRequest);
}
public bool AddAdjudicationRequest(FormViewParameter ValFormParameter, AdjudicationRequestRow AdjReqRow, DataTable FeeDetails, DataTable DocDetails)
{
string curUser = Thread.CurrentPrincipal.Identity.Name;
Guid AdjudicationId = FileManager.OpenNewFile(AdjReqRow.OfficeId, "ADJ");;
Guid ValuationFormId = Guid.NewGuid();
ValuationFormRow ValFormrow = (IGRSS.DataAccessLayer.Adjudication.ValuationFormRow)ValFormParameter.Values;
IgrssAdapters.ValuationAdapter.AddValuationDetail(ValuationFormId, ValFormrow.OfficeId, ValFormrow.DistrictCode, ValFormrow.TalukaCode, ValFormrow.VillageCode,
null, ValFormrow.Village_CityName, ValFormrow.TPSchemeNo, ValFormrow.TPSchemeName, ValFormrow.FinalPlotNo, ValFormrow.CitySurveyNo, ValFormrow.RevenueSurveyNo,
ValFormrow.Ward_SubWardNo, ValFormrow.NameOfOwner, ValFormrow.AddressOfOwner, ValFormrow.NameOfClaimingParty, ValFormrow.AddressOfClaimingParty,
ValFormrow.AreaOfPlot, ValFormrow.AreaOfConstruction, ValFormrow.YearOfConstruction, ValFormrow.NoOfFloors, ValFormrow.TypeOfProperty,
ValFormrow.DescOfProperty, ValFormrow.ShopsOnGroundFloor, ValFormrow.IsPropertyInCommercial, ValFormrow.TypeOfElectricfication,
ValFormrow.CompoundWallType, ValFormrow.IsLightsOnCompoundWall, ValFormrow.WaterStorageFacility, ValFormrow.DrainageSystem, ValFormrow.NoOfLifts,
ValFormrow.AreaOfEachLift, ValFormrow.InternalRoad, ValFormrow.ValuatedBefore, ValFormrow.HeightOfCeiling, ValFormrow.TypeOfTiles,
ValFormrow.WallFurnishing, ValFormrow.NoOfBathrooms, ValFormrow.BathroomTilesHeight, ValFormrow.NoOfToilets, ValFormrow.ToiletTilesHeight, ValFormrow.Parking, curUser, DateTime.Now);
IgrssAdapters.AdjudicationAdapter.AddAdjudicationRequest(AdjudicationId, ValuationFormId, null, AdjReqRow.OfficeId, AdjReqRow.ApplicationDate, AdjReqRow.ReceiptNumber, AdjReqRow.AdjudicationTotalFees);
foreach (DataRow FeeDetail in FeeDetails.Rows)
{
IgrssAdapters.AdjudicationFeeAdapter.AddAdjudicationFees(AdjudicationId, (Guid)FeeDetail["FeeId"], Convert.ToDecimal(FeeDetail["Amount"]));
}
foreach (DataRow DocDetail in DocDetails.Rows)
{
IgrssAdapters.AdjudicationDocumentAdapter.AddAdjudicationDocument(ValuationFormId, (Guid)DocDetail["DocumentTypeId"], Convert.ToBoolean(DocDetail["Submitted"]), Convert.ToString(DocDetail["DocumentNumber"]), Convert.ToString(DocDetail["Remarks"]));
}
// All database Inserts have been completed sucessfully initiate the Workflow
// Create a Dioctionary to store Workflow Paramaters for Adjudication
Dictionary <string, object> WfParams = new Dictionary <string, object>();
// Add Adjudication Application Id into the Workflow Parameter
WfParams.Add("AdjudicationId", AdjudicationId);
WfParams.Add("ValuationFormId", ValuationFormId);
// Add Office Id in to Workflow Parameter
// (to identify the process flow for the Office)
WfParams.Add("InitiatingOffice", ValFormrow.OfficeId);
// Initiate the Refund Workflow by passing the Wf Parameters Dictionary
WorkflowResults WfResult = WorkflowMediator.RunWorkflow(typeof(AdjudicationProcess), WfParams);
return(true);
}
public AdjudicationApplicationUpdatedEventArgs(Guid InstanceId, AdjudicationRequestRow UpdatedAdjudicationRow, ValuationFormRow UpdatedValuationFormRow, DataTable FeeDetails, DataTable DocumentDetails)
: base(InstanceId)
{
this.UpdatedAdjudicationRows = (AdjudicationRequestTable)UpdatedAdjudicationRow.Table;
UpdatedAdjudicationRow.AdjudicationId = new Guid();
this.UpdatedAdjudicationRows.Rows.Add(UpdatedAdjudicationRow);
this.UpdatedValuationFormRows = (ValuationFormTable)UpdatedValuationFormRow.Table;
UpdatedAdjudicationRow.ValuationFormId = new Guid();
this.UpdatedValuationFormRows.Rows.Add(UpdatedValuationFormRow);
this.m_FeeDetails = FeeDetails;
this.m_DocumentDetails = DocumentDetails;
}
