public static List<HRStaffRecord> GetList(string query, object[] parms)
{
if (parms == null)
return new List<HRStaffRecord>();
if (parms.Count() == 0)
return new List<HRStaffRecord>();
try
{
HRStaffContext db = new HRStaffContext(Properties.Settings.Default.ConnectionString);
List<HRStaffRecord> items = db.HRStaffRecords.Where(query, parms)
.OrderBy(x => x.LastName + x.FirstName + x.MiddleInitial)
.ToList();
return items;
}
catch (Exception ex)
{
Anvil.v2015.v001.Domain.Exceptions.AnvilExceptionCollector ec = new Anvil.v2015.v001.Domain.Exceptions.AnvilExceptionCollector("Error getting staff members");
ec.Add(query);
ec.Add(ex);
throw ec.ToException();
}
}
public void Import(LcpsDbContext context)
{
if (this.CrudStatus == ImportCrudStatus.InsertMember)
{
try
{
EmailAccount e = new EmailAccount()
{
RecordId = Guid.NewGuid(),
EmailAddress = this.EmailAddress,
InitialPassword = this.InitialPassword,
UserLink = _userId
};
context.EmailAccounts.Add(e);
context.SaveChanges();
ImportStatus = ImportRecordStatus.success;
}
catch (Exception ex)
{
Anvil.v2015.v001.Domain.Exceptions.AnvilExceptionCollector ec = new Anvil.v2015.v001.Domain.Exceptions.AnvilExceptionCollector(ex);
ImportStatus = ImportRecordStatus.danger;
ImportReport = ec.ToUL();
}
}
}