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