private ComplaintStatus DualGetComplaintStatus(Tbl_ComplaintMain presentComplaint, Tbl_ComplaintMain complaintToAnalize)
{
ComplaintStatus complaintStatus = ComplaintStatus.BLANK;
try
{
if (presentComplaint == null)
{
return(complaintStatus = GetInitialStatus(complaintToAnalize));
}
complaintStatus = (ComplaintStatus)presentComplaint.ComplaintStatusId;
complaintStatus = GetNCIPStatus(complaintStatus, complaintToAnalize);
complaintStatus = GetAAIStatus(complaintStatus, complaintToAnalize, presentComplaint);
complaintStatus = GetORIPStatus(complaintStatus, complaintToAnalize);
complaintStatus = GetSOFAStatus(complaintStatus, complaintToAnalize);
complaintStatus = GetACRStatus(complaintStatus, complaintToAnalize);
complaintStatus = GetRCStatus(complaintStatus, complaintToAnalize);
}
catch (Exception ex)
{
throw ex;
}
return(complaintStatus);
}
private ComplaintStatus GetNCIPStatus(ComplaintStatus status, Tbl_ComplaintMain complaint)
{
if (status == ComplaintStatus.NCRA &&
complaint.DebtorIdentityVerifiedYN.Value == true &&
complaint.MoreInfoReqdFromDebtorYN.Value == false &&
complaint.MoreInfoRequestedDate.HasValue == false)
{
return(ComplaintStatus.NCIP);
}
else if (status == ComplaintStatus.AAI &&
complaint.MoreInfoReceivedFromDebtorYN.Value == true &&
complaint.MoreInfoReceivedDate.HasValue == true &&
complaint.MoreInfoFromAgencyReceivedYN.Value == false &&
complaint.MoreInfoFromAgencyReceivedDate.HasValue == false &&
complaint.ComplaintSubmittedToOwnerYN.Value == false &&
complaint.ComplaintSubmittedDate.HasValue == false)
{
return(ComplaintStatus.NCIP);
}
else if (status == ComplaintStatus.AAI &&
complaint.MoreInfoFromAgencyReceivedYN.Value == true &&
complaint.MoreInfoFromAgencyReceivedDate.HasValue == true &&
complaint.ComplaintSubmittedToOwnerYN.Value == false &&
complaint.ComplaintSubmittedDate.HasValue == false)
{
return(ComplaintStatus.NCIP);
}
else
{
return(status);
}
}
private ComplaintStatus CollectionAgencyGetComplaintStatus(Tbl_ComplaintMain presentComplaint, Tbl_ComplaintMain complaintToAnalize)
{
ComplaintStatus complaintStatus = ComplaintStatus.BLANK;
try
{
if (presentComplaint == null)
{
complaintStatus = GetInitialStatus(complaintToAnalize);
}
else
{
complaintStatus = (ComplaintStatus)presentComplaint.ComplaintStatusId;
}
complaintStatus = GetNCIPStatus(complaintStatus, complaintToAnalize);
complaintStatus = GetAAIStatus(complaintStatus, complaintToAnalize, null);
complaintStatus = GetSOFAStatus(complaintStatus, complaintToAnalize);
complaintStatus = GetACRStatus(complaintStatus, complaintToAnalize);
complaintStatus = GetRCStatus(complaintStatus, complaintToAnalize);
}
catch (Exception ex)
{
throw ex;
}
return(complaintStatus);
}
private ComplaintStatus GetRCStatus(ComplaintStatus status, Tbl_ComplaintMain complaintToAnalize)
{
if (status == ComplaintStatus.ACR &&
complaintToAnalize.AgencyResponseToDebtorDate.HasValue == true &&
complaintToAnalize.FinalActionStepId.HasValue == true)
{
return(ComplaintStatus.RC);
}
else
{
return(status);
}
}
private void PopulateDebtInfo(Tbl_Account account, Tbl_ComplaintMain complaint)
{
complaint.Tbl_Account.AccountNumber = account.AccountNumber;
complaint.Tbl_Account.FirstName = account.FirstName;
complaint.Tbl_Account.LastName = account.LastName;
complaint.Tbl_Account.Address = account.Address;
complaint.Tbl_Account.City = account.City;
complaint.Tbl_Account.StateId = account.StateId;
complaint.Tbl_Account.Zip = account.Zip;
complaint.Tbl_Account.LastFourSSN = account.LastFourSSN;
complaint.Tbl_Account.MobilePhone = account.MobilePhone;
complaint.Tbl_Account.HomePhone = account.HomePhone;
complaint.Tbl_Account.WorkPhone = account.WorkPhone;
complaint.Tbl_Account.DebtCurrentBalance = account.DebtCurrentBalance;
complaint.Tbl_Account.DebtPurchaseBalance = account.DebtPurchaseBalance;
complaint.Tbl_Account.CreditorName = account.CreditorName;
}
private ComplaintStatus GetACRStatus(ComplaintStatus status, Tbl_ComplaintMain complaintToAnalize)
{
if (status == ComplaintStatus.ACR &&
complaintToAnalize.AgencyResponseToDebtorDate.HasValue == true &&
complaintToAnalize.FinalActionStepId.HasValue == false)
{
return(ComplaintStatus.ACR);
}
else if (status == ComplaintStatus.ORIP &&
complaintToAnalize.OwnerResponseId.HasValue == true &&
complaintToAnalize.OwnerResponseDate.HasValue == true)
{
return(ComplaintStatus.ACR);
}
else
{
return(status);
}
}
private ComplaintStatus GetSOFAStatus(ComplaintStatus status, Tbl_ComplaintMain complaintToAnalize)
{
if (status == ComplaintStatus.NCIP &&
complaintToAnalize.ComplaintSubmittedToOwnerYN.Value == true &&
complaintToAnalize.ComplaintSubmittedDate.HasValue == true &&
complaintToAnalize.DebtorAgreeYN.Value == false &&
complaintToAnalize.FinalActionStepId.HasValue == false)
{
return(ComplaintStatus.SFOA);
}
else if (status == ComplaintStatus.AAI &&
complaintToAnalize.MoreInfoReceivedFromDebtorYN.Value == true &&
complaintToAnalize.MoreInfoReceivedDate.HasValue == true &&
complaintToAnalize.MoreInfoFromAgencyReceivedYN.Value == false &&
complaintToAnalize.MoreInfoFromAgencyReceivedDate.HasValue == false &&
complaintToAnalize.ComplaintSubmittedToOwnerYN.Value == true &&
complaintToAnalize.ComplaintSubmittedDate.HasValue == true)
{
return(ComplaintStatus.SFOA);
}
else if (status == ComplaintStatus.AAI &&
complaintToAnalize.MoreInfoFromAgencyReceivedYN.Value == true &&
complaintToAnalize.MoreInfoFromAgencyReceivedDate.HasValue == true &&
complaintToAnalize.ComplaintSubmittedToOwnerYN.Value == true &&
complaintToAnalize.ComplaintSubmittedDate.HasValue == true)
{
return(ComplaintStatus.SFOA);
}
else if (status == ComplaintStatus.NCIP &&
complaintToAnalize.ComplaintSubmittedToOwnerYN.Value == true &&
complaintToAnalize.ComplaintSubmittedDate.HasValue == true)
{
return(ComplaintStatus.SFOA);
}
else
{
return(status);
}
}
private ComplaintStatus GetORIPStatus(ComplaintStatus status, Tbl_ComplaintMain complaintToAnalize)
{
#region ORIP
if (status == ComplaintStatus.AAI &&
complaintToAnalize.MoreInfoFromAgencyYN.Value == true &&
complaintToAnalize.MoreInfoFromAgencyRequestedDate.HasValue == true &&
(!string.IsNullOrEmpty(complaintToAnalize.MoreInfoFromAgencyRequested)) &&
complaintToAnalize.MoreInfoFromAgencyReceivedYN.Value == true &&
complaintToAnalize.MoreInfoFromAgencyReceivedDate.HasValue == true &&
(!string.IsNullOrEmpty(complaintToAnalize.MoreInfoFromAgencyReceived)))
{
return(ComplaintStatus.ORIP);
}
else
{
return(status);
}
#endregion
}
private ComplaintStatus GetAAIStatus(ComplaintStatus status, Tbl_ComplaintMain complaintToAnalize, Tbl_ComplaintMain presentComplaint)
{
if (status == ComplaintStatus.NCRA &&
complaintToAnalize.DebtorIdentityVerifiedYN.Value == true &&
complaintToAnalize.MoreInfoReqdFromDebtorYN.Value == true &&
complaintToAnalize.MoreInfoRequestedDate.HasValue == true &&
!string.IsNullOrEmpty(complaintToAnalize.MoreInfoRequested))
{
return(ComplaintStatus.AAI);
}
else if (status == ComplaintStatus.NCIP &&
complaintToAnalize.MoreInfoReqdFromDebtorYN.Value == true &&
complaintToAnalize.MoreInfoRequestedDate.HasValue == true &&
(!string.IsNullOrEmpty(complaintToAnalize.MoreInfoRequested) &&
complaintToAnalize.ComplaintSubmittedToOwnerYN.Value == false &&
complaintToAnalize.ComplaintSubmittedDate.HasValue == false))
{
return(ComplaintStatus.AAI);
}
else if (status == ComplaintStatus.ORIP &&
complaintToAnalize.MoreInfoReqdFromDebtorYN.Value == true &&
complaintToAnalize.MoreInfoRequestedDate.HasValue == true &&
(!string.IsNullOrEmpty(complaintToAnalize.MoreInfoRequested)) &&
complaintToAnalize.MoreInfoFromAgencyYN.Value == false &&
complaintToAnalize.MoreInfoFromAgencyRequestedDate.HasValue == false &&
complaintToAnalize.OwnerResponseId.HasValue == false &&
complaintToAnalize.OwnerResponseDate.HasValue == false)
{
return(ComplaintStatus.AAI);
}
else if (status == ComplaintStatus.ORIP &&
complaintToAnalize.MoreInfoFromAgencyYN.Value == true &&
complaintToAnalize.MoreInfoFromAgencyRequestedDate.HasValue == true &&
(!string.IsNullOrEmpty(complaintToAnalize.MoreInfoFromAgencyRequested)) &&
complaintToAnalize.OwnerResponseId.HasValue == false &&
complaintToAnalize.OwnerResponseDate.HasValue == false)
{
return(ComplaintStatus.AAI);
}
else if (status == ComplaintStatus.ORIP &&
presentComplaint.MoreInfoReqdFromDebtorYN.Value == true &&
presentComplaint.MoreInfoRequestedDate.HasValue == true &&
complaintToAnalize.MoreInfoReqdFromDebtorYN.Value == true &&
presentComplaint.MoreInfoRequested.Length <= complaintToAnalize.MoreInfoRequested.Length &&
complaintToAnalize.OwnerResponseId.HasValue == false &&
complaintToAnalize.OwnerResponseDate.HasValue == false)
{
return(ComplaintStatus.AAI);
}
else if (status == ComplaintStatus.ORIP &&
presentComplaint.MoreInfoReqdFromDebtorYN.Value == false &&
presentComplaint.MoreInfoRequestedDate.HasValue == false &&
complaintToAnalize.MoreInfoReqdFromDebtorYN.Value == true &&
complaintToAnalize.MoreInfoRequestedDate.HasValue == true &&
(!string.IsNullOrEmpty(complaintToAnalize.MoreInfoRequested)) &&
complaintToAnalize.OwnerResponseId.HasValue == false &&
complaintToAnalize.OwnerResponseDate.HasValue == false)
{
return(ComplaintStatus.AAI);
}
else
{
return(status);
}
}
private ComplaintStatus GetInitialStatus(Tbl_ComplaintMain complaint)
{
return((complaint.DebtorIdentityVerifiedYN.Value) ? ComplaintStatus.NCIP : ComplaintStatus.NCRA);
}
private ComplaintStatus GetComplaintStatus(UserRole userRole, string accountNumber, Tbl_ComplaintMain complaintToAnalize)
{
UnitOfWork uo;
ComplaintStatus complaintStatus = ComplaintStatus.BLANK;;
try
{
uo = new UnitOfWork("CCATDBEntities");
if (userRole == UserRole.CollectionAgency || userRole == UserRole.AgencyCollector)
{
return(CollectionAgencyGetComplaintStatus(uo.Repository <Tbl_ComplaintMain>().GetAll().Where(r => r.AccountNumber == accountNumber && r.ComplaintId == complaintToAnalize.ComplaintId).SingleOrDefault(), complaintToAnalize));
}
if (userRole == UserRole.DebtOwner)
{
return(DebtOwnerGetComplaintStatus(uo.Repository <Tbl_ComplaintMain>().GetAll().Where(r => r.AccountNumber == accountNumber && r.ComplaintId == complaintToAnalize.ComplaintId).SingleOrDefault(), complaintToAnalize));
}
if (userRole == UserRole.AgencyCompliance || userRole == UserRole.AgencyManager)
{
return(DualGetComplaintStatus(uo.Repository <Tbl_ComplaintMain>().GetAll().Where(r => r.AccountNumber == accountNumber && r.ComplaintId == complaintToAnalize.ComplaintId).SingleOrDefault(), complaintToAnalize));
}
}
catch (Exception ex)
{
throw ex;
}
return(complaintStatus);
}
public Tbl_ComplaintMain Post(Tbl_ComplaintMain complaint)
{
Tbl_ComplaintMain complaintToSave = null;
UnitOfWork uo = null;
bool editingRequired = true;
UserRole role;
try
{
if (string.IsNullOrEmpty(complaint.AccountNumber) || string.IsNullOrEmpty(complaint.ComplaintId))
{
throw new Exception("Accountnumber and ComplaintId is required to save complaint.");
}
role = MSI.CCAT.Business.AccountBus.GetUserRole(complaint.CreatedBy.ToString());
uo = new UnitOfWork("CCATDBEntities");
IEnumerable <Tbl_ComplaintMain> data = (from existingComplaint in uo.Repository <Tbl_ComplaintMain>().GetAll().Where(record => record.AccountNumber == complaint.AccountNumber && record.ComplaintId == complaint.ComplaintId)
select existingComplaint);
if (data.Count() > 0)
{
complaintToSave = data.First();
}
else
{
editingRequired = false;
complaintToSave = new Tbl_ComplaintMain();
}
complaintToSave.Tbl_Account = uo.AccountRepository.GetAccounts(complaint.AccountNumber).Single();
complaintToSave.Tbl_Account.Tbl_Agency = uo.Repository <Tbl_Agency>().GetById(complaintToSave.Tbl_Account.AgencyId.Value);
complaintToSave.AccountNumber = complaint.AccountNumber;
complaintToSave.DebtorIdentityVerifiedYN = complaint.DebtorIdentityVerifiedYN;
complaintToSave.DebtorContactMethodId = complaint.DebtorContactMethodId;
complaintToSave.DebtorContactTimeId = complaint.DebtorContactTimeId;
complaintToSave.DebtorProductId = complaint.DebtorProductId;
complaintToSave.DisputeDebtYN = complaint.DisputeDebtYN;
complaintToSave.DisputeDebtAmountYN = complaint.DisputeDebtAmountYN;
complaintToSave.DisputeDebtDueDateYN = complaint.DisputeDebtDueDateYN;
complaintToSave.ComplaintId = complaint.ComplaintId;
complaintToSave.ComplaintDate = DateHelper.GetDateWithTimings(complaint.ComplaintDate);
complaintToSave.ReceivedByMethodId = complaint.ReceivedByMethodId;
complaintToSave.IssuesId = complaint.IssuesId;
complaintToSave.ComplaintNotes = complaint.ComplaintNotes;
complaintToSave.ComplaintSubmittedToAgencyYN = complaint.ComplaintSubmittedToAgencyYN;
if (complaint.ComplaintSubmittedToAgencyDate.HasValue)
{
complaintToSave.ComplaintSubmittedToAgencyDate = DateHelper.GetDateWithTimings(complaint.ComplaintSubmittedToAgencyDate.Value);
}
complaintToSave.MoreInfoReqdFromDebtorYN = complaint.MoreInfoReqdFromDebtorYN;
if (complaint.MoreInfoRequestedDate.HasValue)
{
complaintToSave.MoreInfoRequestedDate = DateHelper.GetDateWithTimings(complaint.MoreInfoRequestedDate.Value);
}
complaintToSave.MoreInfoRequested = complaint.MoreInfoRequested;
complaintToSave.MoreInfoReceivedFromDebtorYN = complaint.MoreInfoReceivedFromDebtorYN;
if (complaint.MoreInfoReceivedDate.HasValue)
{
complaintToSave.MoreInfoReceivedDate = DateHelper.GetDateWithTimings(complaint.MoreInfoReceivedDate.Value);
}
complaintToSave.MoreInfoReceived = complaint.MoreInfoReceived;
complaintToSave.ComplaintSubmittedToOwnerYN = complaint.ComplaintSubmittedToOwnerYN;
if (complaint.ComplaintSubmittedDate.HasValue)
{
complaintToSave.ComplaintSubmittedDate = DateHelper.GetDateWithTimings(complaint.ComplaintSubmittedDate.Value);
}
complaintToSave.TimeToSubmitDays = complaint.TimeToSubmitDays;
complaintToSave.MoreInfoFromAgencyYN = complaint.MoreInfoFromAgencyYN;
if (complaint.MoreInfoFromAgencyRequestedDate.HasValue)
{
complaintToSave.MoreInfoFromAgencyRequestedDate = DateHelper.GetDateWithTimings(complaint.MoreInfoFromAgencyRequestedDate.Value);
}
complaintToSave.MoreInfoFromAgencyRequested = complaint.MoreInfoFromAgencyRequested;
complaintToSave.MoreInfoFromAgencyReceived = complaint.MoreInfoFromAgencyReceived;
complaintToSave.MoreInfoFromAgencyReceivedYN = complaint.MoreInfoFromAgencyReceivedYN;
if (complaint.MoreInfoFromAgencyReceivedDate.HasValue)
{
complaintToSave.MoreInfoFromAgencyReceivedDate = DateHelper.GetDateWithTimings(complaint.MoreInfoFromAgencyReceivedDate.Value);
}
complaintToSave.OwnerResponseId = complaint.OwnerResponseId;
if (complaint.OwnerResponseDate.HasValue)
{
complaintToSave.OwnerResponseDate = DateHelper.GetDateWithTimings(complaint.OwnerResponseDate.Value);
}
complaintToSave.OwnerResponseDays = complaint.OwnerResponseDays;
if (complaint.AgencyResponseToDebtorDate.HasValue)
{
complaintToSave.AgencyResponseToDebtorDate = DateHelper.GetDateWithTimings(complaint.AgencyResponseToDebtorDate.Value);
}
complaintToSave.TotalResponseTimeDays = complaint.TotalResponseTimeDays;
complaintToSave.DebtorAgreeYN = complaint.DebtorAgreeYN;
complaintToSave.NeedFurtherActionYN = complaint.NeedFurtherActionYN;
complaintToSave.FinalActionStepId = complaint.FinalActionStepId;
if (complaint.ComplaintSubmittedToOwnerYN.Value)
{
complaintToSave.IsViewedByOwner = false;
}
complaintToSave.IsViewedByAgency = complaint.IsViewedByAgency;
complaintToSave.IsActive = true;
complaintToSave.ComplaintStatusId = (int)GetComplaintStatus(role, complaint.AccountNumber, complaintToSave);
complaintToSave.ComplaintTypeID = complaint.ComplaintTypeID;
if (editingRequired)
{
if (complaintToSave.ComplaintSubmittedDate.HasValue && complaintToSave.ComplaintDate != null)
{
complaintToSave.TimeToSubmitDays = complaintToSave.ComplaintSubmittedDate.Value.Subtract(complaintToSave.ComplaintDate.Value).Days;
}
if (complaintToSave.OwnerResponseDate.HasValue && complaintToSave.ComplaintSubmittedDate.HasValue)
{
complaintToSave.OwnerResponseDays = complaintToSave.OwnerResponseDate.Value.Subtract(complaintToSave.ComplaintSubmittedDate.Value).Days;
}
if (complaintToSave.AgencyResponseToDebtorDate.HasValue && complaintToSave.ComplaintDate != null)
{
complaintToSave.TotalResponseTimeDays = complaintToSave.AgencyResponseToDebtorDate.Value.Subtract(complaintToSave.ComplaintDate.Value).Days;
}
uo.Repository <Tbl_ComplaintMain>().Update(complaintToSave);
complaintToSave.UpdatedBy = complaint.UpdatedBy;
complaintToSave.UpdatedDateTime = DateTime.Now;
if (string.IsNullOrEmpty(complaintToSave.AgencyCollectorUserId.ToString()) && role == UserRole.AgencyCollector)
{
complaintToSave.AgencyCollectorUserId = complaint.UpdatedBy;
}
}
else
{
complaintToSave.CreatedBy = complaint.CreatedBy;
complaintToSave.UpdatedBy = complaint.UpdatedBy;
complaintToSave.CreatedDateTime = DateTime.Now;
complaintToSave.UpdatedDateTime = DateTime.Now;
uo.Repository <Tbl_ComplaintMain>().Add(complaintToSave);
if (role == UserRole.AgencyCollector)
{
complaintToSave.AgencyCollectorUserId = complaint.CreatedBy;
}
}
uo.Save();
}
catch (System.Data.Entity.Validation.DbEntityValidationException validationException)
{
foreach (System.Data.Entity.Validation.DbEntityValidationResult errorResult in validationException.EntityValidationErrors)
{
foreach (System.Data.Entity.Validation.DbValidationError error in errorResult.ValidationErrors)
{
string data = error.ErrorMessage;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(complaintToSave);
}
public Tbl_ComplaintMain Get(string accountNumber, string complaintId, string userAgency = "", string userRole = "", string createUpdateMode = "")
{
//MSI_ComplaintMainRepository repository = null;
UnitOfWork uo = null;
Tbl_ComplaintMain complaint = null;;
try
{
//repository = new MSI_ComplaintMainRepository();
uo = new UnitOfWork("CCATDBEntities");
if (createUpdateMode != "create")
{
if (string.IsNullOrEmpty(accountNumber) || string.IsNullOrEmpty(complaintId))
{
throw new Exception("Accountnumber and CompaintId is required to search");
}
complaint = uo.Repository <Tbl_ComplaintMain>().GetAll().Where(record => record.AccountNumber == accountNumber && record.ComplaintId == complaintId).FirstOrDefault();
if (!string.IsNullOrEmpty(userRole))
{
if (userRole == UserRole.DebtOwner.ToString() || userRole == UserRole.AgencyCompliance.ToString() || userRole == UserRole.AgencyManager.ToString())
{
complaint.IsViewedByOwner = true;
if (complaint.ComplaintStatusId == (int)ComplaintStatus.SFOA)
{
complaint.ComplaintStatusId = (int)ComplaintStatus.ORIP;
}
}
if (userRole == UserRole.CollectionAgency.ToString() || userRole == UserRole.AgencyCollector.ToString())
{
complaint.IsViewedByAgency = true;
}
uo.Repository <Tbl_ComplaintMain>().Update(complaint);
uo.Save();
}
}
else
{
complaint = new Tbl_ComplaintMain();
complaint.AccountNumber = accountNumber;
complaint.IssuesId = 29;//default
complaint.ComplaintDate = DateTime.Now;
}
//complaint.Tbl_Account = uo.Repository<Tbl_Account>().GetAll().Where(account => account.AccountNumber == accountNumber).Single();
complaint.Tbl_Account = uo.AccountRepository.GetAccounts(accountNumber).Single();
complaint.Tbl_Account.Tbl_Agency = uo.Repository <Tbl_Agency>().GetById(complaint.Tbl_Account.AgencyId.Value);
}
catch (System.Data.Entity.Validation.DbEntityValidationException validationException)
{
foreach (System.Data.Entity.Validation.DbEntityValidationResult errorResult in validationException.EntityValidationErrors)
{
foreach (System.Data.Entity.Validation.DbValidationError error in errorResult.ValidationErrors)
{
string data = error.ErrorMessage;
throw new Exception(data);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(complaint);
}
