public bool SuaDoUong(DoUong o) { var kq = TimDoUong(o.IDDoUong); try { if (kq == null) { return(false); } else { kq.TenDoUong = o.TenDoUong; kq.IDLoai = o.IDLoai; kq.GiaGoc = o.GiaGoc; kq.GiaBan = o.GiaBan; kq.SoLuong = o.SoLuong; kq.NgayNhapHang = o.NgayNhapHang; kq.DonViTinh = o.DonViTinh; dc.SubmitChanges(); return(true); } } catch { return(false); } }
protected void btnSaveChanges_Click(object sender, EventArgs e) { if (Request.QueryString["Action"] == "Edit") { int maChuyenMuc = Convert.ToInt32(txtMaChuyenMuc.Text); DoUong obj = new DoUong(maChuyenMuc, txtTenChuyenMuc.Text); XuLyDoUong xl = new XuLyDoUong(); int result = xl.SuaChuyenMuc(obj); if (result <= 0) { lblError.ForeColor = Color.Red; lblError.Text = "Sửa chuyên mục không thành công. Vui lòng kiểm tra lại dữ liệu"; } else { lblError.ForeColor = Color.Blue; lblError.Text = "Sửa dữ liệu thành công"; } LoadChuyenMuc(); } else { btnSave_Click(sender, e); } }
private void BtnDoUong_MouseClick(object sender, MouseEventArgs e) { try { Ban ban = listViewHoaDon.Tag as Ban; int idHoaDon = HoaDonDAL.Instance.LayIDHoaDonTuIDBan(ban._ID); DoUong doUong = (sender as Button).Tag as DoUong; int idDoUong = doUong.ID; if (idHoaDon == -1) { HoaDonDAL.Instance.ThemHoaDon(ban._ID, thuNgan); ChiTietHoaDonDAL.Instance.ThemChiTietHoaDon(HoaDonDAL.Instance.MAXIDHoaDon(), idDoUong, 1); } else { ChiTietHoaDonDAL.Instance.ThemChiTietHoaDon(idHoaDon, idDoUong, 1); } HienThiHoaDonTheoBan(ban._ID); //Load bàn khi thêm đồ uống LoadDanhSachBan(); } catch (Exception) { } }
public int SuaChuyenMuc(DoUong obj) { SqlParameter mcm = new SqlParameter("@idCategoryDrink", obj.MaChuyenMuc); SqlParameter tcm = new SqlParameter("@Name", obj.TenChuyenMuc); SqlParameter[] sqlParams = { mcm, tcm }; return(dl.SaveChanges("UPDATE DrinkCategory SET Name = @Name WHERE idCategoryDrink = @idCategoryDrink", sqlParams)); }
public int ThemChuyenMuc(DoUong obj) { SqlParameter mcm = new SqlParameter("@idCategoryDrink", obj.MaChuyenMuc); SqlParameter tcm = new SqlParameter("@Name", obj.TenChuyenMuc); SqlParameter[] sqlParams = { mcm, tcm }; return(dl.SaveChanges("INSERT INTO [dbo].[DrinkCategory]([idCategoryDrink],[Name]) VALUES(@idCategoryDrink,@Name)", sqlParams)); }
public int LayIDDoUongTuIDHoaDon(int id) { DataTable data = DataProvider.Instance.ExecuteQuery("SELECT IDDoUong FROM ThongTinHoaDon WHERE IDHoaDon = '" + id + "'"); if (data.Rows.Count > 0) { DoUong du = new DoUong(data.Rows[2]); return(du.ID); } return(-1); }
public int GetDonGiaDoUong(string maDoUong) { int donGia = 0; DoUong du = qlcf.DoUongs.Where(d => d.MaDoUong == maDoUong).FirstOrDefault(); if (du != null) { donGia = du.Gia; } return(donGia); }
public List <DoUong> LayDanhSachDoUongTheoID(int id) { List <DoUong> ds = new List <DoUong>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM DoUong WHERE IDDanhMuc = " + id); foreach (DataRow item in data.Rows) { DoUong nuoc = new DoUong(item); ds.Add(nuoc); } return(ds); }
public List <DoUong> LayDanhSachDoUong() { List <DoUong> ds = new List <DoUong>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM DoUong ORDER BY tenThucUong"); foreach (DataRow item in data.Rows) { DoUong nuoc = new DoUong(item); ds.Add(nuoc); } return(ds); }
public bool KiemTraTonTaiDoUong(string maDanhMuc) { DoUong doUong = qlcf.DoUongs.Where(du => du.MaDanhMuc == maDanhMuc).FirstOrDefault(); if (doUong == null) { return(false); } else { return(true); } }
public void InsertDoUong(string maDoUong, string tenDoUong, string maDanhMuc, int giaBan, string hinhMinhHoa) { DoUong doUong = new DoUong(); doUong.MaDoUong = maDoUong; doUong.TenDoUong = tenDoUong; doUong.MaDanhMuc = maDanhMuc; doUong.Gia = giaBan; doUong.HinhMinhHoa = hinhMinhHoa; qlcf.DoUongs.InsertOnSubmit(doUong); qlcf.SubmitChanges(); }
public void UpdateDoUong(string maDoUong, string tenDoUong, string maDanhMuc, int giaBan, string hinhMinhHoa) { DoUong doUong = qlcf.DoUongs.Where(du => du.MaDoUong == maDoUong).FirstOrDefault(); if (doUong != null) { doUong.TenDoUong = tenDoUong; doUong.MaDanhMuc = maDanhMuc; doUong.Gia = giaBan; doUong.HinhMinhHoa = hinhMinhHoa; qlcf.SubmitChanges(); } }
public bool ThemDoUong(DoUong o) { // var kq = TimLoaiDU(o.IDLoai); try { dc.DoUongs.InsertOnSubmit(o); dc.SubmitChanges(); return(true); } catch { return(false); } }
public static void ThemDoUongVaoBan(DoUong sp, int soLuong = 1) { var kq = ChiTietBan.TimDoUong(sp.IDDoUong); //if (kq.Quantity < sp.SoLuongDaMua) return; if (kq == null) { kq = sp; ds.Add(kq); kq.SoLuong = soLuong; } else { kq.SoLuong += soLuong; } }
public string PhatSinhMaDoUong(string maDanhMuc) { string maDoUong = maDanhMuc; List <DoUong> doUongs = qlcf.DoUongs.Where(du => du.MaDanhMuc == maDanhMuc).Select(du => du).ToList(); DoUong doUong = doUongs.LastOrDefault(); if (doUong == null) { maDoUong += "100"; } else { int k; k = Convert.ToInt32(doUong.MaDoUong.Substring(2, 3)); k += 1; maDoUong += k.ToString(); } return(maDoUong); }
public void DeleteDoUong(string maDoUong) { List <CongThuc> cts = qlcf.CongThucs.Where(ct => ct.MaDoUong == maDoUong).ToList(); DoUong doUong = qlcf.DoUongs.Where(du => du.MaDoUong == maDoUong).FirstOrDefault(); if (doUong != null) { if (cts != null) { foreach (var item in cts) { qlcf.CongThucs.DeleteOnSubmit(item); qlcf.SubmitChanges(); } } qlcf.DoUongs.DeleteOnSubmit(doUong); qlcf.SubmitChanges(); } }
protected void btnSave_Click(object sender, EventArgs e) { int maChuyenMuc = Convert.ToInt32(txtMaChuyenMuc.Text); DoUong obj = new DoUong(maChuyenMuc, txtTenChuyenMuc.Text); XuLyDoUong xl = new XuLyDoUong(); int result = xl.ThemChuyenMuc(obj); if (result <= 0) { lblError.ForeColor = Color.Red; lblError.Text = "Thêm chuyên mục không thành công. Vui lòng kiểm tra lại dữ liệu"; } else { lblError.ForeColor = Color.Blue; lblError.Text = "Thêm dữ liệu thành công"; LoadChuyenMuc(); } }