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