public List <Company> GetCompanies() { using (var db = new Data.MyInsuranceEntities()) { var companyData = db.Companies.ToList(); return(_companyMapper.ToModelList(companyData)); } }
public Offer GetOffer(int Id) { using (var db = new Data.MyInsuranceEntities()) { var offerData = db.Offers.FirstOrDefault(o => o.Id == Id); return(_offerMapper.ToModel(offerData)); } }
public Company GetCompany(int Id) { using (var db = new Data.MyInsuranceEntities()) { var companyData = db.Companies.FirstOrDefault(c => c.Id == Id); return(_companyMapper.ToModel(companyData)); } }
public Customer GetCustomer(string TcNumber, string PlateNumber) { using (var db = new Data.MyInsuranceEntities()) { var customerData = db.Customers.Include(o => o.CustomerCar).FirstOrDefault(c => c.TCNumber == TcNumber && c.PlateNumber == PlateNumber); return(_customerMapper.ToModel(customerData)); } }
public Customer Create(Customer customer) { using (var db = new Data.MyInsuranceEntities()) { var customerData = _customerMapper.ToData(customer); var foundCustomer = db.Customers.FirstOrDefault(c => c.TCNumber == customer.TCNumber && c.PlateNumber == customer.CustomerCar.PlateNumber); if (foundCustomer == null) { db.Customers.Add(customerData); db.SaveChanges(); } customerData = db.Customers.FirstOrDefault(c => c.TCNumber == customer.TCNumber && c.PlateNumber == customer.CustomerCar.PlateNumber); return(_customerMapper.ToModel(customerData)); } }
public List <Offer> GetCustomerOffers(string TcNumber) { using (var db = new Data.MyInsuranceEntities()) { var offerData = db.Offers .Include(o => o.OfferDetail) .Include(o => o.Customer) .Include(o => o.Customer.CustomerCar) .Include(o => o.Company) .Where(o => o.CustomerTcNumber == TcNumber) .ToList(); offerData.ForEach(o => o.Customer.Offers = null); offerData.ForEach(o => o.Company.Offers = null); return(_offerMapper.ToModelList(offerData)); } }
public Offer Create(Offer offer) { var offerData = _offerMapper.ToData(offer); using (var db = new Data.MyInsuranceEntities()) { db.Offers.Add(offerData); db.SaveChanges(); offerData = db.Offers .Include(o => o.Customer) .Include(o => o.Customer.CustomerCar) .Include(o => o.Company) .OrderByDescending(o => o.Id).First(); offerData.Customer.Offers = null; offerData.Company.Offers = null; return(_offerMapper.ToModel(offerData)); } }