public UnitOfWork()
{
BrandRepo = new BrandRepo();
PhoneRepo = new PhoneRepo();
PhoneCaseRepo = new PhoneCaseRepo();
SalesManager = new SalesManager();
}
//public SalesManager Sale { get; set; }
public UnitOfWork()
{
Brands = new BrandRepo();
Phones = new PhoneRepo();
PhoneCases = new PhoneCaseRepo();
// Sale = new SalesManager();
}
public void removePhones()
{
PhoneRepo phoneRepo = new PhoneRepo();
Phone phone = phoneRepo.query(p => p.APPLICANT_ID==1).First<Phone>();
phoneService.removePhone(new PhoneModel { phoneId = phone.PHONE_ID});
applicantService.removeApplicant(new ApplicantModel { applicantId = 1 });
phoneService.removePhoneCD(new PhoneCodeModel { phoneCode = "AA" });
}
public void setup()
{
codeRepo = new PhoneCodeRepo();
codeRepo.add(new PhoneCD { PHONE_CD = "AA", PHONE_TX = "Home", MOD_DT = DateTime.Now });
codeRepo.add(new PhoneCD { PHONE_CD = "BB", PHONE_TX = "Mobile", MOD_DT = DateTime.Now });
codeRepo.add(new PhoneCD { PHONE_CD = "CC", PHONE_TX = "Work", MOD_DT = DateTime.Now });
phoneRepo = new PhoneRepo();
phoneRepo.add(new Phone { PHONE_CD = "AA", PHONE_TX = 5028011112, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "BB", PHONE_TX = 5028011113, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "CC", PHONE_TX = 5028011114, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
}
public PhoneModel getPhoneById(decimal phoneId)
{
PhoneRepo phoneRepo = new PhoneRepo();
Phone phoneData = phoneRepo.getById(new Phone{PHONE_ID=phoneId});
PhoneModel phoneModel = new PhoneModel();
phoneModel.phoneId = phoneData.PHONE_ID;
phoneModel.applicantId = phoneData.APPLICANT_ID;
phoneModel.createDate = phoneData.CREATE_DT;
phoneModel.lastModifiedDate = phoneData.MOD_DT;
phoneModel.phoneCd = phoneData.PHONE_CD;
phoneModel.phoneNumber = phoneData.PHONE_TX;
return phoneModel;
}
public void setup()
{
codeRepo = new PhoneCodeRepo();
codeRepo.add(new PhoneCD { PHONE_CD = "AA", PHONE_TX = "Home", MOD_DT = DateTime.Now });
codeRepo.add(new PhoneCD { PHONE_CD = "BB", PHONE_TX = "Mobile", MOD_DT = DateTime.Now });
codeRepo.add(new PhoneCD { PHONE_CD = "CC", PHONE_TX = "Work", MOD_DT = DateTime.Now });
/*
* Add the logic here to create a new applicantRepo() and then add an applicant with an
* applicant_id of 1. When you do this, the next part should work.
*/
phoneRepo = new PhoneRepo();
phoneRepo.add(new Phone { PHONE_CD = "AA", PHONE_TX = 5028011112, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "BB", PHONE_TX = 5028011113, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "CC", PHONE_TX = 5028011114, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
}
public void addOrUpdatePhone(PhoneModel phone)
{
PhoneRepo repo = new PhoneRepo();
Phone p = repo.getById(new Phone {PHONE_ID=phone.phoneId });
if (p!=null){
repo.update(p);
}else{
Phone p1 = new Phone();
p1.APPLICANT_ID = phone.applicantId;
p1.CREATE_DT = DateTime.Now;
p1.MOD_DT = DateTime.Now;
p1.PHONE_CD=phone.phoneCd;
p1.PHONE_TX=1231231234;
repo.add(p1);
}
repo = null;
}
public ICollection<PhoneModel> listPhonesByUser(decimal userId)
{
PhoneRepo phoneRepo = new PhoneRepo();
IEnumerable<Phone> phones = phoneRepo.query(p => p.APPLICANT_ID == userId);
ICollection<PhoneModel> phoneModels = new List<PhoneModel>();
PhoneModel phoneModel = null;
foreach (Phone p1 in phones)
{
phoneModel = new PhoneModel();
phoneModel.phoneCd = p1.PHONE_CD;
phoneModel.phoneNumber = p1.PHONE_TX;
phoneModel.lastModifiedDate = p1.MOD_DT;
phoneModel.applicantId = userId;
phoneModel.createDate = p1.CREATE_DT;
phoneModel.phoneId = p1.PHONE_ID;
phoneModels.Add(phoneModel);
}
phoneRepo = null;
return phoneModels;
}
public ICollection<PhoneModel> listPhones()
{
PhoneRepo phoneRepo = new PhoneRepo();
IEnumerable<Phone> phones = phoneRepo.getAll();
ICollection<PhoneModel> phoneModels = new List<PhoneModel>();
PhoneModel phoneModel = null;
foreach (Phone phoneData in phones)
{
phoneModel = new PhoneModel();
phoneModel.phoneCd = phoneData.PHONE_CD;
phoneModel.phoneNumber = phoneData.PHONE_TX;
phoneModel.lastModifiedDate = phoneData.MOD_DT;
phoneModel.applicantId = phoneData.APPLICANT_ID;
phoneModel.createDate = phoneData.CREATE_DT;
phoneModel.phoneId = phoneData.PHONE_ID;
phoneModels.Add(phoneModel);
}
phoneRepo = null;
return phoneModels;
}
public void setup()
{
codeRepo = new PhoneCodeRepo();
codeRepo.add(new PhoneCD { PHONE_CD = "AA", PHONE_TX = "Home", MOD_DT = DateTime.Now });
codeRepo.add(new PhoneCD { PHONE_CD = "BB", PHONE_TX = "Mobile", MOD_DT = DateTime.Now });
codeRepo.add(new PhoneCD { PHONE_CD = "CC", PHONE_TX = "Work", MOD_DT = DateTime.Now });
/*
* Add the logic here to create a new applicantRepo() and then add an applicant with an
* applicant_id of 1. When you do this, the next part should work.
*/
appRepo = new ApplicantRepo();
appRepo.add(new Applicant {
APPLICANT_ID = 1, FIRST_NAME_TX = "Wes", LAST_NAME_TX = "Reisz", MIDDLE_INITIAL_TX = "T",
MOD_DT = DateTime.Now, SSN_TX = "400121234", SUFFIX_TX = "" }
);
phoneRepo = new PhoneRepo();
phoneRepo.add(new Phone { PHONE_CD = "AA", PHONE_TX = 5028011112, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "BB", PHONE_TX = 5028011113, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "CC", PHONE_TX = 5028011114, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
}
public UnitOfWork()
{
Brands = new BrandRepo();
Phones = new PhoneRepo();
PhoneCases = new PhoneCaseRepo();
}
public void setup()
{
codeRepo = new PhoneCodeRepo();
codeRepo.add(new PhoneCD { PHONE_CD = "AA", PHONE_TX = "Home", MOD_DT = DateTime.Now });
codeRepo.add(new PhoneCD { PHONE_CD = "BB", PHONE_TX = "Mobile", MOD_DT = DateTime.Now });
codeRepo.add(new PhoneCD { PHONE_CD = "CC", PHONE_TX = "Batphone", MOD_DT = DateTime.Now });
/*
* Add the logic here to create a new AppRepo() and then add an applicant with an
* applicant_id of 1. When you do this, the next part should work.
*/
/* phoneRepo = new PhoneRepo();
phoneRepo.add(new Phone { PHONE_CD = "AA", PHONE_TX = 5028011112, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "BB", PHONE_TX = 5028011113, MOD_DT = DateTime.Now, APPLICANT_ID = 2, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "CC", PHONE_TX = 5028011114, MOD_DT = DateTime.Now, APPLICANT_ID = 3, CREATE_DT = DateTime.Now });
*/
appRep = new AppRepo();
appRep.add(new Applicant {
APPLICANT_ID = 1, FIRST_NAME_TX = "John", LAST_NAME_TX = "Stinson", MIDDLE_INITIAL_TX = "C",
MOD_DT = DateTime.Now, SSN_TX = "901111134", SUFFIX_TX = "" }
);
phoneRepo = new PhoneRepo();
phoneRepo.add(new Phone { PHONE_CD = "AA", PHONE_TX = 5021111111, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "BB", PHONE_TX = 5021234567, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
phoneRepo.add(new Phone { PHONE_CD = "CC", PHONE_TX = 5027891011, MOD_DT = DateTime.Now, APPLICANT_ID = 1, CREATE_DT = DateTime.Now });
}
public void removePhone(PhoneModel phone)
{
PhoneRepo repo = new PhoneRepo();
repo.remove(
repo.getById(new Phone { PHONE_ID = phone.phoneId })
);
repo = null;
}
