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