public List<CTHoaDon> loadCTHoaDon_with_MaHoaDon(string mahoadon)
{
int param = 1;
string[] names = new string[param];
Object[] values = new Object[param];
names[0] = "@maHoaDon";
values[0] = mahoadon;
DataTable dt = db.LoadData("CTHOADON_proc_load_with_MaHoaDon", names, values, param);
List<CTHoaDon> list = new List<CTHoaDon>();
foreach (DataRow row in dt.Rows)
{
CTHoaDon cthd = new CTHoaDon();
MonAn ma = new MonAn();
HoaDon hd = new HoaDon();
ma.MaMonAn = row["MaMonAn"].ToString();
ma.TenMonAn = row["TenMonAn"].ToString();
ma.DonGia = decimal.Parse(row["DonGia"].ToString());
cthd.MonAn = ma;
cthd.MaCTHoaDon = row["MaCTHoaDon"].ToString();
hd.MaHoaDon = row["MaHoaDon"].ToString();
cthd.HoaDon = hd;
cthd.SoLuong = int.Parse(row["SoLuong"].ToString());
cthd.DaChuanBi = bool.Parse(row["DaChuanBi"].ToString());
cthd.GhiChu = row["GhiChu"].ToString();
list.Add(cthd);
}
return list;
}
private void btnDongY_Click(object sender, EventArgs e)
{
if(txtTenMonAn.Text == "")
{
MessageBox.Show("Nhập tên món ăn", " Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTenMonAn.Focus();
return;
}
if (dipDonGia.Text == "0")
{
MessageBox.Show("Nhập lại đơn giá", " Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
dipDonGia.Focus();
return;
}
MonAn monAn = new MonAn();
monAn.MaMonAn = txtMaMon.Text.Trim();
monAn.TenMonAn = txtTenMonAn.Text.Trim();
monAn.DonGia = (decimal)dipDonGia.Value;
monAn.HinhAnh = "";
monAn.DonViTinh = cbxDonViTinh.SelectedItem as DonViTinh;
monAn.LoaiMon = cbLoaiMon.SelectedItem as LoaiMon;
if( monAnBus.insertMonAn(monAn) != 0)
{
this.Close();
MessageBox.Show("Đã thêm món ăn mới", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
Global.thucDon.refreshMonAnList();
}
}
public YeuCauMon(MonAn monAn)
{
monan = monAn;
InitializeComponent();
txtTenMon.Text = monan.TenMonAn;
txtDonGia.Text = monan.DonGia.ToString("#,###");
dipSoLuong.Value = 1;
thanhTien = monan.DonGia * (decimal)dipSoLuong.Value;
txtThanhTien.Text = thanhTien.ToString("#,###");
}
public int findMonAn(MonAn monAn)
{
int param = 1;
string[] names = new string[param];
Object[] values = new Object[param];
names[0] = "@tenMonAn";
values[0] = monAn.TenMonAn;
return db.Update("MONAN_proc_find", names, values, param);
}
public SuaMonAn(MonAn monAn)
{
InitializeComponent();
txtMaMon.Text = monAn.MaMonAn;
txtTenMonAn.Text = monAn.TenMonAn;
dipDonGia.Value = (double)monAn.DonGia;
cbLoaiMon.DataSource = loaiMonBus.getLoaiMonList();
cbxDonViTinh.DataSource = donvitinhBUS.getDonViTinhList();
cbxDonViTinh.SelectedItem = monAn.DonViTinh;
cbLoaiMon.SelectedItem = monAn.LoaiMon;
}
public int updateMonAn(MonAn monAn)
{
int param = 6;
string[] names = new string[param];
Object[] values = new Object[param];
names[0] = "@maMonAn";
names[1] = "@tenMonAn";
names[2] = "@hinhAnh";
names[3] = "@donGia";
names[4] = "@maDonVi";
names[5] = "@maLoaiMon";
values[0] = monAn.MaMonAn;
values[1] = monAn.TenMonAn;
values[2] = monAn.HinhAnh;
values[3] = monAn.DonGia;
values[4] = monAn.DonViTinh.MaDonVi;
values[5] = monAn.LoaiMon.MaLoaiMon;
return db.Update("MONAN_proc_update", names, values, param);
}
public int updateMonAn(MonAn monan)
{
return monAnDAO.updateMonAn(monan);
}
public int insertMonAn(MonAn monan)
{
return monAnDAO.insertMonAn(monan);
}
public List<MonAn> getMonAnList_With_MaLoaiMon(string maLoaiMon)
{
int param = 1;
string[] names = new string[param];
Object[] values = new Object[param];
names[0] = "@maLoaiMon";
values[0] = maLoaiMon;
DataTable tb = db.LoadData("MONAN_proc_load_with_MaLoaiMon", names, values, param);
List<MonAn> list = new List<MonAn>();
foreach (DataRow row in tb.Rows)
{
MonAn monan = new MonAn();
LoaiMon loaimon = new LoaiMon();
DonViTinh donvi = new DonViTinh();
loaimon.MaLoaiMon = row["MaLoaiMon"].ToString();
loaimon.TenLoaiMon = row["TenLoaiMon"].ToString();
monan.LoaiMon = loaimon;
monan.MaMonAn = row["MaMonAn"].ToString();
monan.TenMonAn = row["TenMonAn"].ToString();
donvi.MaDonVi = row["MaDonVi"].ToString();
donvi.TenDonVi = row["TenDonVi"].ToString();
monan.DonViTinh = donvi;
monan.HinhAnh = row["HinhAnh"].ToString();
monan.DonGia = decimal.Parse(row["DonGia"].ToString());
list.Add(monan);
}
return list;
}
