public IEnumerable<MSI_Debtor> GetDebtors(string accountNumber)
{
string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name);
string logMessage = string.Format("{0}|Method incoming parameters accountNumber={1}", thisMethod, accountNumber);
//LogHelper.Info(logMessage);
MSI_Debtor debtor = null;
DBFactory db;
List<MSI_Debtor> debtors = null;
System.Data.DataSet ds;
try
{
db = new DBFactory("CascadeDBEntities");
ds = db.ExecuteDataset("MSI_spGetDebtors", "Debtors", new SqlParameter("@pimsAccountNumber", accountNumber));
if (ds.Tables["Debtors"].Rows.Count > 0)
{
debtors = new List<MSI_Debtor>();
foreach (System.Data.DataRow dr in ds.Tables["Debtors"].Rows)
{
debtor = new MSI_Debtor();
debtor.Account = dr["ACCOUNT"].ToString();
debtor.FirstName = dr["FirstName"].ToString();
debtor.LastName = dr["LastName"].ToString();
debtor.Address1 = dr["ADDRESS1"].ToString();
debtor.Address2 = dr["ADDRESS2"].ToString();
debtor.City = dr["CITY"].ToString();
debtor.State = dr["STATE"].ToString();
debtor.Zip = dr["ZIP_CODE"].ToString();
string ssn = dr["SSN"].ToString().Trim();
debtor.LastFourSSN = ssn.Substring(7, 4);
debtor.MobilePhone = dr["PHONE_CELL"].ToString();
debtor.HomePhone = dr["PHONE_HOME"].ToString();
debtor.WorkPhone = dr["PHONE_WORK"].ToString();
debtor.DOB = dr["DOB"].ToString();
debtor.DebtCurrentBalance = dr["DebtCurrentBalance"].ToString();
debtor.DebtPurchaseBalance = dr["DebtorPurchaseBalance"].ToString();
debtor.CreditorName = dr["CreditorName"].ToString();
debtors.Add(debtor);
}
}
}
catch (Exception ex)
{
//ErrorLogHelper.Error(logMessage, ex);
throw ex;
}
return debtors.AsEnumerable<MSI_Debtor>();
}
private void PopulateDebtInfo(MSI_Debtor debtor, MSI_ComplaintMain complaint)
{
complaint.Account = debtor.Account;
complaint.FirstName = debtor.FirstName;
complaint.LastName = debtor.LastName;
complaint.Address = debtor.Address1 + " " + debtor.Address2;
complaint.City = debtor.City;
complaint.State = debtor.State;
complaint.Zip = debtor.Zip;
complaint.LastFourSSN = debtor.LastFourSSN;
complaint.MobilePhone = debtor.MobilePhone;
complaint.HomePhone = debtor.HomePhone;
complaint.WorkPhone = debtor.WorkPhone;
complaint.DebtCurrentBalance = debtor.DebtCurrentBalance;
complaint.DebtPurchaseBalance = debtor.DebtPurchaseBalance;
complaint.CreditorName = debtor.CreditorName;
}
public IEnumerable<MSI_Debtor> GetDebtors(string accountNumber)
{
MSI_Debtor debtor = null;
DBFactory db;
List<MSI_Debtor> debtors = null;
System.Data.DataSet ds;
try
{
db = new DBFactory();
ds = db.ExecuteDataset("MSI_spGetDebtors", "Debtors", new SqlParameter("@pimsAccountNumber", accountNumber));
if (ds.Tables["Debtors"].Rows.Count > 0)
{
debtors = new List<MSI_Debtor>();
foreach (System.Data.DataRow dr in ds.Tables["Debtors"].Rows)
{
debtor = new MSI_Debtor();
debtor.Account = dr["ACCOUNT"].ToString();
debtor.FirstName = dr["FirstName"].ToString();
debtor.LastName = dr["LastName"].ToString();
debtor.Address1 = dr["ADDRESS1"].ToString();
debtor.Address2 = dr["ADDRESS2"].ToString();
debtor.City = dr["CITY"].ToString();
debtor.State = dr["STATE"].ToString();
debtor.Zip = dr["ZIP_CODE"].ToString();
string ssn = dr["SSN"].ToString().Trim();
debtor.LastFourSSN = ssn.Substring(7, 4);
debtor.MobilePhone = dr["PHONE_CELL"].ToString();
debtor.HomePhone = dr["PHONE_HOME"].ToString();
debtor.WorkPhone = dr["PHONE_WORK"].ToString();
debtor.DOB = dr["DOB"].ToString();
debtor.DebtCurrentBalance = dr["DebtCurrentBalance"].ToString();
debtor.DebtPurchaseBalance = dr["DebtorPurchaseBalance"].ToString();
debtor.CreditorName = dr["CreditorName"].ToString();
debtors.Add(debtor);
}
}
}
catch (Exception ex)
{
}
return debtors.AsEnumerable<MSI_Debtor>();
}
