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