public ActionResult GetSearchGrid(SearchGridVm searchGridVm)
{
try
{
searchGridVm.userId = UserId;
CheckAccess();
if (searchGridVm.AssessmentType == UserViewType.Billing || searchGridVm.AssessmentType == UserViewType.ClaimHandler || searchGridVm.AssessmentType == UserViewType.SuperUser)
{
if (searchGridVm.AssessmentType == UserViewType.SuperUser && searchGridVm.RejectedCaseType == RejectedCaseType.RejectedBill)
{
resultBill = _claimSearchDao.GetBillSearchGrid(searchGridVm);
return(PartialView("_ClaimRejectedCaseSearchGridView", resultBill));
}
else if (searchGridVm.AssessmentType != UserViewType.SuperUser)
{
resultBill = _claimSearchDao.GetBillSearchGrid(searchGridVm);
return(PartialView(searchGridVm.viewName, resultBill));
}
}
else if (searchGridVm.AssessmentType == UserViewType.FRPLR)
{
resultPLR = _claimSearchDao.GetSearchGrid(searchGridVm);
return(PartialView(searchGridVm.viewName, resultPLR));
}
else if (searchGridVm.AssessmentType == UserViewType.PLR || searchGridVm.AssessmentType == UserViewType.RPLR ||
searchGridVm.AssessmentType == UserViewType.SDPLR || searchGridVm.AssessmentType == UserViewType.NLCPLR ||
searchGridVm.AssessmentType == UserViewType.LSSPLR || searchGridVm.AssessmentType == UserViewType.ARPLR ||
searchGridVm.AssessmentType == UserViewType.TLPLR || searchGridVm.AssessmentType == UserViewType.TSPLR ||
searchGridVm.AssessmentType == UserViewType.TPLR || searchGridVm.AssessmentType == UserViewType.SPLR ||
searchGridVm.AssessmentType == UserViewType.OnlyPhotoPLR
)
{
if (searchGridVm.AssessmentType == UserViewType.SuperUser && searchGridVm.RejectedCaseType == RejectedCaseType.RejectedPLR)
{
resultPLR = _claimSearchDao.GetSearchGrid(searchGridVm);
return(PartialView("_ClaimRejectedCaseSearchGridView", resultPLR));
}
else if (searchGridVm.AssessmentType != UserViewType.SuperUser)
{
resultPLR = _claimSearchDao.GetSearchGrid(searchGridVm);
return(PartialView(searchGridVm.viewName, resultPLR));
}
}
}
catch (Exception ex)
{
TempData["ErrorMessage"] = ValidationMessages.ClaimNotFound;
LoggerService.LogException(ex);
}
return(PartialView(searchGridVm.viewName, resultPLR));
}
private static void GetOrderedGridResult(SearchGridVm searchGridVm, List <PLRSearchClaim1VM> result)
{
if (searchGridVm.orderBy == "asc")
{
result = result.OrderBy(x => x.IntimationDate).ToList();
}
else if (searchGridVm.orderBy == "desc")
{
result = result.OrderByDescending(x => x.IntimationDate).ToList();
}
}
public List <PLRSearchClaim1VM> GetSearchGrid(SearchGridVm searchGridVm)
{
List <PLRSearchClaim1VM> result = null;
searchGridVm.claimNo = StringExtensions.ConvertToNullableString(searchGridVm.claimNo);
searchGridVm.policyNo = StringExtensions.ConvertToNullableString(searchGridVm.policyNo);
searchGridVm.insuredName = StringExtensions.ConvertToNullableString(searchGridVm.insuredName);
searchGridVm.engineNo = StringExtensions.ConvertToNullableString(searchGridVm.engineNo);
searchGridVm.registrationNo = StringExtensions.ConvertToNullableString(searchGridVm.registrationNo);
searchGridVm.chasisNo = StringExtensions.ConvertToNullableString(searchGridVm.chasisNo);
searchGridVm.reasons = StringExtensions.ConvertToNullableString(searchGridVm.reasons);
DateTime?dateEffective = DateTimeExtensions.ConvertToNullableDateTime(searchGridVm.effectiveDate);
DateTime?dateExpiry = DateTimeExtensions.ConvertToNullableDateTime(searchGridVm.expiryDate);
DateTime?intimateDateFrom = DateTimeExtensions.ConvertToNullableDateTime(searchGridVm.fromIntimationDate);
DateTime?intimateDateTo = DateTimeExtensions.ConvertToNullableDateTime(searchGridVm.toIntimationDate);
int? claimTypeId = TypeConversionExtensions.ConvertToNullableInt(searchGridVm.claimType);
if (searchGridVm.AssessmentType == UserViewType.Billing || searchGridVm.AssessmentType == UserViewType.ClaimHandler ||
searchGridVm.AssessmentType == UserViewType.PLR || searchGridVm.AssessmentType == UserViewType.RPLR ||
searchGridVm.AssessmentType == UserViewType.SDPLR || searchGridVm.AssessmentType == UserViewType.NLCPLR ||
searchGridVm.AssessmentType == UserViewType.LSSPLR || searchGridVm.AssessmentType == UserViewType.ARPLR ||
searchGridVm.AssessmentType == UserViewType.TLPLR || searchGridVm.AssessmentType == UserViewType.TSPLR ||
searchGridVm.AssessmentType == UserViewType.TPLR || searchGridVm.AssessmentType == UserViewType.SPLR)
{
result = _context.PLR_SearchClaim1_SP(Convert.ToInt16(searchGridVm.userId),
searchGridVm.policyNo,
searchGridVm.insuredName,
searchGridVm.claimNo,
searchGridVm.registrationNo,
searchGridVm.engineNo,
searchGridVm.chasisNo,
dateEffective,
dateExpiry,
searchGridVm.reasons,
claimTypeId,
intimateDateFrom.GetDateTimeTostring(),
intimateDateTo.GetDateTimeTostring(),
searchGridVm.AssessmentType,
Convert.ToInt32(searchGridVm.dispositionId))
.Select(x => new PLRSearchClaim1VM
{
Id = x.Id,
SalesFormMapping_Id = x.SalesFormMapping_Id,
ClaimNo = x.ClaimNo,
IntimationDate = x.IntimationDate,
Stage = x.Stage,
RegistrationNo = x.RegistrationNo,
EngineNo = x.m_Engine_No,
ChassisNo = x.m_Chasis_No,
InsuredName = x.InsuredName,
SalesFormNo = x.SalesFormNo,
EffectiveDate = x.EffectiveDate,
ExpiryDate = x.ExpiryDate,
SalesFormDetail_Id = x.SalesFormDetail_Id,
Contact_Id = x.Contact_Id,
Stage_Id = x.Stage_Id,
Company_Id = x.Company_Id,
CloseReason_Id = x.CloseReason_Id,
ReOpenReason_Id = x.ReOpenReason_Id,
PLRStatus = x.PLRStatus,
PLRDispositionId = x.PLRDispositionId,
Active = x.Active,
PLRDisposition = x.PLRDisposition,
ClaimType_Id = x.ClaimType_Id,
ClaimType = x.ClaimType,
Aging = x.Aging,
Reason = x.Reason,
ReserveAmount = x.ReserveAmount,
OutStandingAmount = x.OutStandingAmount,
BusinessType_Id = x.BusinessType_Id,
AddBY = x.AddBY,
AppointmentDate = x.AppointmentDate,
SDitemCount = x.SDitemCount,
ItemCount = x.itemCount
}).ToList();
//removing containing SD part items and submitted claims For Billing
if (searchGridVm.AssessmentType == UserViewType.SDPLR)
{
result = result.Where(x => x.SDitemCount > 0).ToList();
}
}
else if (searchGridVm.AssessmentType == UserViewType.SuperUser)
{
searchGridVm.AssessmentType = searchGridVm.AssessmentType;
result = _context.PLR_SearchClaim1_SP(Convert.ToInt16(searchGridVm.userId),
searchGridVm.policyNo,
searchGridVm.insuredName,
searchGridVm.claimNo,
searchGridVm.registrationNo,
searchGridVm.engineNo,
searchGridVm.chasisNo,
dateEffective,
dateExpiry,
searchGridVm.reasons,
claimTypeId,
intimateDateFrom.GetDateTimeTostring(),
intimateDateTo.GetDateTimeTostring(),
searchGridVm.AssessmentType,
Convert.ToInt32(searchGridVm.dispositionId))
.Select(x => new PLRSearchClaim1VM
{
Id = x.Id,
SalesFormMapping_Id = x.SalesFormMapping_Id,
ClaimNo = x.ClaimNo,
IntimationDate = x.IntimationDate,
Stage = x.Stage,
RegistrationNo = x.RegistrationNo,
EngineNo = x.m_Engine_No,
ChassisNo = x.m_Chasis_No,
InsuredName = x.InsuredName,
SalesFormNo = x.SalesFormNo,
EffectiveDate = x.EffectiveDate,
ExpiryDate = x.ExpiryDate,
SalesFormDetail_Id = x.SalesFormDetail_Id,
Contact_Id = x.Contact_Id,
Stage_Id = x.Stage_Id,
Company_Id = x.Company_Id,
CloseReason_Id = x.CloseReason_Id,
ReOpenReason_Id = x.ReOpenReason_Id,
ClaimType_Id = x.ClaimType_Id,
ClaimType = x.ClaimType,
Aging = x.Aging,
Reason = x.Reason,
ReserveAmount = x.ReserveAmount,
OutStandingAmount = x.OutStandingAmount,
BusinessType_Id = x.BusinessType_Id,
AddBY = x.AddBY
}).ToList();
}
else if (searchGridVm.AssessmentType == UserViewType.FRPLR)
{
result = _context.CLA_DGI_FinalReportPLR_SP(Convert.ToInt16(searchGridVm.userId),
searchGridVm.policyNo,
searchGridVm.insuredName,
searchGridVm.claimNo,
searchGridVm.registrationNo,
searchGridVm.engineNo,
searchGridVm.chasisNo,
dateEffective,
dateExpiry,
searchGridVm.reasons,
claimTypeId,
intimateDateFrom.GetDateTimeTostring(),
intimateDateTo.GetDateTimeTostring(),
searchGridVm.AssessmentType,
Convert.ToInt32(searchGridVm.dispositionId)
)
.Select(x => new PLRSearchClaim1VM
{
Id = x.Id,
SalesFormMapping_Id = x.SalesFormMapping_Id,
ClaimNo = x.ClaimNo,
IntimationDate = x.IntimationDate,
Stage = x.Stage,
RegistrationNo = x.RegistrationNo,
EngineNo = x.m_Engine_No,
ChassisNo = x.m_Chasis_No,
InsuredName = x.InsuredName,
SalesFormNo = x.SalesFormNo,
EffectiveDate = x.EffectiveDate,
ExpiryDate = x.ExpiryDate,
SalesFormDetail_Id = x.SalesFormDetail_Id,
Contact_Id = x.Contact_Id,
Stage_Id = x.Stage_Id,
Company_Id = x.Company_Id,
CloseReason_Id = x.CloseReason_Id,
ReOpenReason_Id = x.ReOpenReason_Id,
ClaimType_Id = x.ClaimType_Id,
ClaimType = x.ClaimType,
Aging = x.Aging,
Reason = x.Reason,
ReserveAmount = x.ReserveAmount,
OutStandingAmount = x.OutStandingAmount,
BusinessType_Id = x.BusinessType_Id,
AddBY = x.AddBY
}).DistinctBy(x => x.Id).ToList();
}
GetOrderedGridResult(searchGridVm, result);
return(result);
}
public List <BillSearchClaimVM> GetBillSearchGrid(SearchGridVm searchGridVm)
{
// searchGridVm.userId = StringExtensions.ConvertToNullableString(searchGridVm.userId);
searchGridVm.claimNo = StringExtensions.ConvertToNullableString(searchGridVm.claimNo);
searchGridVm.fromdate = StringExtensions.ConvertToNullableString(searchGridVm.insuredName);
searchGridVm.todate = StringExtensions.ConvertToNullableString(searchGridVm.engineNo);
searchGridVm.registrationNo = StringExtensions.ConvertToNullableString(searchGridVm.registrationNo);
searchGridVm.chasisNo = StringExtensions.ConvertToNullableString(searchGridVm.chasisNo);
searchGridVm.engineNo = StringExtensions.ConvertToNullableString(searchGridVm.engineNo);
List <BillSearchClaimVM> result = _context.CLA_DGI_BillingSearch_SP(Convert.ToInt32(searchGridVm.userId),
searchGridVm.fromdate,
searchGridVm.todate,
searchGridVm.claimNo,
searchGridVm.registrationNo,
searchGridVm.engineNo,
searchGridVm.chasisNo,
searchGridVm.AssessmentType
)
.Select(x => new BillSearchClaimVM
{
Id = x.Id,
ClaimNo = x.ClaimNo,
InsuredName = x.InsuredName,
VehicleMake = x.VehicleMake,
RegistrationNo = x.RegistrationNo,
EngineNo = x.EngineNo,
ChasisNo = x.ChasisNo,
SurveyorName = x.SurveyorName,
SurveyorDate = x.SurveyorDate,
ApprovedLabourAmount = x.ApprovedLabourAmount,
EstimatePartsAmount = x.EstimatePartsAmount,
// Type = searchGridVm.type,
TotalAssesment = x.TotalAssesment,
BillStatus = x.BillStatus,
BillSubmittedDate = x.BillSubmittedDate,
TotalLabourAmount = x.TotalLabourAmount,
TotalPartsAmount = x.TotalPartsAmount,
TotalBillAmount = x.TotalBillAmount,
PaymentStatus = x.PaymentStatus,
ModeofPayment = x.ModeofPayment,
InstrumentNo = x.InstrumentNo,
InstrumentDate = x.InstrumentDate,
InstrumentAmount = x.InstrumentAmount,
SalesFormMappingId = x.SalesFormMappingId,
SDItemExists = x.SDItemCount
// ,Workshop= x.Workshop
}).ToList();
//removing containing SD part items and submitted claims For Billing
if (searchGridVm.AssessmentType == UserViewType.Billing)
{
result = result.Where(x => x.SDItemExists <= 0 &&
x.BillStatus != BillStatus.Submit &&
x.BillStatus != BillStatus.ClaimHandlerApprove).ToList();
}
else if (searchGridVm.AssessmentType == UserViewType.ClaimHandler)
{
result = result.Where(x => x.SDItemExists <= 0).ToList();
}
//&& x.BillStatus == BillStatus.Submit
//&& x.BillStatus != BillStatus.ClaimHandlerApprove && x.BillStatus != BillStatus.ClaimHandlerHold).ToList();
return(result);
}
