private void gABXoa_Click(object sender, EventArgs e) { if (drvNL == null) { MessageBox.Show("Chọn món ăn muốn xóa"); return; } NguyenLieu_DTO nguyenLieu = new NguyenLieu_DTO(); nguyenLieu.TenNL = txtTenNL.Text; nguyenLieu.Donvi = txtDonVi.Text; nguyenLieu.Soluong = int.Parse(txtSoLuong.Text); if (MessageBox.Show("Bạn có chắc chắn muốn xóa", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { if (dsnguyenlieu == null) { dtgrvDanhSachNL.DataSource = null; } if (NguyenLieu_BUS.XoaNguyenLieu(nguyenLieu)) { drvNL = null; txtTenNL.Text = ""; txtDonVi.Text = ""; txtSoLuong.Text = ""; LoadNguyenLieu(); MessageBox.Show("Xóa thành công"); return; } MessageBox.Show("Xóa thất bại"); } }
public void LayTTnguyenLieu(int a) { NguyenLieu_DTO nl = NguyenLieu_BUS.LayTTNguyenLieu(a); txtTenNL.Text = nl.TenNL; txtDonVi.Text = nl.Donvi; }
private void gABCapNhat_Click(object sender, EventArgs e) { if (drvNL == null) { MessageBox.Show("Chọn Món Ăn Muốn Sửa"); return; } NguyenLieu_DTO nguyenLieu = new NguyenLieu_DTO(); nguyenLieu.MaNL = int.Parse(drvNL.Cells["MaNL"].Value.ToString()); nguyenLieu.TenNL = txtTenNL.Text; nguyenLieu.Donvi = txtDonVi.Text; nguyenLieu.Soluong = int.Parse(txtSoLuong.Text); if (NguyenLieu_BUS.SuaNguyenLieu(nguyenLieu)) { drvNL = null; txtTenNL.Text = ""; txtDonVi.Text = ""; txtSoLuong.Text = ""; LoadNguyenLieu(); MessageBox.Show("Sửa thành công"); return; } MessageBox.Show("Sửa thất bại"); }
// ---------------- tìm kiếm nguyên liệu --------------------------- public static List <NguyenLieu_DTO> TimNguyenLieu(string tenNguyenLieu) { string QueryString = string.Format("select * from NguyenLieu where TenNL like '%" + tenNguyenLieu + "%'"); conn = DataProvider.OpenConnection(); DataTable dt = DataProvider.LayDataTable(QueryString, conn); if (dt.Rows.Count == 0) { return(null); } List <NguyenLieu_DTO> lstNguyenLieu = new List <NguyenLieu_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { NguyenLieu_DTO nguyenlieu = new NguyenLieu_DTO(); nguyenlieu.MaNL = int.Parse(dt.Rows[i]["MaNL"].ToString()); nguyenlieu.TenNL = dt.Rows[i]["TenNL"].ToString(); nguyenlieu.Donvi = dt.Rows[i]["DonVi"].ToString(); nguyenlieu.Soluong = int.Parse(dt.Rows[i]["SoLuong"].ToString()); lstNguyenLieu.Add(nguyenlieu); } DataProvider.CloseConnection(conn); return(lstNguyenLieu); }
public static List <NguyenLieu_DTO> LoadNguyenLieu() { string chuoiTruyVan = "Select * From NguyenLieu "; conn = DataProvider.OpenConnection(); DataTable dt = DataProvider.LayDataTable(chuoiTruyVan, conn); if (dt.Rows.Count == 0) { return(null); } List <NguyenLieu_DTO> lstNguyenLieu = new List <NguyenLieu_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { NguyenLieu_DTO nguyenlieu = new NguyenLieu_DTO(); nguyenlieu.MaNL = int.Parse(dt.Rows[i]["MaNL"].ToString()); nguyenlieu.TenNL = dt.Rows[i]["TenNL"].ToString(); nguyenlieu.Donvi = dt.Rows[i]["DonVi"].ToString(); nguyenlieu.Soluong = int.Parse(dt.Rows[i]["SoLuong"].ToString()); lstNguyenLieu.Add(nguyenlieu); } DataProvider.CloseConnection(conn); return(lstNguyenLieu); }
public List <NguyenLieu_DTO> TimTheoMa(string manl) { List <NguyenLieu_DTO> listNL = new List <NguyenLieu_DTO>(); #region Tạo Kết Nối SqlConnection con = DataProvider.TaoKetNoi(); #endregion if (con != null) { #region Tạo đối tượng truy vấn SqlCommand command = new SqlCommand(); command.CommandText = @"select * from NguyenLieu where TrangThai = 1 and MaNL = " + manl + ""; command.Connection = con; SqlDataReader dataReader = command.ExecuteReader(); #endregion while (dataReader.Read()) { NguyenLieu_DTO nl = new NguyenLieu_DTO(); nl.MaNL = (int)dataReader[0]; nl.TenNguyenLieu = dataReader["TenNguyenLieu"].ToString(); nl.DonViTinh = dataReader["DonViTinh"].ToString(); nl.DonGiaNL = (decimal)dataReader["DonGiaNL"]; listNL.Add(nl); } #region đóng kết nối dataReader.Close(); con.Close(); #endregion } return(listNL); }
private void btDelete_Click(object sender, EventArgs e) { if (tbMaNL.Text == "") { MessageBox.Show("Vui lòng chọn Nguyên Liệu để xóa!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } NguyenLieu_DTO NL = new NguyenLieu_DTO(); NL.MaNL = tbMaNL.Text; NL.TenNL = tbTenNL.Text; NL.SoLuongNhap = Int32.Parse(tbSoLuong.Text); NL.DVT = cbDVT.Text; result = NguyenLieu_BUS.Delete_NL(NL); if (result.ResultCode_NL == 1) { MessageBox.Show(result.ResultMessage_NL, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(result.ResultMessage_NL, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } Clear(); Load(); }
private void dataGridViewQLNguyenLieu_CellClick(object sender, DataGridViewCellEventArgs e) { if (dataGridViewQLNguyenLieu.SelectedRows.Count > 0) { NguyenLieu_DTO nl = (NguyenLieu_DTO)dataGridViewQLNguyenLieu.SelectedRows[0].DataBoundItem; txtMaNLKho.Text = nl.MaNL.ToString(); txtTenNLKho.Text = nl.TenNguyenLieu.ToString(); txtDonViTinhKho.Text = nl.DonViTinh.ToString(); txtDonGiaNL.Text = nl.DonGiaNL.ToString(); } }
private void tbSearch_TextChanged(object sender, EventArgs e) { NguyenLieu_DTO NL = new NguyenLieu_DTO(); NL.MaNL = tbSearch.Text; List <NguyenLieu_DTO> Search = NguyenLieu_BUS.Search_NL(NL); dataGridView1.DataSource = Search; if (tbSearch.Text == "") { Load(); } }
public void ThemNguyenLieu(NguyenLieu_DTO nl, int TrangThai) { SqlConnection con = DataProvider.TaoKetNoi(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = string.Format("insert into NguyenLieu(TenNguyenLieu, DonViTinh, DonGiaNL, TrangThai) values(N'{0}' ,N'{1}','{2}','{3}')" , nl.TenNguyenLieu, nl.DonViTinh, nl.DonGiaNL, TrangThai); cmd.Connection = con; cmd.ExecuteNonQuery(); DataProvider.NgatKetNoi(con); }
public void XoaNguyenLieu(NguyenLieu_DTO nl) { SqlConnection con = DataProvider.TaoKetNoi(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = @"UPDATE NguyenLieu SET TrangThai = 0 WHERE MaNL = @MaNL"; cmd.Parameters.AddWithValue(@"MaNL", nl.MaNL); cmd.Connection = con; cmd.ExecuteNonQuery(); con.Close(); }
public static NguyenLieu_DTO LayTTNguyenLieu(int ID) { NguyenLieu_DTO nl = new NguyenLieu_DTO(); string QueryString = "Select TenNL,DonVi,SoLuong From NguyenLieu Where MaNL= " + ID; conn = DataProvider.OpenConnection(); DataTable dt = DataProvider.LayDataTable(QueryString, conn); nl.TenNL = dt.Rows[0]["TenNL"].ToString(); nl.Donvi = dt.Rows[0]["DonVi"].ToString(); nl.Soluong = int.Parse(dt.Rows[0]["SoLuong"].ToString()); DataProvider.CloseConnection(conn); return(nl); }
private void btnXoaNL_Click(object sender, EventArgs e) { if (dataGridViewQLNguyenLieu.SelectedRows.Count > 0) { NguyenLieu_DTO nl = (NguyenLieu_DTO)dataGridViewQLNguyenLieu.SelectedRows[0].DataBoundItem; if (MessageBox.Show("Bạn có chắc muốn xóa sản phẩm " + nl.MaNL + " không?", "Cảnh báo", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { NguyenLieu_BUS nl1 = new NguyenLieu_BUS(); nl1.XoaNguyenLieu(nl); MessageBox.Show("Đã xóa thành công sản phẩm"); LoadDSNL(); ResetNL(); } } }
private void btNew_Click(object sender, EventArgs e) { List <NguyenLieu_DTO> DanhSachNL = NguyenLieu_BUS.GetListNL(); if (ckMaNL.Checked == false) { MessageBox.Show("Vui lòng check vào trong ô gần MaNL để thêm mới Nguyên Liệu!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { if (tbMaNL.Text == "") { MessageBox.Show("Vui lòng nhập dữ liệu để thêm Nguyên Liệu!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } NguyenLieu_DTO NL = new NguyenLieu_DTO(); NL.MaNL = tbMaNL.Text; NL.TenNL = tbTenNL.Text; NL.SoLuongNhap = Int32.Parse(tbSoLuong.Text); NL.DVT = cbDVT.Text; for (int i = 0; i < DanhSachNL.Count; i++) { if (//DanhSachNL[i].MaNL == NL.MaNL&& DanhSachNL[i].TenNL == NL.TenNL && DanhSachNL[i].SoLuongNhap == NL.SoLuongNhap && DanhSachNL[i].DVT == NL.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 (NguyenLieu_BUS.New_NL(NL) == true) { MessageBox.Show("Thêm thành công !", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Nguyên Liệu đã tồn tại!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } Clear(); Load(); }
private void btnSuaNL_Click(object sender, EventArgs e) { if (dataGridViewQLNguyenLieu.SelectedRows.Count > 0) { NguyenLieu_DTO nl = (NguyenLieu_DTO)dataGridViewQLNguyenLieu.SelectedRows[0].DataBoundItem; nl.TenNguyenLieu = txtTenNguyenLieu.Text; nl.DonViTinh = txtDonViTinh.Text; nl.DonGiaNL = decimal.Parse(txtDonGiaNguyenLieu.Text); NguyenLieu_BUS dtBus = new NguyenLieu_BUS(); dtBus.SuaThongTinNguyenLieu(nl); MessageBox.Show("Đã Sữa 1 Nguyên Liệu "); LoadDSNL(); ResetNL(); } }
// sửa nguyên liệu public static bool SuaNguyenLieu(NguyenLieu_DTO nguyenlieu) { string QueryString = string.Format("update NguyenLieu set TenNL = '{0}',DonVi='{1}',SoLuong='{2}' where MaNL = '{3}'", nguyenlieu.TenNL, nguyenlieu.Donvi, nguyenlieu.Soluong, nguyenlieu.MaNL); conn = DataProvider.OpenConnection(); try { DataProvider.ThucThiTruyVanNonQuery(QueryString, conn); DataProvider.CloseConnection(conn); return(true); } catch (Exception) { DataProvider.CloseConnection(conn); return(false); } }
// ------------------------ thêm nguyên liệu ----------------------- public static bool ThemNguyenLieu(NguyenLieu_DTO nguyenlieu) { string QueryString = string.Format("insert into NguyenLieu(TenNL,DonVi,SoLuong) values('{0}','{1}','{2}')", nguyenlieu.TenNL, nguyenlieu.Donvi, nguyenlieu.Soluong); conn = DataProvider.OpenConnection(); try { DataProvider.ThucThiTruyVanNonQuery(QueryString, conn); DataProvider.CloseConnection(conn); return(true); } catch (Exception) { DataProvider.CloseConnection(conn); return(false); } }
// xóa nguyên liệu public static bool XoaNguyenLieu(NguyenLieu_DTO nguyenlieu) { string QueryString = string.Format("Delete from NguyenLieu Where TenNL = '{0}'", nguyenlieu.TenNL); conn = DataProvider.OpenConnection(); try { DataProvider.ThucThiTruyVanNonQuery(QueryString, conn); DataProvider.CloseConnection(conn); return(true); } catch (Exception) { DataProvider.CloseConnection(conn); return(false); } }
private void btUpdate_Click(object sender, EventArgs e) { List <NguyenLieu_DTO> DanhSachNL = NguyenLieu_BUS.GetListNL(); if (tbMaNL.Text == "") { MessageBox.Show("Vui lòng nhập thông tin Nguyên Liệu để sửa!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } NguyenLieu_DTO NL = new NguyenLieu_DTO(); NL.MaNL = tbMaNL.Text; NL.TenNL = tbTenNL.Text; NL.SoLuongNhap = Int32.Parse(tbSoLuong.Text); NL.DVT = cbDVT.Text; for (int i = 0; i < DanhSachNL.Count; i++) { if (DanhSachNL[i].MaNL == NL.MaNL && DanhSachNL[i].TenNL == NL.TenNL && DanhSachNL[i].SoLuongNhap == NL.SoLuongNhap && DanhSachNL[i].DVT == NL.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 = NguyenLieu_BUS.Update_NL(NL); if (result.ResultCode_NL == 1) { MessageBox.Show(result.ResultMessage_NL, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(result.ResultMessage_NL, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } Clear(); Load(); }
// Button thêm private void gABThem_Click(object sender, EventArgs e) { if (txtTenNL.Text == "") { MessageBox.Show("Vui lòng nhập tên nguyên liệu !"); return; } if (txtDonVi.Text == "") { MessageBox.Show("Vui Lòng nhập đơn vị tính !"); return; } NguyenLieu_DTO nguyenlieu = new NguyenLieu_DTO(); nguyenlieu.TenNL = txtTenNL.Text; nguyenlieu.Donvi = txtDonVi.Text.ToString(); nguyenlieu.Soluong = int.Parse(txtSoLuong.Text.ToString()); if (dsnguyenlieu != null) { for (int i = 0; i < dsnguyenlieu.Count; i++) { if (ChuanHoaChuoi(nguyenlieu.TenNL.ToLower()) == ChuanHoaChuoi(dsnguyenlieu[i].TenNL.ToLower())) { MessageBox.Show("Nguyên Liệu đã có rồi !"); return; } } } if (NguyenLieu_BUS.ThemNguyenLieu(nguyenlieu)) { LoadNguyenLieu(); MessageBox.Show("Đã Thêm"); return; } MessageBox.Show("Thêm thất bại !"); }
public void SuaThongTinNguyenLieu(NguyenLieu_DTO nl) { SqlConnection con = DataProvider.TaoKetNoi(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = @"UPDATE NguyenLieu SET TenNguyenLieu = @TenNguyenLieu, DonViTinh = @DonViTinh, DonGiaNL = @DonGiaNL WHERE MaNL = @MaNL"; cmd.Parameters.Add("@TenNguyenLieu", SqlDbType.NVarChar, 255); cmd.Parameters.Add("@DonViTinh", SqlDbType.NVarChar, 255); cmd.Parameters.Add("@DonGiaNL", SqlDbType.NVarChar, 255); cmd.Parameters["@TenNguyenLieu"].Value = nl.TenNguyenLieu; cmd.Parameters["@DonViTinh"].Value = nl.DonViTinh; cmd.Parameters["@DonGiaNL"].Value = nl.DonGiaNL; cmd.Parameters.AddWithValue(@"MaNL", nl.MaNL);; cmd.Connection = con; cmd.ExecuteNonQuery(); con.Close(); }
private void btnThemNL_Click(object sender, EventArgs e) { if (txtTenNguyenLieu.Text.Trim() == "" || txtDonViTinh.Text.Trim() == "" || txtDonGiaNguyenLieu.Text.Trim() == "") { MessageBox.Show("Bạn chưa nhập đầy đủ thông tin", "Thông báo"); } else { NguyenLieu_DTO nl = new NguyenLieu_DTO(); nl.TenNguyenLieu = txtTenNguyenLieu.Text; nl.DonViTinh = txtDonViTinh.Text; nl.DonGiaNL = decimal.Parse(txtDonGiaNguyenLieu.Text); NguyenLieu_BUS dtBus = new NguyenLieu_BUS(); dtBus.ThemNguyenLieu(nl, 1); MessageBox.Show("Đã Thêm 1 Nguyên Liệu mới"); LoadDSNL(); ResetNL(); } }
public ResultMessage_DTO Update_NL(NguyenLieu_DTO NguyenLieu_DTO) { ResultMessage_DTO result = new ResultMessage_DTO(); try { SqlCommand cmd = new SqlCommand("proc_UpdateNL", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaNL", NguyenLieu_DTO.MaNL); cmd.Parameters.AddWithValue("@TenNL", NguyenLieu_DTO.TenNL); cmd.Parameters.AddWithValue("@SoLuongNhap", NguyenLieu_DTO.SoLuongNhap); cmd.Parameters.AddWithValue("@DVT", NguyenLieu_DTO.DVT); cmd.Parameters.AddWithValue("@pResultCode_NL", result.ResultCode_NL); cmd.Parameters.AddWithValue("@pResultMessage_NL", result.ResultMessage_NL); cmd.Parameters["@pResultCode_NL"].Direction = ParameterDirection.Output; cmd.Parameters["@pResultMessage_NL"].Direction = ParameterDirection.Output; cmd.Parameters["@pResultMessage_NL"].Size = 200; con.Open(); cmd.ExecuteNonQuery(); result.ResultCode_NL = Int32.Parse(cmd.Parameters["@pResultCode_NL"].Value.ToString()); result.ResultMessage_NL = cmd.Parameters["@pResultMessage_NL"].Value.ToString(); cmd.Dispose(); } catch (Exception ex) { result.ResultCode_NL = -1; result.ResultMessage_NL = ex.Message; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(result); }
public static List <NguyenLieu_DTO> Search_NL(NguyenLieu_DTO NguyenLieu_DTO) { List <NguyenLieu_DTO> Danhsach = new List <NguyenLieu_DTO>(); NguyenLieu_DTO NL; try { con.Open(); SqlCommand cmd = new SqlCommand("proc_SearchNL", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SearchNL", '%' + NguyenLieu_DTO.MaNL + '%'); var reader = cmd.ExecuteReader(); while (reader.Read()) { NL = new NguyenLieu_DTO(); NL.MaNL = reader["MaNL"].ToString(); NL.TenNL = reader["TenNL"].ToString(); NL.SoLuongNhap = Int32.Parse(reader["SoLuongNhap"].ToString()); NL.DVT = (reader["DVT"].ToString()); Danhsach.Add(NL); } reader.Close(); cmd.Dispose(); } catch { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(Danhsach); }
public static List <NguyenLieu_DTO> GetListNL() { List <NguyenLieu_DTO> Danhsach = new List <NguyenLieu_DTO>(); NguyenLieu_DTO NL; try { SqlCommand cmd = new SqlCommand("proc_GetListNL", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { NL = new NguyenLieu_DTO(); NL.MaNL = reader["MaNL"].ToString(); //NL.MaMon = reader["MaMon"].ToString(); NL.TenNL = reader["TenNL"].ToString(); NL.SoLuongNhap = Int32.Parse(reader["SoLuongNhap"].ToString()); NL.DVT = (reader["DVT"].ToString()); Danhsach.Add(NL); } reader.Close(); cmd.Dispose(); } catch (Exception ex) { Danhsach = null; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(Danhsach); }
public static bool New_NL(NguyenLieu_DTO NguyenLieu_DTO) { try { con.Open(); string New = string.Format("exec proc_NewNL @MaNL='{0}',@TenNL=N'{1}',@SoLuongNhap='{2}',@DVT=N'{3}'", NguyenLieu_DTO.MaNL, NguyenLieu_DTO.TenNL, NguyenLieu_DTO.SoLuongNhap, NguyenLieu_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 void SuaThongTinNguyenLieu(NguyenLieu_DTO nl) { NguyenLieu_DAO dao = new NguyenLieu_DAO(); dao.SuaThongTinNguyenLieu(nl); }
public void ThemNguyenLieu(NguyenLieu_DTO nl, int TrangThai) { NguyenLieu_DAO dao = new NguyenLieu_DAO(); dao.ThemNguyenLieu(nl, TrangThai); }
public static bool XoaNguyenLieu(NguyenLieu_DTO nguyenlieu) { return(NguyenLieu_DAO.XoaNguyenLieu(nguyenlieu)); }
public static bool ThemNguyenLieu(NguyenLieu_DTO nguyenlieu) { return(NguyenLieu_DAO.ThemNguyenLieu(nguyenlieu)); }