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