public List <Customer> GetPrivateCutomers() { using (var context = new TownUtilityBillSystemV2Entities()) { List <Customer> privateCustomers = new List <Customer>(); List <int> privateTypeIds = GetPrivateCustomerTypeIds(context); var privateCustomersDB = context.CUSTOMERs.Where(c => privateTypeIds.Any(i => c.CUSTOMER_TYPE_ID == i)).ToList(); foreach (var c in privateCustomersDB) { var customerTypeDB = context.CUSTOMER_TYPEs.Where(ct => ct.ID == c.CUSTOMER_TYPE_ID).FirstOrDefault(); CustomerType customerType = CustomerType.Get(customerTypeDB); var accountDB = context.ACCOUNTs.Where(a => a.ID == c.ACCOUNT_ID).FirstOrDefault(); Account account = Account.Get(accountDB); privateCustomers.Add(new Customer() { Id = c.ID, Account = account, Surname = c.SURNAME, Name = c.NAME, Email = c.EMAIL, Phone = c.PHONE, CustomerType = customerType }); } return(privateCustomers); } }
private static void CreateCustomerModelFromCustomerList(TownUtilityBillSystemV2Entities context, ref List <Customer> customers, List <CUSTOMER> customersDB) { foreach (var c in customersDB) { var customerTypeDB = context.CUSTOMER_TYPEs.Where(ct => ct.ID == c.CUSTOMER_TYPE_ID).FirstOrDefault(); var addressDB = context.ADDRESSes.Where(a => a.ID == c.ADDRESS_ID).FirstOrDefault(); var indexDB = context.INDEXes.Where(i => i.ID == addressDB.INDEX_ID).FirstOrDefault(); var townDB = context.TOWNs.Where(t => t.ID == addressDB.TOWN_ID).FirstOrDefault(); var streetDB = context.STREETs.Where(s => s.ID == addressDB.STREET_ID).FirstOrDefault(); var buildingDB = context.BUILDINGs.Where(b => b.ID == addressDB.BUILDING_ID).FirstOrDefault(); var flatPartDB = context.FLAT_PARTs.Where(fp => fp.ID == addressDB.FLAT_PART_ID).FirstOrDefault(); CustomerType customerType = CustomerType.Get(customerTypeDB); var index = new Index() { Id = indexDB.ID, Value = indexDB.VALUE }; var town = new Town() { Id = townDB.ID, Name = townDB.NAME }; var street = new Street() { Id = streetDB.ID, Name = streetDB.NAME }; var building = new Building() { Id = buildingDB.ID, Number = buildingDB.NUMBER }; FlatPart flatPart = null; if (flatPartDB != null) { flatPart = FlatPart.Get(flatPartDB); } var address = new Address() { Id = addressDB.ID, Index = index, Town = town, Street = street, Building = building, FlatPart = flatPart }; var accountDB = context.ACCOUNTs.Where(a => a.ID == c.ACCOUNT_ID).FirstOrDefault(); Account account = Account.Get(accountDB); customers.Add(new Customer() { Id = c.ID, Account = account, Surname = c.SURNAME, Name = c.NAME, Email = c.EMAIL, Phone = c.PHONE, CustomerType = customerType, Address = address }); } }
public List <Customer> GetAllCustomers() { using (var context = new TownUtilityBillSystemV2Entities()) { var customersDB = context.CUSTOMERs.OrderBy(c => c.SURNAME).ThenBy(c => c.NAME).ToList(); foreach (var c in customersDB) { var customerTypeDB = context.CUSTOMER_TYPEs.Where(ct => ct.ID == c.CUSTOMER_TYPE_ID).FirstOrDefault(); CustomerType customerType = CustomerType.Get(customerTypeDB); var accountDB = context.ACCOUNTs.Where(a => a.ID == c.ACCOUNT_ID).FirstOrDefault(); Account account = Account.Get(accountDB); Customers.Add(new Customer() { Id = c.ID, Account = account, Surname = c.SURNAME, Name = c.NAME, Email = c.EMAIL, Phone = c.PHONE, CustomerType = customerType }); } return(Customers); } }