public int addLoaiMon(LoaiMon loaiMon) { int param = 2; string[] names = new string[param]; Object[] values = new Object[param]; names[0] = "@maLoaiMon"; names[1] = "@tenLoaiMon"; values[0] = loaiMon.MaLoaiMon; values[1] = loaiMon.TenLoaiMon; return db.Update("LOAIMON_proc_insert", names, values, param); }
public List<LoaiMon> getAllLoaiMon() { DataTable tb = db.LoadData("LOAIMON_proc_load"); List<LoaiMon> list = new List<LoaiMon>(); foreach(DataRow row in tb.Rows) { LoaiMon lm = new LoaiMon(); lm.MaLoaiMon = row["MaLoaiMon"].ToString(); lm.TenLoaiMon = row["TenLoaiMon"].ToString(); list.Add(lm); } return list; }
private void btnDongY_Click(object sender, EventArgs e) { if (txtTenLoaiMon.Text == "") { MessageBox.Show("Nhập tên món ăn", " Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); txtTenLoaiMon.Focus(); return; } LoaiMon loaiMon = new LoaiMon(); loaiMon.MaLoaiMon = txtMaLoaiMon.Text.Trim(); loaiMon.TenLoaiMon = txtTenLoaiMon.Text.Trim(); if (loaimonBus.addLoaiMon(loaiMon) != 0) { MessageBox.Show("Đã thêm loại món mới", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Global.thucDon.parseDataLoaiMon(Global.getListLoaiMon()); this.Close(); } }
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; }
public int addLoaiMon(LoaiMon loaiMon) { return loaimonDAO.addLoaiMon(loaiMon); }