public List <ThucUong> ListThucUong() { List <ThucUong> list = new List <ThucUong>(); string query = "select * from thucuong"; using (SqlConnection connection = new SqlConnection(connectionString)) { try { SqlCommand cmd = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { //db to model ThucUong thucUong = new ThucUong(); thucUong.MaHH = reader[0].ToString(); thucUong.TenHangHoa = reader[1].ToString(); thucUong.Gia = Convert.ToInt32(reader[2]); thucUong.TinhTrang = Convert.ToInt32(reader[3]); list.Add(thucUong); } connection.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } return(list); }
//public List<FoodViewModel> Search(string keyword) //{ // var model = (from a in cf.ThucUong // join b in cf.FoodCategory // on a.IDCategory equals b.ID // where a.Name.Contains(keyword) // select new // { // ID = a.ID, // CateName = b.Name, // UrlTitle = a.UrlTitle, // Price = a.Price, // Detail = a.Detail, // Description = a.Description, // Name = a.Name, // Image = a.Image, // }).AsEnumerable().Select(x => new FoodViewModel() // { // ID = x.ID, // CateName = x.Name, // UrlTitle = x.UrlTitle, // Price = x.Price, // Detail = x.Detail, // Description = x.Description, // Name = x.Name, // Image = x.Image, // }); // //model.OrderByDescending(x => x.ID).Skip((pageIndex - 1) * pageSize).Take(pageSize); // return model.ToList(); //} public bool Insert(ThucUong thucuong) { try { cf.ThucUongs.Add(thucuong); cf.SaveChanges(); return(true); } catch { return(false); } }
public void AddItem(ThucUong thucUong, int soLuong, int TiLeGiam) { ListViewItem item = new ListViewItem(thucUong.TenHangHoa); item.SubItems.Add(soLuong.ToString()); item.SubItems.Add(thucUong.Gia.ToString()); item.SubItems.Add(TiLeGiam.ToString()); item.SubItems.Add(GetThucUongToTal(thucUong.Gia, soLuong, TiLeGiam).ToString()); item.SubItems.Add(thucUong.MaHH); listViewDSThucUong.Items.Add(item); listViewDSThucUong.AutoResizeColumn(0, ColumnHeaderAutoResizeStyle.HeaderSize); listViewDSThucUong.AutoResizeColumn(1, ColumnHeaderAutoResizeStyle.HeaderSize); listViewDSThucUong.AutoResizeColumn(2, ColumnHeaderAutoResizeStyle.HeaderSize); listViewDSThucUong.AutoResizeColumn(3, ColumnHeaderAutoResizeStyle.HeaderSize); listViewDSThucUong.AutoResizeColumn(4, ColumnHeaderAutoResizeStyle.HeaderSize); }
public ActionResult Edit(ThucUong model) { if (ModelState.IsValid) { SetViewBag(model.IDCaterogy); var kq = new FoodDao().Update(model); if (kq) { SetAlert("Sửa món thành công", "success"); return(Redirect("/Admin/Food/DSFood")); } } SetViewBag(); return(View(model)); }
public bool Update(ThucUong model) { try { var food = cf.ThucUongs.Find(model.ID); food.IDCaterogy = model.IDCaterogy; food.Name = model.Name; food.Price = model.Price; food.Image = model.Image; food.Description = model.Description; food.Detail = model.Detail; cf.SaveChanges(); return(true); } catch { return(false); } }
private void CrystalReportViewer1_Load(object sender, EventArgs e) { List <HoaDon> hds = new HoaDon().getListHoaDon(); List <MonAn> mas = new MonAn().GetMonAns(); List <ThucUong> tus = new ThucUong().GetThucUongs(); List <NhanVien> nvs = new NhanVien().getListNhanVien(); List <BestSellerFood> bestSellerFoods = new BestSellerFood().GetBestSellerFoods(tungay, denngay); List <BestSellerItem> bestSellerItems = new BestSellerItem().GetBestSellerDrinks(tungay, denngay); hDreport1.Database.Tables[0].SetDataSource(hds);// này là cái list món ăn thức uống trong hóa đơn hDreport1.Database.Tables[1].SetDataSource(tus); hDreport1.Database.Tables[2].SetDataSource(nvs); hDreport1.Database.Tables[3].SetDataSource(mas); hDreport1.Database.Tables[4].SetDataSource(bestSellerFoods); hDreport1.Database.Tables[5].SetDataSource(bestSellerItems); hDreport1.SetParameterValue("ptungay", from); hDreport1.SetParameterValue("pdenngay", to); hDreport1.SetParameterValue("pnguoitao", nguoitao); hDreport1.SetParameterValue("pngaytaobaocao", ngaytao); hDreport1.SetParameterValue("pthucthu", thucthu); hDreport1.SetParameterValue("psohoadon", sohd); crystalReportViewer1.ReportSource = hDreport1; }