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 btDelete_Click(object sender, EventArgs e)
{
if (tbMaNV.Text == "")
{
MessageBox.Show("Vui lòng chọn nhân viên để xóa!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
NhanVien_DTO NV_DTO = new NhanVien_DTO();
NV_DTO.MaNV = tbMaNV.Text;
NV_DTO.HoTenNV = tbHoTenNV.Text;
NV_DTO.NgaySinh = (dtPickerNgaySinh.Text);
//NV_DTO.NgaySinh = DateTime.Parse( dtPickerNgaySinh.Text);
NV_DTO.GioiTinh = cbGioiTinh.Text;
NV_DTO.QueQuan = tbQueQuan.Text;
NV_DTO.DiaChi = tbDiaChi.Text;
NV_DTO.Email = tbEmail.Text;
NV_DTO.SDT = tbSDT.Text;
result = BUS.Delete_NV(NV_DTO);
if (result.ResultCode_NV == "1")
{
MessageBox.Show(result.ResultMessage_NV, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(result.ResultMessage_NV, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load();
Clear();
}
//Kiểm tra check User đăng nhập thành công hay không
public ResultMessage_DTO CheckUserLogin(Login_DTO Login_DTO)
{
ResultMessage_DTO result = new ResultMessage_DTO();
try
{
SqlCommand cmd = new SqlCommand("usp_USER_CheckUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@psUsername", Login_DTO.UserName);
cmd.Parameters.AddWithValue("@psPassword", Login_DTO.PassWord);
cmd.Parameters.AddWithValue("@pResultCode", result.ResultCode);
cmd.Parameters.AddWithValue("@pResultMessage", result.ResultMessage);
cmd.Parameters["@pResultCode"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage"].Size = 50;
con.Open();
cmd.ExecuteNonQuery();
result.ResultCode = (int)cmd.Parameters["@pResultCode"].Value;
result.ResultMessage = cmd.Parameters["@pResultMessage"].Value.ToString();
cmd.Dispose();
}
catch (Exception ex)
{
result.ResultCode = -1;
result.ResultMessage = ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
private void btUpdate_Click(object sender, EventArgs e)
{
List <NhanVien_DTO> DanhSachNV = BUS.GetListNV();
NhanVien_DTO NV_DTO = new NhanVien_DTO();
NhanVien_BUS NV_BUS = new NhanVien_BUS();
if (tbMaNV.Text == "")
{
MessageBox.Show("Vui lòng nhập dữ liệu để sửa thông tin nhân viên!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
NV_DTO.MaNV = tbMaNV.Text;
NV_DTO.HoTenNV = tbHoTenNV.Text;
NV_DTO.NgaySinh = (dtPickerNgaySinh.Text);
//NV_DTO.NgaySinh = DateTime.Parse(dtPickerNgaySinh.Text);
NV_DTO.GioiTinh = cbGioiTinh.Text;
NV_DTO.QueQuan = tbQueQuan.Text;
NV_DTO.DiaChi = tbDiaChi.Text;
NV_DTO.Email = tbEmail.Text;
NV_DTO.SDT = tbSDT.Text;
for (int i = 0; i < DanhSachNV.Count; i++)
{
if (DanhSachNV[i].MaNV == NV_DTO.MaNV &&
DanhSachNV[i].HoTenNV == NV_DTO.HoTenNV &&
DanhSachNV[i].NgaySinh == NV_DTO.NgaySinh &&
DanhSachNV[i].GioiTinh == NV_DTO.GioiTinh &&
DanhSachNV[i].QueQuan == NV_DTO.QueQuan &&
DanhSachNV[i].Email == NV_DTO.Email &&
DanhSachNV[i].SDT == NV_DTO.SDT &&
DanhSachNV[i].DiaChi == NV_DTO.DiaChi
)
{
MessageBox.Show("Vui lòng nhập dữ liệu mới để sửa thông tin nhân viên!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
result = BUS.Update_NV(NV_DTO);
if (result.ResultCode_NV == "1")
{
MessageBox.Show(result.ResultMessage_NV, "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(result.ResultMessage_NV, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load();
Clear();
}
public ResultMessage_DTO Update_NV(NhanVien_DTO NhanVien_DTO)
{
ResultMessage_DTO result = new ResultMessage_DTO();
try
{
SqlCommand cmd = new SqlCommand("proc_UpdateNV", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ma_NV", NhanVien_DTO.MaNV);
cmd.Parameters.AddWithValue("@HoTen_NV", NhanVien_DTO.HoTenNV);
cmd.Parameters.AddWithValue("@NgaySinh", NhanVien_DTO.NgaySinh);
cmd.Parameters.AddWithValue("@GioiTinh", NhanVien_DTO.GioiTinh);
cmd.Parameters.AddWithValue("@QueQuan", NhanVien_DTO.QueQuan);
cmd.Parameters.AddWithValue("@DiaChi", NhanVien_DTO.DiaChi);
cmd.Parameters.AddWithValue("@Email", NhanVien_DTO.Email);
cmd.Parameters.AddWithValue("@SoDienThoai", NhanVien_DTO.SDT);
cmd.Parameters.AddWithValue("@pResultCode_NV", result.ResultCode_NV);
cmd.Parameters.AddWithValue("@pResultMessage_NV", result.ResultMessage_NV);
cmd.Parameters["@pResultCode_NV"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_NV"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_NV"].Size = 200;
con.Open();
cmd.ExecuteNonQuery();
result.ResultCode_NV = cmd.Parameters["@pResultCode_NV"].Value.ToString();
result.ResultMessage_NV = cmd.Parameters["@pResultMessage_NV"].Value.ToString();
cmd.Dispose();
}
catch (Exception ex)
{
result.ResultCode_NV = "";
result.ResultMessage_NV = ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
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();
}
//Kiểm tra tài khoản user có tồn tại hay ko
public ResultMessage_DTO AddUserDetails(Login_DTO ObjBO) // passing Bussiness object Here
{
ResultMessage_DTO result = new ResultMessage_DTO();
try
{
/* Because We will put all out values from our (UserRegistration.aspx)
* To in Bussiness object and then Pass it to Bussiness logic and then to
* DataAcess
* this way the flow carry on*/
SqlCommand cmd = new SqlCommand("usp_USER_CheckUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@psUsername", ObjBO.UserName);
cmd.Parameters.AddWithValue("@psPassword", ObjBO.PassWord);
cmd.Parameters.AddWithValue("@pResultCode", result.ResultCode);
cmd.Parameters.AddWithValue("@pResultMessage", result.ResultMessage);
cmd.Parameters["@pResultCode"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage"].Size = 50;
con.Open();
cmd.ExecuteNonQuery();
result.ResultCode = (int)cmd.Parameters["@pResultCode"].Value;
result.ResultMessage = cmd.Parameters["@pResultMessage"].Value.ToString();
cmd.Dispose();
}
catch (Exception ex)
{
result.ResultCode = -1;
result.ResultMessage = ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
public static ResultMessage_DTO SuaP(PhongDTO p)
{
ResultMessage_DTO result = new ResultMessage_DTO();
try
{
SqlCommand cmd = new SqlCommand("usp_SuaP", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@map", p.maphong);
cmd.Parameters.AddWithValue("@gia", p.gia);
cmd.Parameters.AddWithValue("@s", p.succhua);
cmd.Parameters.AddWithValue("@l", p.loaiphong);
cmd.Parameters.AddWithValue("@g", p.ghichu);
cmd.Parameters.AddWithValue("@pResultCode_P", result.ResultCode_DV);
cmd.Parameters.AddWithValue("@pResultMessage_P", result.ResultMessage_DV);
cmd.Parameters["@pResultCode_P"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_P"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_P"].Size = 200;
con.Open();
cmd.ExecuteNonQuery();
result.ResultCode_P = cmd.Parameters["@ResultCode_P"].Value.ToString();
result.ResultMessage_P = cmd.Parameters["@ResultMessage_P"].Value.ToString();
cmd.Dispose();
}
catch (Exception ex)
{
result.ResultCode_DV = "";
result.ResultMessage_DV = ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
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 ResultMessage_DTO Update_NCC(NhaCungCap_DTO NhaCungCap_DTO)
{
ResultMessage_DTO result = new ResultMessage_DTO();
try
{
SqlCommand cmd = new SqlCommand("proc_UpdateNCC", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNCC", NhaCungCap_DTO.MaNCC);
cmd.Parameters.AddWithValue("@TenNCC", NhaCungCap_DTO.TenNCC);
cmd.Parameters.AddWithValue("@DiaChi", NhaCungCap_DTO.DiaChi);
cmd.Parameters.AddWithValue("@SDT", NhaCungCap_DTO.SoDienThoai);
cmd.Parameters.AddWithValue("@pResultCode_NCC", result.ResultCode_NCC);
cmd.Parameters.AddWithValue("@pResultMessage_NCC", result.ResultMessage_NCC);
cmd.Parameters["@pResultCode_NCC"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_NCC"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_NCC"].Size = 200;
con.Open();
cmd.ExecuteNonQuery();
result.ResultCode_NCC = cmd.Parameters["@pResultCode_NCC"].Value.ToString();
result.ResultMessage_NCC = cmd.Parameters["@pResultMessage_NCC"].Value.ToString();
cmd.Dispose();
}
catch (Exception ex)
{
result.ResultCode_NCC = "";
result.ResultMessage_NCC = ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
public static ResultMessage_DTO SuaDV(DichVuDTO dv)
{
ResultMessage_DTO result = new ResultMessage_DTO();
try
{
SqlCommand cmd = new SqlCommand("usp_UpdateDV", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Madv", dv.madichvu);
cmd.Parameters.AddWithValue("@tendv", dv.tendichvu);
cmd.Parameters.AddWithValue("@g", dv.gia);
cmd.Parameters.AddWithValue("@l", dv.loai);
cmd.Parameters.AddWithValue("@pResultCode_DV", result.ResultCode_DV);
cmd.Parameters.AddWithValue("@pResultMessage_DV", result.ResultMessage_DV);
cmd.Parameters["@pResultCode_DV"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_DV"].Direction = ParameterDirection.Output;
cmd.Parameters["@pResultMessage_DV"].Size = 200;
con.Open();
cmd.ExecuteNonQuery();
result.ResultCode_DV = cmd.Parameters["@pResultCode_DV"].Value.ToString();
result.ResultMessage_DV = cmd.Parameters["@pResultMessage_DV"].Value.ToString();
cmd.Dispose();
}
catch (Exception ex)
{
result.ResultCode_DV = "";
result.ResultMessage_DV = ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
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);
}
