private void pictureBox1_Click(object sender, EventArgs e)
{
if (tbxTenSP.Text == "" || tbxMaSP.Text == "")
{
MessageBox.Show("Vui lòng nhập dữ liệu!");
return;
}
Menu_DTO Menu_DTO = new Menu_DTO();
Menu_DTO.MaSP = tbxMaSP.Text;
Menu_DTO.TenSP = tbxTenSP.Text;
Menu_DTO.LoaiSP = tbxLoaiSP.Text;
Menu_DTO.DVT = tbxDVT.Text;
Menu_DTO.DonGia = Int32.Parse(tbxDG.Text);
if (Menu_BUS.Them_Menu_1(Menu_DTO) == true)
{
MessageBox.Show("Thêm Thành Công!");
}
else
{
MessageBox.Show("Thêm Thất Bại!");
}
tbxMaSP.Text = "";
tbxTenSP.Text = "";
tbxLoaiSP.Text = "";
tbxDVT.Text = "";
tbxDG.Text = "";
checkBox1.Checked = false;
tbxMaSP.Enabled = false;
LoadMenu1();
LoadMenu2();
LoadMenu3();
}
private void btDelete_Click(object sender, EventArgs e)
{
ResultMessage_DTO result;
if (tbMaMon.Text == "")
{
MessageBox.Show("Vui lòng nhập dữ liệu!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Menu_DTO Menu_DTO = new Menu_DTO();
Menu_DTO.MaMon = tbMaMon.Text;
Menu_DTO.TenMon = tbTenMon.Text;
Menu_DTO.Loai = tbLoai.Text;
Menu_DTO.DonGia = Int32.Parse(tbDonGia.Text);
Menu_DTO.DVT = tbDVT.Text;
result = BUS.Delete_Menu(Menu_DTO);
if (result.ResultCode_Menu == "1")
{
MessageBox.Show(result.ResultMessage_Menu, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(result.ResultMessage_Menu, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load();
Clear();
}
public static List <Menu_DTO> GetListMenu()
{
try
{
List <Menu_DTO> Danhsach = new List <Menu_DTO>();
Menu_DTO Menu;
con.Open();
SqlCommand cmd = new SqlCommand("exec proc_GetListMenu", con);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
Menu = new Menu_DTO();
Menu.MaMon = reader["MaMon"].ToString();
Menu.TenMon = reader["TenMon"].ToString();
Menu.Loai = reader["Loai"].ToString();
Menu.DonGia = Int32.Parse(reader["DonGia"].ToString());
Menu.DVT = reader["DVT"].ToString();
Danhsach.Add(Menu);
}
reader.Close();
cmd.Dispose();
return(Danhsach);
}
catch (Exception ex)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public static bool EditMenu(Menu_DTO m)
{
string query = string.Format(@"update MENU set name=N'{0}',id_Kind={1},unit_Price={2}, sale_Price = {3} ,amout={4}, where Id_nenu={5}", m.Name, m.Kind, m.Original_price, m.Sale_price, m.Amout, m.Id);
con = DataProvider.OpenConnection();
bool kq = DataProvider.ExcuteNonQuery(query, con);
//DataProvider.DongKetNoi(con);
return(kq);
}
public static bool AddMenu(Menu_DTO m)
{
string query = string.Format(@"insert into MENU values(N'{0}', {1}, {2},{3},{4})", m.Name, m.Kind, m.Original_price, m.Sale_price, m.Amout);
con = DataProvider.OpenConnection();
bool kq = DataProvider.ExcuteNonQuery(query, con);
//DataProvider.DongKetNoi(con);
return(kq);
}
public ResultMessage_DTO Delete_Menu(Menu_DTO Menu_DTO)
{
try
{
Menu_DAO Menu_DAO = new Menu_DAO();
return(Menu_DAO.Delete_Menu(Menu_DTO));
}
catch
{
throw;
}
}
public List <Menu_DTO> getmenu(int maban)
{
List <Menu_DTO> list = new List <Menu_DTO>();
DataTable tb = DBconection.Instrance.ExecuteQuery("EXEC usp_getmenu5 @maban ", new object[] { maban });
foreach (DataRow row in tb.Rows)
{
Menu_DTO menu = new Menu_DTO(row);
list.Add(menu);
}
return(list);
}
private void tbSearch_TextChanged(object sender, EventArgs e)
{
Menu_DTO Menu = new Menu_DTO();
Menu.MaMon = tbSearch.Text;
List <Menu_DTO> Search = Menu_BUS.Search_Menu(Menu);
dataGridView1.DataSource = Search;
if (tbSearch.Text == "")
{
Load();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
Menu_DTO Searching = new Menu_DTO();
Searching.TenSP = tbxSearch.Text;
List <Menu_DTO> List_1 = Menu_BUS.Search_1(Searching);
dataGridView1.DataSource = List_1;
List <Menu_DTO> List_2 = Menu_BUS.Search_2(Searching);
dataGridView2.DataSource = List_2;
List <Menu_DTO> List_3 = Menu_BUS.Search_3(Searching);
dataGridView3.DataSource = List_3;
}
private void btNew_Click(object sender, EventArgs e)
{
List <Menu_DTO> DanhSachMenu = BUS.GetListMenu();
if (ckMaMon.Checked == false)
{
MessageBox.Show("Vui lòng check vào trong ô gần MaMon để thêm mới Menu!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
if (tbMaMon.Text == "")
{
MessageBox.Show("Vui lòng nhập dữ liệu!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
Menu_DTO Menu_DTO = new Menu_DTO();
Menu_DTO.MaMon = tbMaMon.Text;
Menu_DTO.TenMon = tbTenMon.Text;
Menu_DTO.Loai = tbLoai.Text;
Menu_DTO.DonGia = Int32.Parse(tbDonGia.Text);
Menu_DTO.DVT = tbDVT.Text;
for (int i = 0; i < DanhSachMenu.Count; i++)
{
if (DanhSachMenu[i].TenMon == Menu_DTO.TenMon &&
DanhSachMenu[i].Loai == Menu_DTO.Loai &&
DanhSachMenu[i].DonGia == Menu_DTO.DonGia &&
DanhSachMenu[i].DVT == Menu_DTO.DVT
)
{
MessageBox.Show("Dữ liệu đã tồn tại! Vui lòng thay đổi lại để thêm mới!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
if (Menu_BUS.New_Nenu(Menu_DTO) == true)
{
MessageBox.Show("Thêm Thành Công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Món Ăn đã tồn tại!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load();
Clear();
}
public static Results Sua_Menu_1(Menu_DTO Menu_DTO)
{
//try
//{
// string sQuery2 = string.Format("Update MENU set Ten_SP = N'{0}', Loai_SP =N'{1}', DVT = N'{2}', Don_Gia = {3} where Ma_SP = '{4}'", Menu_DTO.TenSP, Menu_DTO.LoaiSP, Menu_DTO.DVT, Menu_DTO.DonGia, Menu_DTO.MaSP);
// sprovider = new Provider();
// var u = sprovider.ExcuteData(sQuery2);
// return true;
// conn.Close();
//}
//catch (Exception Ex)
//{
// return false;
// throw Ex;
//}
Results re = new Results();
try
{
//string sQuery = string.Format("exec proc_UpdateNV @TenNV=N'{0}',@GT='{1}',@DiaChi=N'{2}',@SDT='{3}',@Email='{4}',@Ngay_Sinh ='{5}',@Chuc_Vu=N'{6}',@NVL='{7}',@Luong={8},@MaNV='{9}'", nv.TenNV, nv.GioiTinh, nv.DiaChi, nv.SDT, nv.Email, nv.NgaySinh, nv.ChucVu, nv.NgayVaoLam, nv.Luong, nv.MaNV);
conn = Provider.Connect();
SqlCommand cmd = new SqlCommand("proc_UpdateMENU", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ma_SP", Menu_DTO.MaSP);
cmd.Parameters.AddWithValue("@Ten_SP", Menu_DTO.TenSP);
cmd.Parameters.AddWithValue("@Loai_SP", Menu_DTO.LoaiSP);
cmd.Parameters.AddWithValue("@DVT", Menu_DTO.DVT);
cmd.Parameters.AddWithValue("@Don_Gia", Menu_DTO.DonGia);
cmd.Parameters.AddWithValue("@resutsID", re.ResultID);
cmd.Parameters.AddWithValue("@Message", re.Message);
cmd.Parameters["@resutsID"].Direction = ParameterDirection.Output;
cmd.Parameters["@Message"].Direction = ParameterDirection.Output;
cmd.Parameters["@Message"].Size = 50;
conn.Open();
var u = cmd.ExecuteNonQuery();
re.ResultID = int.Parse(cmd.Parameters["@resutsID"].Value.ToString());
re.Message = cmd.Parameters["@Message"].Value.ToString();
}
catch (Exception ex)
{
re.ResultID = -1;
re.Message = ex.Message;
}
return(re);
}
private void btUpdate_Click(object sender, EventArgs e)
{
List <Menu_DTO> DanhSachMenu = BUS.GetListMenu();
ResultMessage_DTO result;
if (tbMaMon.Text == "")
{
MessageBox.Show("Vui lòng nhập dữ liệu!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Menu_DTO Menu_DTO = new Menu_DTO();
Menu_DTO.MaMon = tbMaMon.Text;
Menu_DTO.TenMon = tbTenMon.Text;
Menu_DTO.Loai = tbLoai.Text;
Menu_DTO.DonGia = Int32.Parse(tbDonGia.Text);
Menu_DTO.DVT = tbDVT.Text;
for (int i = 0; i < DanhSachMenu.Count; i++)
{
if (DanhSachMenu[i].MaMon == Menu_DTO.MaMon &&
DanhSachMenu[i].TenMon == Menu_DTO.TenMon &&
DanhSachMenu[i].Loai == Menu_DTO.Loai &&
DanhSachMenu[i].DonGia == Menu_DTO.DonGia &&
DanhSachMenu[i].DVT == Menu_DTO.DVT
)
{
MessageBox.Show("Bạn chưa thay đổi dữ liệu cũ! Vui lòng thay đổi dữ liệu mới trước khi Update!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
result = BUS.Update_Menu(Menu_DTO);
if (result.ResultCode_Menu == "1")
{
MessageBox.Show(result.ResultMessage_Menu, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(result.ResultMessage_Menu, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load();
Clear();
}
public static List <Menu_DTO> List_All()
{
string sQuery = "Select * From MENU ";
sprovider = new Provider();
DataTable dt = sprovider.GetData(sQuery);
List <Menu_DTO> Menu_DTO = new List <DTO.Menu_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Menu_DTO Me = new Menu_DTO();
Me.MaSP = dt.Rows[i]["Ma_SP"].ToString();
Me.TenSP = dt.Rows[i]["Ten_SP"].ToString();
Me.LoaiSP = dt.Rows[i]["Loai_SP"].ToString();
Me.DVT = dt.Rows[i]["DVT"].ToString();
Me.DonGia = Int32.Parse(dt.Rows[i]["Don_Gia"].ToString());
Menu_DTO.Add(Me);
}
return(Menu_DTO);
}
public static List <Menu_DTO> ListSearch_3(Menu_DTO Searching)
{
string sQuery = string.Format("Select * From MENU where Loai_SP like N'Dịch Vụ' and Ten_SP like N'%{0}%'", Searching.TenSP);
sprovider = new Provider();
DataTable dt = sprovider.GetData(sQuery);
List <Menu_DTO> Menu_DTO = new List <DTO.Menu_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Menu_DTO Me = new Menu_DTO();
Me.MaSP = dt.Rows[i]["Ma_SP"].ToString();
Me.TenSP = dt.Rows[i]["Ten_SP"].ToString();
Me.LoaiSP = dt.Rows[i]["Loai_SP"].ToString();
Me.DVT = dt.Rows[i]["DVT"].ToString();
Me.DonGia = Int32.Parse(dt.Rows[i]["Don_Gia"].ToString());
Menu_DTO.Add(Me);
}
return(Menu_DTO);
}
private void pictureBox2_Click(object sender, EventArgs e)
{
if (tbxTenSP.Text == "" || tbxMaSP.Text == "")
{
MessageBox.Show("Vui lòng nhập dữ liệu!");
return;
}
Results rs = new Results();
Menu_DTO Menu_DTO = new Menu_DTO();
Menu_DTO.MaSP = tbxMaSP.Text;
Menu_DTO.TenSP = tbxTenSP.Text;
Menu_DTO.LoaiSP = tbxLoaiSP.Text;
Menu_DTO.DVT = tbxDVT.Text;
Menu_DTO.DonGia = Int32.Parse(tbxDG.Text);
rs = Menu_BUS.Sua_Menu_1(Menu_DTO);
if (rs.ResultID > 0)
{
MessageBox.Show(rs.Message);
}
else
{
MessageBox.Show(rs.Message);
}
//if (Menu_BUS.Sua_Menu_1(Menu_DTO) == true)
//{
// MessageBox.Show("Sua Thành Công!");
//}
//else
//{
// MessageBox.Show("Sua Thất Bại!");
//}
tbxMaSP.Text = "";
tbxTenSP.Text = "";
tbxLoaiSP.Text = "";
tbxDVT.Text = "";
tbxDG.Text = "";
LoadMenu1();
LoadMenu2();
LoadMenu3();
}
public static Results Xoa_Menu_1(Menu_DTO Menu_DTO)
{
Results re = new Results();
try
{
conn = Provider.Connect();
SqlCommand cmd = new SqlCommand("proc_XoaMENU", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@psMaSP", Menu_DTO.MaSP);
cmd.Parameters.AddWithValue("@pResultCode", re.ResultID);
cmd.Parameters.AddWithValue("@pResultMessage", re.Message);
cmd.Parameters["@pResultCode"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage"].Size = 50;
conn.Open();
var u = cmd.ExecuteNonQuery();
re.ResultID = int.Parse(cmd.Parameters["@pResultCode"].Value.ToString());
re.Message = cmd.Parameters["@pResultMessage"].Value.ToString();
}
catch (Exception ex)
{
re.ResultID = -1;
re.Message = ex.Message;
}
return(re);
//try
//{
// string sQuery2 = string.Format("Delete From MENU where Ma_SP = '{0}'", Menu_DTO.MaSP);
// sprovider = new Provider();
// var u = sprovider.ExcuteData(sQuery2);
// return true;
// conn.Close();
//}
//catch (Exception Ex)
//{
// return false;
// throw Ex;
//}
}
public static bool Them_Menu_1(Menu_DTO Menu_DTO)
{
try
{
//string sQuery2 = "Insert into MENU(Ma_SP,Ten_SP,Loai_SP,DVT,Don_Gia) values(@Ma_SP,Ten_SP,Loai_SP,@DVT,@DG)";
//SqlCommand cmd = conn.CreateCommand();
//cmd.CommandText = sQuery2;
//SqlParameter MASP = new SqlParameter("@Ma_SP", SqlDbType.Char);
//MASP.Value = Menu_DTO.MaSP;
//cmd.Parameters.Add(MASP);
//SqlParameter TENSP = new SqlParameter("@Ten_SP", SqlDbType.NVarChar);
//TENSP.Value = Menu_DTO.TenSP;
//cmd.Parameters.Add(TENSP);
//SqlParameter LOAI = new SqlParameter("@Loai_SP", SqlDbType.NVarChar);
//LOAI.Value = Menu_DTO.LoaiSP;
//cmd.Parameters.Add(LOAI);
//SqlParameter DVT = new SqlParameter("@DVT", SqlDbType.NVarChar);
//DVT.Value = Menu_DTO.LoaiSP;
//cmd.Parameters.Add(DVT);
//SqlParameter DG = new SqlParameter("@DG", SqlDbType.Int);
//DG.Value = Menu_DTO.DonGia;
//cmd.Parameters.Add(DG);
//int count = cmd.ExecuteNonQuery();
string sQuery2 = string.Format("Insert into MENU(Ma_SP,Ten_SP,Loai_SP,DVT,Don_Gia) Values('{0}',N'{1}',N'{2}',N'{3}',{4})", Menu_DTO.MaSP, Menu_DTO.TenSP, Menu_DTO.LoaiSP, Menu_DTO.DVT, Menu_DTO.DonGia);
Provider provider = new Provider();
var u = provider.ExcuteData(sQuery2);
return(true);
conn.Close();
}
catch (Exception Ex)
{
return(false);
}
}
public static List <Menu_DTO> Search_Menu(Menu_DTO Menu_DTO)
{
List <Menu_DTO> Danhsach = new List <Menu_DTO>();
Menu_DTO Menu;
try
{
con.Open();
SqlCommand cmd = new SqlCommand("proc_SearchMenu", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SearchMenu", "%" + Menu_DTO.MaMon + "%");
var reader = cmd.ExecuteReader();
while (reader.Read())
{
Menu = new Menu_DTO();
Menu.MaMon = reader["MaMon"].ToString();
Menu.TenMon = reader["TenMon"].ToString();
Menu.Loai = reader["Loai"].ToString();
Menu.DonGia = Int32.Parse(reader["DonGia"].ToString());
Menu.DVT = reader["DVT"].ToString();
Danhsach.Add(Menu);
}
reader.Close();
cmd.Dispose();
}
catch
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(Danhsach);
}
public ResultMessage_DTO Update_Menu(Menu_DTO Menu_DTO)
{
ResultMessage_DTO result = new ResultMessage_DTO();
try
{
SqlCommand cmd = new SqlCommand("proc_UpdateMenu", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaMon", Menu_DTO.MaMon);
cmd.Parameters.AddWithValue("@TenMon", Menu_DTO.TenMon);
cmd.Parameters.AddWithValue("@Loai", Menu_DTO.Loai);
cmd.Parameters.AddWithValue("@DonGia", Menu_DTO.DonGia);
cmd.Parameters.AddWithValue("@DVT", Menu_DTO.DVT);
cmd.Parameters.AddWithValue("@pResultCode_Menu", result.ResultCode_Menu);
cmd.Parameters.AddWithValue("@pResultMessage_Menu", result.ResultMessage_Menu);
cmd.Parameters["@pResultCode_Menu"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_Menu"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_Menu"].Size = 200;
con.Open();
cmd.ExecuteNonQuery();
result.ResultCode_Menu = cmd.Parameters["@pResultCode_Menu"].Value.ToString();
result.ResultMessage_Menu = cmd.Parameters["@pResultMessage_Menu"].Value.ToString();
cmd.Dispose();
}
catch (Exception ex)
{
result.ResultCode_Menu = "";
result.ResultMessage_Menu = ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
public static bool New_Nenu(Menu_DTO Menu_DTO)
{
try
{
con.Open();
string New = string.Format("exec proc_NewMenu @MaMon='{0}',@TenMon=N'{1}',@Loai=N'{2}',@DonGia={3},@DVT=N'{4}'", Menu_DTO.MaMon, Menu_DTO.TenMon, Menu_DTO.Loai, Menu_DTO.DonGia, Menu_DTO.DVT);
SqlCommand cmd = new SqlCommand(New, con);
int i = cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
throw ex;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public static List <Menu_DTO> Search_3(Menu_DTO Searching)
{
return(Menu_DAO.ListSearch_3(Searching));
}
public static List <Menu_DTO> Search_Menu(Menu_DTO Menu_DTO)
{
Menu_DAO Menu_DAO = new Menu_DAO();
return(Menu_DAO.Search_Menu(Menu_DTO));
}
public static bool Them_Menu_1(Menu_DTO Menu_DTO)
{
return(Menu_DAO.Them_Menu_1(Menu_DTO));
}
public static bool New_Nenu(Menu_DTO Menu_DTO)
{
return(Menu_DAO.New_Nenu(Menu_DTO));
}
public static Results Sua_Menu_1(Menu_DTO Menu_DTO)
{
return(Menu_DAO.Sua_Menu_1(Menu_DTO));
}
public static Results Xoa_Menu_1(Menu_DTO Menu_DTO)
{
return(Menu_DAO.Xoa_Menu_1(Menu_DTO));
}
