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