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