public bool XoaProduct(int maProduct)
{
Product Product = db.Products.Single(x => x.id == maProduct);
db.Products.DeleteOnSubmit(Product);
db.SubmitChanges();
return(true);
}
public bool XoaProduct_Category(int maProduct_Category)
{
Product_Category Product_Category = db.Product_Categories.Single(x => x.id == maProduct_Category);
db.Product_Categories.DeleteOnSubmit(Product_Category);
db.SubmitChanges();
return(true);
}
public bool XoaEmployee(int maEmployee)
{
Employee employee = db.Employees.Single(x => x.id == maEmployee);
db.Employees.DeleteOnSubmit(employee);
db.SubmitChanges();
suMana.XoaStore_User(maEmployee);
return(true);
}
public bool XoaInvoiceWithId(int maInvoice)
{
foreach (Invoice inc in ListInvoices())
{
if (inc.id == maInvoice)
{
db.Invoices.DeleteOnSubmit(inc);
db.SubmitChanges();
return(true);
}
}
return(false);
}
public bool DeleteFood(int id)
{
DBFoodDataContext db = new DBFoodDataContext();
Food food = db.Foods.FirstOrDefault(x => x.id == id);
if (food == null)
{
return(false);
}
db.Foods.DeleteOnSubmit(food);
db.SubmitChanges();
return(true);
}
public bool XoaOneInvoice_Detail(int maInvoice_Detail, int id_product)
{
try
{
foreach (Invoice_Detail nv in ListInvoice_Details())
{
if (nv.id == maInvoice_Detail && nv.id_product == id_product)
{
db.Invoice_Details.DeleteOnSubmit(nv);
db.SubmitChanges();
TinhTongTienHoaDon(maInvoice_Detail);
return(true);
}
}
return(false);
}
catch (Exception e)
{
//throw e;
return(false);
}
}
public bool DeleteUser(int userid)
{
DBFoodDataContext db = new DBFoodDataContext();
UserProfile userinfo = db.UserProfiles.FirstOrDefault(x => x.UserId == userid);
if (userinfo == null)
{
return(false);
}
db.UserProfiles.DeleteOnSubmit(userinfo);
db.SubmitChanges();
return(true);
}
public bool XoaStore_User(int maStore_User)
{
Store_User Store_User = db.Store_Users.Single(x => x.id == maStore_User);
db.Store_Users.DeleteOnSubmit(Store_User);
db.SubmitChanges();
return(true);
}
public bool InsertNewFood(string name, string type, int price)
{
try
{
DBFoodDataContext db = new DBFoodDataContext();
Food food = new Food();
food.name = name;
food.type = type;
food.price = price;
db.Foods.InsertOnSubmit(food);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool AddUser(string username, string password, bool isactive)
{
try
{
DBFoodDataContext db = new DBFoodDataContext();
UserProfile userinfo = new UserProfile();
userinfo.UserName = username;
userinfo.Password = password.Encrypt();
userinfo.IsActive = isactive;
db.UserProfiles.InsertOnSubmit(userinfo);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateFood(int id, string name, string type, int price)
{
try
{
DBFoodDataContext db = new DBFoodDataContext();
Food food = db.Foods.FirstOrDefault(x => x.id == id);
if (food == null)
{
return(false);
}
food.name = name;
food.type = type;
food.price = price;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateUser(int userid, string username, string password, bool isactive)
{
try
{
DBFoodDataContext db = new DBFoodDataContext();
UserProfile userinfo = db.UserProfiles.FirstOrDefault(x => x.UserId == userid);
if (userinfo == null)
{
return(false);
}
userinfo.UserName = username;
userinfo.Password = password;
userinfo.IsActive = isactive;
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
