// tìm kiếm theo name public List <CategoryItem> searchCateByNameCate(string name) { List <CategoryItem> listCate = new List <CategoryItem>(); using (DataBaseCoffeeDataContext db = new DataBaseCoffeeDataContext()) { var data = from cate in db.FoodCategories where cate.namecategory.Contains(name) select cate; foreach (FoodCategory item in data) { listCate.Add(new CategoryItem(item)); } listCate.Sort(); } return(listCate); }
public bool insert(FoodCategory cate) { List <CategoryItem> listCate = loadCate(); using (DataBaseCoffeeDataContext db = new DataBaseCoffeeDataContext()) { foreach (CategoryItem item in listCate) { if (cate.namecategory.Equals(item.NameCate)) { return(false); } } db.FoodCategories.InsertOnSubmit(cate); db.SubmitChanges(); } return(true); }
// insert sản phẩm public bool insertProduct(Food pro, string nameCate) { List <Product> listPro = loadProduct(); using (DataBaseCoffeeDataContext db = new DataBaseCoffeeDataContext()) { foreach (Product item in listPro) { if (item.Name.Equals(pro.foodname) && item.Namecate.Equals(nameCate)) { return(false); } } db.Foods.InsertOnSubmit(pro); db.SubmitChanges(); } return(true); }
// tìm kiếm sản phẩm theo tên sản phẩm và tên danh mục public List <Product> loadProductByNameCateAndNamePro(string namePro, string nameCate) { List <Product> listPro = new List <Product>(); List <string> listSaveName = new List <string>(); if (nameCate.Equals("Tất Cả")) { using (DataBaseCoffeeDataContext db = new DataBaseCoffeeDataContext()) { var data = from food in db.Foods join detail in db.detailFoods on food.idfood equals detail.idfood where food.foodname.Contains(namePro) && detail.status == "Hiển Thị" select new { food.idfood, food.foodname, detail.status, food.idcategory }; foreach (var item in data) { Product pro = new Product(item.idfood, item.foodname, item.status); if (!listSaveName.Contains(pro.Name + "/" + item.idcategory)) { listSaveName.Add(pro.Name + "/" + item.idcategory); listPro.Add(pro); } } listPro.Sort(); } return(listPro); } else { using (DataBaseCoffeeDataContext db = new DataBaseCoffeeDataContext()) { var data = from food in db.Foods join cate in db.FoodCategories on food.idcategory equals cate.idcategory join detail in db.detailFoods on food.idfood equals detail.idfood where cate.namecategory == nameCate && food.foodname.Contains(namePro) && detail.status == "Hiển Thị" select new { food.idfood, food.foodname, detail.status }; foreach (var item in data) { Product pro = new Product(item.idfood, item.foodname, item.status); if (!listSaveName.Contains(pro.Name)) { listSaveName.Add(pro.Name); listPro.Add(pro); } } listPro.Sort(); } } return(listPro); }
public bool insertStaff(Account staff) { try { using (DataBaseCoffeeDataContext db = new DataBaseCoffeeDataContext()) { foreach (Staff item in loadStaff()) { if (item.Username.Equals(staff.username)) { return(false); } } db.Accounts.InsertOnSubmit(staff); db.SubmitChanges(); return(true); } } catch (Exception) { return(false); } }