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);
        }
Esempio n. 2
0
 public Customer GetCustomer(int id)
 {
     using (CustomerDetailsEntities db = new CustomerDetailsEntities())
     {
         Customer customer = db.Customers.Find(id) ?? new Customer();
         return(customer);
     }
 }
Esempio n. 3
0
 public List <Customer> GetAllCustomers()
 {
     using (CustomerDetailsEntities db = new CustomerDetailsEntities())
     {
         List <Customer> customers = db.Customers.ToList() ?? new List <Customer>();
         return(customers);
     }
 }
Esempio n. 4
0
        public List <City> GetAllCities()
        {
            List <City> cities;

            using (CustomerDetailsEntities db = new CustomerDetailsEntities())
            {
                cities = db.Cities.ToList() ?? new List <City>();
            }
            return(cities);
        }
Esempio n. 5
0
        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);
        }
Esempio n. 6
0
        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);
        }
Esempio n. 7
0
        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);
        }
Esempio n. 9
0
        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);
        }
Esempio n. 10
0
        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);
        }
Esempio n. 11
0
        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);
        }