public bool ThemLoaiMon(LoaiMonDTO lmDto)
{
Connect();
SqlCommand cmd = new SqlCommand("spThemLoaiMon", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@tenloaimon", SqlDbType.NVarChar);
cmd.Parameters.Add("@maloaimoncha", SqlDbType.Int);
cmd.Parameters.Add("@laloaimonla", SqlDbType.Bit);
cmd.Parameters["@tenloaimon"].Value = lmDto.Ten_loai_mon;
cmd.Parameters["@maloaimoncha"].Value = lmDto.Ma_loai_mon_cha;
cmd.Parameters["@laloaimonla"].Value = lmDto.La_loai_mon_la;
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Disconnect();
return(false);
}
Disconnect();
return(true);
}
public static List <LoaiMonDTO> LayDanhSachTatCaLoaiMon()
{
SqlConnection connection = DataProvider.GetConnection();
string query = "SELECT ma_loai_mon, ten_loai_mon, la_do_uong, trang_thai FROM LoaiMon";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <LoaiMonDTO> result = new List <LoaiMonDTO>();
if (reader.HasRows)
{
while (reader.Read())
{
LoaiMonDTO loaiMon = new LoaiMonDTO();
loaiMon.MaLoaiMon = reader.GetInt32(0);
loaiMon.TenLoaiMon = reader.GetString(1);
loaiMon.LaDoUong = reader.GetBoolean(2);
loaiMon.TrangThai = reader.GetBoolean(3);
result.Add(loaiMon);
}
}
connection.Close();
return(result);
}
public LoaiMonDTO[] DanhSachLoaiMon()
{
LoaiMonDTO[] Kq;
Connect();
SqlCommand cmd = new SqlCommand("spLayDanhSachLoaiMonAn", cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
int i = 0;
int n = dt.Rows.Count;
Kq = new LoaiMonDTO[n];
for (i = 0; i < n; ++i)
{
object loaithe = GetDataFromDataRow(dt, i);
Kq[i] = (LoaiMonDTO)loaithe;
}
Disconnect();
return(Kq);
}
private void btnThemLoaiMon_Click(object sender, EventArgs e)
{
if (txtTenLoaiMon.Text == "")
{
MessageBox.Show("Vui lòng nhập đủ thông tin!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
LoaiMonDTO loaiMon = new LoaiMonDTO();
loaiMon.TenLoaiMon = txtTenLoaiMon.Text;
loaiMon.LaDoUong = chkDoUong.Checked;
loaiMon.TrangThai = true;
if (LoaiMonBUS.ThemLoaiMon(loaiMon, LayDanhSachCheckBoxLoaiTopping(true)))
{
MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LamMoiLoaiMon();
QLLM_LoadDanhSachLoaiMon();
dgvLoaiMon.ClearSelection();
}
else
{
MessageBox.Show("Thêm thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
loaiMon = null;
}
}
private void txbIDFood_TextChanged(object sender, EventArgs e)// hiển thị loại món ăn theo ID food
{
if (dtgvFood.SelectedCells.Count > 0)
{
int id = (int)dtgvFood.SelectedCells[0].OwningRow.Cells["MALOAI"].Value;
LoaiMonDTO LoaiMA = DanhMucDAO.Instance.LayDanhSachLoaiMonAnTheoID(id);
cbType.SelectedItem = LoaiMA;
int index = -1;
int i = 0;
foreach (LoaiMonDTO item in cbType.Items)
{
if (item.TenLoai == LoaiMA.TenLoai)
{
index = i;
break;
}
i++;
}
cbType.SelectedIndex = index;
}
}
protected void ThemLoaiMonMoi()
{
LoaiMonDTO lmDto = new LoaiMonDTO();
//Lấy tham số client truyền xuống
lmDto.Ten_loai_mon = XL_CHUOI.Nhap(Request, "tenloaimon");
lmDto.Ma_loai_mon_cha = int.Parse(XL_CHUOI.Nhap(Request, "maloaimoncha"));
lmDto.La_loai_mon_la = bool.Parse(XL_CHUOI.Nhap(Request, "laloaimonla"));
//Thêm loại món mới
LoaiMonBUS khBus = new LoaiMonBUS();
bool kq = new LoaiMonBUS().ThemLoaiMon(lmDto);
XL_THE the = new XL_THE("goc");
XL_THUOC_TINH thuoc_tinh;
//Them thanh cong
if (kq == true)
{
thuoc_tinh = new XL_THUOC_TINH("kq", "True");
}
else
{
thuoc_tinh = new XL_THUOC_TINH("kq", "False");
}
//Trả kết quả về client
the.Danh_sach_thuoc_tinh.Add(thuoc_tinh);
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
if (txtTenLoaiMon.Text == "")
{
MessageBox.Show("Bạn chưa nhập đầy đủ hoặc bỏ trống thông tin loại món ăn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
LoaiMonDTO loaiMon = new LoaiMonDTO();
loaiMon.MaLoaiMon = txtMaLoaiMon.Text;
loaiMon.TenLoaiMon = txtTenLoaiMon.Text;
loaiMon.TrangThai = chkTrangThai.Checked;
if (LoaiMonBUS.SuaLoaiMon(loaiMon))
{
//MessageBox.Show("Cập nhật loại món ăn thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.None);
LamMoi();
LoadDSLoaiMon();
XoaForm(true);
}
else
{
MessageBox.Show("Cập nhật loại món ăn thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
loaiMon = null;
}
}
}
public LoaiMonDTO[] DanhSachLoaiMonCon(int MaLMCha)
{
LoaiMonDTO[] kq;
Connect();
SqlCommand cmd = new SqlCommand("spDanhSachLoaiMonCon", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@malmcha", SqlDbType.Int);
cmd.Parameters["@malmcha"].Value = MaLMCha;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable tab = new DataTable();
da.Fill(tab);
int n = tab.Rows.Count;
kq = new LoaiMonDTO[n];
for (int i = 0; i < n; ++i)
{
object loaimon = GetDataFromDataRow(tab, i);
kq[i] = (LoaiMonDTO)loaimon;
}
Disconnect();
return(kq);
}
public LoaiMonDTO ChiTietLoaiMon(int maloaimon)
{
Connect();
SqlCommand cmd = new SqlCommand("spChiTietLoaiMon", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ma_loai_mon", SqlDbType.Int);
cmd.Parameters["@ma_loai_mon"].Value = maloaimon;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable tab = new DataTable();
da.Fill(tab);
LoaiMonDTO kq = new LoaiMonDTO();
object loaimon = GetDataFromDataRow(tab, 0);
kq = (LoaiMonDTO)loaimon;
Disconnect();
return(kq);
}
public static bool SuaLoaiMon(LoaiMonDTO loaiMon, List <CTLoaiMon_LoaiToppingDTO> lsLoaiMon_LoaiTopping)
{
if (CTLoaiMon_LoaiToppingBUS.SuaLoaiMon_LoaiTopping(loaiMon.MaLoaiMon, lsLoaiMon_LoaiTopping))
{
return(LoaiMonDAO.SuaLoaiMon(loaiMon));
}
return(false);
}
public static bool ThemLoaiMon(LoaiMonDTO loaiMon, List <CTLoaiMon_LoaiToppingDTO> lsLoaiMon_LoaiTopping)
{
if (LoaiMonDAO.ThemLoaiMon(loaiMon))
{
return(CTLoaiMon_LoaiToppingBUS.ThemLoaiMon_LoaiTopping(lsLoaiMon_LoaiTopping));
}
return(false);
}
public static bool SuaLoaiMon(LoaiMonDTO loaiMon)
{
string query = "UPDATE tblLoaiMonAn SET TenLoaiMon=@tenLoaiMon,TrangThai=@trangThai WHERE MaLoaiMon=@maLoaiMon";
SqlParameter[] parameter = new SqlParameter[3];
parameter[0] = new SqlParameter("@maLoaiMon", loaiMon.MaLoaiMon);
parameter[1] = new SqlParameter("@tenLoaiMon", loaiMon.TenLoaiMon);
parameter[2] = new SqlParameter("@trangThai", loaiMon.TrangThai);
return(DataProvider.ExecuteUpdateQuery(query, parameter) == 1);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
LoaiMonDTO loaimon = new LoaiMonDTO();
loaimon.Ma_loai_mon = (int)dt.Rows[i]["MaLoaiMon"];
loaimon.Ten_loai_mon = dt.Rows[i]["TenLoaiMon"].ToString();
loaimon.Ma_loai_mon_cha = (int)dt.Rows[i]["MaLoaiMonCha"];
loaimon.La_loai_mon_la = (bool)dt.Rows[i]["LaLoaiMonLa"];
return((object)loaimon);
}
public void HienDSTheLoaiMon(string maLoaiMon)
{
List <rptMonAnDTO> lsMon = rptMonAnBUS.ReportLayDSMonAnTheoMaLoaiMon(maLoaiMon);
rpvBaoCao.LocalReport.ReportEmbeddedResource = s + "rptDSTheLoaiMonAn.rdlc";
LoaiMonDTO loaiMon = rptMonAnBUS.ReportLayMaLoaiMon(maLoaiMon);
rpvBaoCao.LocalReport.SetParameters(new ReportParameter("paLoaiMon", loaiMon.TenLoaiMon));
rpvBaoCao.LocalReport.DataSources.Add(new ReportDataSource("DSMonAn", lsMon));
rpvBaoCao.RefreshReport();
}
public List <LoaiMonDTO> LayDanhSachDanhMuc()
{
List <LoaiMonDTO> List = new List <LoaiMonDTO>();
string query = " select * from LOAIMON";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
LoaiMonDTO menu = new LoaiMonDTO(item);
List.Add(menu);
}
return(List);
}
public List <LoaiMonDTO> SearchListLoaiMon(string valueToSearch)
{
List <LoaiMonDTO> List = new List <LoaiMonDTO>();
string query = string.Format("SELECT * FROM dbo.LoaiMon WHERE CONCAT(MaLoaiMon, TenLoaiMon, GhiChu) LIKE N'%" + valueToSearch + "%'");
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
LoaiMonDTO loaiMon = new LoaiMonDTO(dataRow);
List.Add(loaiMon);
}
return(List);
}
public List <LoaiMonDTO> GetListLoaiMon()
{
List <LoaiMonDTO> List = new List <LoaiMonDTO>();
string query = "SELECT * FROM dbo.LoaiMon";
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
LoaiMonDTO loaiMon = new LoaiMonDTO(dataRow);
List.Add(loaiMon);
}
return(List);
}
public LoaiMonDTO LayDanhSachLoaiMonAnTheoID(int MALOAI)
{
LoaiMonDTO Loaimon = null;
string query = " select * from LOAIMON where MALOAI = " + MALOAI;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Loaimon = new LoaiMonDTO(item);
return(Loaimon);
}
return(Loaimon);
}
protected void ChiTietLoaiMon()
{
LoaiMonBUS loaimonBUS = new LoaiMonBUS();
LoaiMonDTO LoaiMonAn = loaimonBUS.ChiTietLoaiMon(int.Parse(Request["MaLoaiMon"].ToString()));
XL_THE Kq1 = new XL_THE("Loai_Mon_An");
Kq1.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("MaLoaiMon", LoaiMonAn.Ma_loai_mon.ToString()));
Kq1.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("TenLoaiMon", LoaiMonAn.Ten_loai_mon));
Kq1.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("MaLoaiMonCha", LoaiMonAn.Ma_loai_mon_cha.ToString()));
Kq1.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("LaLoaiMonLa", LoaiMonAn.La_loai_mon_la.ToString()));
XL_CHUOI.XuatXML(Response, Kq1.Chuoi());
}
private void QLM_LoadLoaiMon(string timKiem = "")
{
List <LoaiMonDTO> lsLoaiMon = LoaiMonBUS.LayDanhSachLoaiMon();
cmbLoaiMon.DataSource = lsLoaiMon;
cmbLoaiMon.DisplayMember = "TenLoaiMon";
cmbLoaiMon.ValueMember = "MaLoaiMon";
List <LoaiMonDTO> lsLM = LoaiMonBUS.LayDanhSachLoaiMon();
LoaiMonDTO lm = new LoaiMonDTO();
lm.MaLoaiMon = 0;
lm.TenLoaiMon = "Tất cả";
lsLM.Insert(0, lm);
cmbTimKiemTheoLoaiMon.DataSource = lsLM;
}
public static bool ThemLoaiMon(LoaiMonDTO loaiMon)
{
string query = "INSERT INTO tblLoaiMonAn ([MaLoaiMon],[TenLoaiMon],[TrangThai]) VALUES (@maLoaiMon,@tenLoaiMon,@TrangThai)";
SqlParameter[] parameter = new SqlParameter[3];
parameter[0] = new SqlParameter("@maloaiMon", loaiMon.MaLoaiMon);
parameter[1] = new SqlParameter("@tenLoaiMon", loaiMon.TenLoaiMon);
parameter[2] = new SqlParameter("@trangThai", true);
int result = DataProvider.ExecuteInsertQuery(query, parameter);
if (result > 0)
{
return(true);
}
return(false);
}
public static LoaiMonDTO ReportLayMaLoaiMon(string maLoaiMon)
{
LoaiMonDTO result = null;
string query = "select MaLoaiMon,TenLoaiMon from tblLoaiMonAn where MaLoaiMon = @MaLoaiMon";
SqlParameter[] pars = new SqlParameter[1];
pars[0] = new SqlParameter("@MaLoaiMon", maLoaiMon);
DataTable dt = DataProvider.ExecuteSelectQuery(query, pars);
foreach (DataRow dr in dt.Rows)
{
LoaiMonDTO rptMon = new LoaiMonDTO();
rptMon.MaLoaiMon = dr["MaLoaiMon"].ToString();
rptMon.TenLoaiMon = dr["TenLoaiMon"].ToString();
result = (rptMon);
}
return(result);
}
private void cbLoaiMon_SelectedIndexChanged(object sender, EventArgs e)
{
LoaiMonDTO LoaiMAselected = (LoaiMonDTO)cbLoaiMon.SelectedItem;
if (LoaiMAselected == null)
{
return;
}
lvShowFood.Items.Clear();
listMonAn = MonAnDAO.Instance.GetListFoodByMALOAI(LoaiMAselected.MALOAI);
foreach (MonAnDTO item in listMonAn)
{
ListViewItem itemLv = new ListViewItem(item.TENMA);
itemLv.SubItems.Add(item.DVT);
itemLv.SubItems.Add(item.DonGia.ToString());
lvShowFood.Items.Add(itemLv);
}
}
public static List <LoaiMonDTO> LayDanhSachLoaiMon(string timKiem, bool trangThai)
{
SqlConnection connection = DataProvider.GetConnection();
string query = "SELECT ma_loai_mon, ten_loai_mon, la_do_uong, trang_thai FROM LoaiMon WHERE 1=1";
SqlCommand command = new SqlCommand();
if (timKiem != "")
{
query += " AND ten_loai_mon LIKE N'%'+@timKiem+'%'";
command.Parameters.Add("@timKiem", System.Data.SqlDbType.NVarChar, 255).Value = timKiem;
}
if (trangThai)
{
query += " AND trang_thai=1";
}
else
{
query += " AND trang_thai=0";
}
command.CommandText = query;
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <LoaiMonDTO> result = new List <LoaiMonDTO>();
if (reader.HasRows)
{
while (reader.Read())
{
LoaiMonDTO loaiMon = new LoaiMonDTO();
loaiMon.MaLoaiMon = reader.GetInt32(0);
loaiMon.TenLoaiMon = reader.GetString(1);
loaiMon.LaDoUong = reader.GetBoolean(2);
loaiMon.TrangThai = reader.GetBoolean(3);
result.Add(loaiMon);
}
}
connection.Close();
return(result);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
LoaiMonDTO loaimon = new LoaiMonDTO();
loaimon.Ma_loai_mon = (int)dt.Rows[i]["MaLoaiMon"];
loaimon.Ten_loai_mon = dt.Rows[i]["TenLoaiMon"].ToString();
if (dt.Rows[i]["MaLoaiMonCha"].ToString() == "") //neu la loai mon goc, ko co cha
{
loaimon.Ma_loai_mon_cha = -1;
}
else
{
loaimon.Ma_loai_mon_cha = (int)dt.Rows[i]["MaLoaiMonCha"];
}
loaimon.La_loai_mon_la = (bool)dt.Rows[i]["LaLoaiMonLa"];
return((object)loaimon);
}
public static bool ThemLoaiMon(LoaiMonDTO loaiMon)
{
SqlConnection connection = DataProvider.GetConnection();
string query = "INSERT INTO LoaiMon (ten_loai_mon, la_do_uong, trang_thai) VALUES (@tenLoaiMon, @laDoUong, @trangThai)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Add("@tenLoaiMon", System.Data.SqlDbType.NVarChar, 255).Value = loaiMon.TenLoaiMon;
command.Parameters.Add("@laDoUong", System.Data.SqlDbType.Bit, 0).Value = loaiMon.LaDoUong;
command.Parameters.Add("@trangThai", System.Data.SqlDbType.Bit, 0).Value = loaiMon.TrangThai;
connection.Open();
int reader = command.ExecuteNonQuery();
connection.Close();
if (reader > 0)
{
return(true);
}
return(false);
}
private void btnKhoiPhuc_Click(object sender, EventArgs e)
{
if (chkLoaiMAConSuDung.Checked == true)
{
LoaiMonDTO loaiMon = new LoaiMonDTO();
loaiMon.MaLoaiMon = txtMaLoaiMon.Text;
loaiMon.TenLoaiMon = txtTenLoaiMon.Text;
loaiMon.TrangThai = true;
if (LoaiMonBUS.SuaLoaiMon(loaiMon))
{
//MessageBox.Show("Khôi phục loại món ăn thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.None);
LamMoi();
LoadDSLoaiMon();
}
else
{
MessageBox.Show("Khôi phục loại món ăn thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
loaiMon = null;
}
}
}
private void btnSuaLoaiMon_Click(object sender, EventArgs e)
{
LoaiMonDTO loaiMon = new LoaiMonDTO();
loaiMon.MaLoaiMon = Convert.ToInt32(txtMaLoaiMon.Text);
loaiMon.TenLoaiMon = txtTenLoaiMon.Text;
loaiMon.LaDoUong = chkDoUong.Checked;
loaiMon.TrangThai = true;
if (LoaiMonBUS.SuaLoaiMon(loaiMon, LayDanhSachCheckBoxLoaiTopping(false)))
{
MessageBox.Show("Sửa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LamMoiLoaiMon();
QLLM_LoadDanhSachLoaiMon();
dgvLoaiMon.ClearSelection();
}
else
{
MessageBox.Show("Sửa thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
loaiMon = null;
}
}
public static List <LoaiMonDTO> LayDanhSachLoaiMon(string timKiem, bool trangThai)
{
List <LoaiMonDTO> result = new List <LoaiMonDTO>();
string query = "select MaLoaiMon,TenLoaiMon,TrangThai from tblLoaiMonAn Where 1 = 1";
SqlParameter[] parameter;
if (timKiem != "")
{
query += " AND TenLoaiMon LIKE N'%'+@timKiem+'%'";
parameter = new SqlParameter[1];
parameter[0] = new SqlParameter("@timKiem", timKiem);
}
else
{
parameter = new SqlParameter[0];
}
if (trangThai)
{
query += " AND TrangThai = 1";
}
else
{
query += " AND TrangThai = 0";
}
DataTable dtb = DataProvider.ExecuteSelectQuery(query, parameter);
foreach (DataRow r in dtb.Rows)
{
LoaiMonDTO loaiMon = new LoaiMonDTO();
loaiMon.MaLoaiMon = r["MaLoaiMon"].ToString();
loaiMon.TenLoaiMon = r["TenLoaiMon"].ToString();
loaiMon.TrangThai = Convert.ToBoolean(r["TrangThai"]);
result.Add(loaiMon);
}
return(result);
}
public static bool SuaLoaiMon(LoaiMonDTO loaiMon)
{
SqlConnection connection = DataProvider.GetConnection();
string query = "UPDATE LoaiMon SET ten_loai_mon=@tenLoaiMon, la_do_uong=@laDoUong, trang_thai=@trangThai WHERE ma_loai_mon=@maLoaiMon";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Add("@maLoaiMon", System.Data.SqlDbType.Int, 0).Value = loaiMon.MaLoaiMon;
command.Parameters.Add("@tenLoaiMon", System.Data.SqlDbType.NVarChar, 255).Value = loaiMon.TenLoaiMon;
command.Parameters.Add("@laDoUong", System.Data.SqlDbType.Bit, 0).Value = loaiMon.LaDoUong;
command.Parameters.Add("@trangThai", System.Data.SqlDbType.Bit, 0).Value = loaiMon.TrangThai;
connection.Open();
int reader = command.ExecuteNonQuery();
connection.Close();
if (reader > 0)
{
return(true);
}
return(false);
}
