public List <KindOfDish> getListKindOfDish() { using (MR = new ManagerResterant()) { try { return(MR.KindOfDishes.ToList()); } catch (Exception e) { MessageBox.Show(e.Message); return(null); } } }
public List <Customer> GetListCustomer() { using (db = new ManagerResterant()) { try { return(db.Customers.ToList()); } catch (SqlException ex) { MessageBox.Show(ex.Message); return(null); } } }
public Dish GetDishById(int id) { using (db = new ManagerResterant()) { try { return(db.Dishes.Find(id)); } catch (SqlException ex) { MessageBox.Show(ex.Message); return(null); } } }
public List <Dish> GetListDish() { using (db = new ManagerResterant()) { try { return(db.Dishes.ToList()); } catch (SqlException ex) { MessageBox.Show(ex.Message); return(null); } } }
public Customer GetCustomerById(int id) { using (db = new ManagerResterant()) { try { return(db.Customers.Find(id)); } catch (SqlException ex) { MessageBox.Show(ex.Message); return(null); } } }
public bool AddCustomer(Customer a) { using (db = new ManagerResterant()) { try { var result = db.Customers.Add(a); db.SaveChanges(); } catch (SqlException ex) { MessageBox.Show(ex.Message); return(false); } } return(true); }
public bool AddEmployee(Employee e) { using (MR = new ManagerResterant()) { try { var result = MR.Employees.Add(e); MR.SaveChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } } }
public bool AddDish(Dish e) { using (db = new ManagerResterant()) { try { var result = db.Dishes.Add(e); db.SaveChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } } }
public bool AddKind(KindOfDish kd) { try { using (MR = new ManagerResterant()) { MR.KindOfDishes.Add(kd); MR.SaveChanges(); return(true); } } catch (Exception e) { MessageBox.Show(e.Message); return(false); } }
public bool DeleteCustomer(int id) { using (db = new ManagerResterant()) { try { var customer = db.Customers.SingleOrDefault(x => x.CustomerId == id); db.Customers.Remove(customer); db.SaveChanges(); return(true); } catch (SqlException ex) { MessageBox.Show(ex.Message); return(false); } } }
public bool DeleteDish(int id) { using (db = new ManagerResterant()) { try { Dish dish = db.Dishes.Find(id); db.Dishes.Remove(dish); db.SaveChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } } }
public bool UpdateKind(KindOfDish kd) { try { using (MR = new ManagerResterant()) { KindOfDish d = MR.KindOfDishes.SingleOrDefault(x => x.KindOfDishId == kd.KindOfDishId); d.Name = kd.Name; MR.SaveChanges(); return(true); } } catch (Exception e) { MessageBox.Show(e.Message); return(false); } }
public bool DeleteKind(int id) { try { using (MR = new ManagerResterant()) { KindOfDish d = MR.KindOfDishes.Find(id); MR.KindOfDishes.Remove(d); MR.SaveChanges(); return(true); } } catch (Exception e) { MessageBox.Show(e.Message); return(false); } }
public int Login(string userName, string passWord) { using (db = new ManagerResterant()) { var result = db.Users.SingleOrDefault(x => x.UserName == userName); if (result == null) { return(0); } else { if (result.Password != passWord) { return(-1); } return(1); } } }
public bool UpdateDish(Dish e) { using (db = new ManagerResterant()) { try { Dish dish = db.Dishes.SingleOrDefault(x => x.DishId == e.DishId); dish.DishName = e.DishName; dish.Price = e.Price; dish.KindOfDishId = e.KindOfDishId; db.SaveChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } } }
public bool DeleteEmployee(int id) { using (MR = new ManagerResterant()) { try { Employee employee = MR.Employees.SingleOrDefault(x => x.EmployeeId == id); MR.Employees.Remove(employee); MR.SaveChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); throw; } } }
public bool UpdateCustomer(Customer a) { using (db = new ManagerResterant()) { try { var newCustomer = db.Customers.SingleOrDefault(x => x.CustomerId == a.CustomerId); newCustomer.CustomerName = a.CustomerName; newCustomer.PhoneNumber = a.PhoneNumber; newCustomer.Email = a.Email; db.SaveChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } } }
public List <Employee> getListEmployee() { using (MR = new ManagerResterant()) { try { List <Employee> ds = MR.Employees.ToList(); //ds.Add //foreach (Employee item in ds) //{ //} return(ds); } catch (Exception e) { MessageBox.Show(e.Message); return(null); } } }
public bool UpdateEmployee(Employee e) { using (MR = new ManagerResterant()) { try { Employee ts = MR.Employees.SingleOrDefault(x => x.EmployeeId == e.EmployeeId); ts.EmployeeName = e.EmployeeName; ts.Gender = e.Gender; ts.Adress = e.Adress; ts.Age = e.Age; ts.Email = e.Email; ts.Phone = e.Phone; MR.SaveChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } } }