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