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