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));
}
}
