public bool SuaKiemDuyetPhieunNgungDichVu(HuyDangKyDTO huyDangKyDTO) { try { OpenConnect(); string store = "sp_PhieuNgungDangKyDichVu_SuaKiemDuyet"; sqlCommand = new SqlCommand(store, connect); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(new SqlParameter("@maphieungungdichvu", huyDangKyDTO.MaPhieuNgungDangKyDichVu)); sqlCommand.Parameters.Add(new SqlParameter("@trangthaikiemduyet", huyDangKyDTO.TrangThaiKiemDuyet)); sqlCommand.Parameters.Add(new SqlParameter("@lydokhongduyet", huyDangKyDTO.LyDoKhongDuyet)); sqlCommand.ExecuteNonQuery(); return(true); } catch { return(false); } finally { CloseConnect(); } }
public bool SuaHuyDangKy(HuyDangKyDTO huyDangKyDTO) { try { OpenConnect(); string store = "sp_HuyDangKy_Sua"; sqlCommand = new SqlCommand(store, connect); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(new SqlParameter("@maphieungungdangkydichvu", huyDangKyDTO.MaPhieuNgungDangKyDichVu)); sqlCommand.Parameters.Add(new SqlParameter("@maphieudangky", huyDangKyDTO.MaPhieuDangKy)); sqlCommand.Parameters.Add(new SqlParameter("@manhanvien", huyDangKyDTO.MaNhanVien)); sqlCommand.Parameters.Add(new SqlParameter("@ngaylap", huyDangKyDTO.NgayLap)); sqlCommand.Parameters.Add(new SqlParameter("@lydo", huyDangKyDTO.LyDo)); sqlCommand.Parameters.Add(new SqlParameter("@trangthaikiemduyet", huyDangKyDTO.TrangThaiKiemDuyet)); sqlCommand.Parameters.Add(new SqlParameter("@lydokhongduyet", huyDangKyDTO.LyDoKhongDuyet)); sqlCommand.ExecuteNonQuery(); return(true); } catch { return(false); } finally { CloseConnect(); } }
private void btnThem_Click(object sender, EventArgs e) { if (KiemTraThongTinTrong()) { MessageBox.Show("Làm ơn điền đầy đủ thông tin phiếu hủy đăng ký"); } else { if (KiemTraThongTinHopLe()) { int trangThaiKiemDuyet = 0; if (rbDaKiemDuyet.Checked) { trangThaiKiemDuyet = 1; } int maPDK = 0; if (MaPDKTuFormPDK == 0) { maPDK = Int32.Parse(cbMaPhieuDangKy.SelectedValue.ToString()); } else { maPDK = MaPDKTuFormPDK; } HuyDangKyDTO huyDangKyDTO = new HuyDangKyDTO( maPDK, Int32.Parse(cbNhanVien.SelectedValue.ToString()), Convert.ToDateTime(dtpNgayLapPhieu.Text), txtLyDoNgung.Text.ToString(), trangThaiKiemDuyet, ""); try { if (huyDangKyBLL.ThemHuyDangKy(huyDangKyDTO)) { MessageBox.Show("Thêm phiếu hủy đăng ký thành công"); if (MaPDKTuFormPDK == 0) { dgvHuyDangKy.DataSource = huyDangKyBLL.LayDanhSachPhieuHuyDangKyCoTenNhanVien(); } else { dgvHuyDangKy.DataSource = huyDangKyBLL.LayDanhSachHuyDangKyTheoMaPDK(MaPDKTuFormPDK); } } else { MessageBox.Show("Thêm phiếu hủy đăng ký thất bại"); } } catch { } } } }
private void dgvNgungDichVu_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { try { DataGridViewRow row = dgvNgungDichVu.Rows[e.RowIndex]; int columnIndex = dgvNgungDichVu.CurrentCell.ColumnIndex; string columnName = dgvNgungDichVu.Columns[columnIndex].Name; int maNDV = Int32.Parse(row.Cells["MaPhieuNgungDangKyDichVu"].Value.ToString()); if (columnName.Equals("ChiTietNDV")) { DialogHuyDangKy dialogHuyDangKy = new DialogHuyDangKy(maNDV); dialogHuyDangKy.StartPosition = FormStartPosition.CenterScreen; dialogHuyDangKy.ShowDialog(this); } if (columnName.Equals("XacNhanNDV")) { int trangThai = 0; if (row.Cells["TrangThaiKiemDuyetNDV"].Value.ToString().Equals("1")) { trangThai = 1; } string lyDo = ""; if (trangThai == 0) { lyDo = row.Cells["LyDoKhongDuyetNDV"].Value.ToString(); } HuyDangKyDTO huyDangKyDTO = new HuyDangKyDTO(maNDV, trangThai, lyDo); try { if (huyDangKyBLL.SuaKiemDuyetPhieunNgungDichVu(huyDangKyDTO)) { MessageBox.Show("Sửa trạng thái phiếu ngưng dịch vụ thành công"); LoadPhieuNgungDV(); } else { MessageBox.Show("Sửa trạng thái phiếu ngưng dịch vụ thất bại"); } } catch { } } } catch { } } }
public bool SuaKiemDuyetPhieunNgungDichVu(HuyDangKyDTO huyDangKyDTO) { return(huyDangKyDAL.SuaKiemDuyetPhieunNgungDichVu(huyDangKyDTO)); }
public bool SuaHuyDangKy(HuyDangKyDTO huyDangKyDTO) { return(huyDangKyDAL.SuaHuyDangKy(huyDangKyDTO)); }
public bool ThemHuyDangKy(HuyDangKyDTO huyDangKyDTO) { return(huyDangKyDAL.ThemHuyDangKy(huyDangKyDTO)); }