public List <CustomerViewModel> GetAllCustomers() { List <CustomerViewModel> customerViews = new List <CustomerViewModel>(); using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { List <Customer> customers = db.Customers.ToList() ?? new List <Customer>(); foreach (Customer c in customers) { CustomerViewModel customer = new CustomerViewModel(); customer.id = c.id; customer.Name = c.Name; customer.Address_1 = c.Address_1; customer.Address_2 = c.Address_2; customer.City = c.City1.Name; customer.Country = c.Country; customer.Post_Code = c.Post_Code; customer.Email = c.Email; customer.Mobile = c.Mobile; customer.Birth_Date = c.Birth_Date; customer.Active = c.Active; customer.Create_Date = c.Create_Date; customer.Update_Date = c.Update_Date; customerViews.Add(customer); } } return(customerViews); }
public Customer GetCustomer(int id) { using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { Customer customer = db.Customers.Find(id) ?? new Customer(); return(customer); } }
public List <Customer> GetAllCustomers() { using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { List <Customer> customers = db.Customers.ToList() ?? new List <Customer>(); return(customers); } }
public List <City> GetAllCities() { List <City> cities; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { cities = db.Cities.ToList() ?? new List <City>(); } return(cities); }
public bool UpdateCustomer(Customer customer) { bool status = false; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { db.Entry(customer).State = EntityState.Modified; if (db.SaveChanges() > 0) { status = true; } } return(status); }
public bool InsertCustomer(Customer customer) { bool status = false; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { db.Customers.Add(customer); if (db.SaveChanges() > 0) { status = true; } } return(status); }
public CityViewModel GetCity(int id) { CityViewModel city = new CityViewModel(); using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { City c = db.Cities.Find(id); city.id = c.id; city.Name = c.Name; city.Created_Date = c.Created_Date; city.Updated_Date = c.Updated_Date; } return(city); }
public bool IsEmailExist(string email) { bool status = false; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { Customer customer = db.Customers.Where(x => x.Email == email).FirstOrDefault(); if (customer != null) { status = true; } } return(status); }
public bool DeleteCustomer(int id) { bool status = false; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { Customer customer = db.Customers.Find(id) ?? new Customer(); if (customer != null) { db.Customers.Remove(customer); if (db.SaveChanges() > 0) { status = true; } } } return(status); }
public bool DeleteCity(int id) { bool status = false; using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { City city = db.Cities.Find(id) ?? new City(); if (city != null) { db.Cities.Remove(city); if (db.SaveChanges() > 0) { status = true; } } } return(status); }
public List <CityViewModel> GetAllCities() { List <CityViewModel> cityViewModels = new List <CityViewModel>(); using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { List <City> cities = db.Cities.ToList() ?? new List <City>(); foreach (City c in cities) { CityViewModel city = new CityViewModel(); city.id = c.id; city.Name = c.Name; city.Created_Date = c.Created_Date; city.Updated_Date = c.Updated_Date; cityViewModels.Add(city); } } return(cityViewModels); }
public CustomerViewModel GetCustomer(int id) { CustomerViewModel customer = new CustomerViewModel(); using (CustomerDetailsEntities db = new CustomerDetailsEntities()) { Customer c = db.Customers.Find(id) ?? new Customer(); customer.id = c.id; customer.Name = c.Name; customer.Address_1 = c.Address_1; customer.Address_2 = c.Address_2; customer.City = c.City1.Name; customer.Country = c.Country; customer.Post_Code = c.Post_Code; customer.Email = c.Email; customer.Mobile = c.Mobile; customer.Birth_Date = c.Birth_Date; customer.Active = c.Active; customer.Create_Date = c.Create_Date; customer.Update_Date = c.Update_Date; } return(customer); }