public bool SuaKiemDuyetPhieuGiaHan(PhieuGiaHanDTO phieuGiaHanDTO)
{
try
{
OpenConnect();
string store = "sp_PhieuGiaHan_SuaKiemDuyet";
sqlCommand = new SqlCommand(store, connect);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(new SqlParameter("@maphieugiahan", phieuGiaHanDTO.MaPhieuGiaHan));
sqlCommand.Parameters.Add(new SqlParameter("@trangthaikiemduyet", phieuGiaHanDTO.TrangThaiKiemDuyet));
sqlCommand.Parameters.Add(new SqlParameter("@lydokhongduyet", phieuGiaHanDTO.LyDoKhongDuyet));
sqlCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
finally
{
CloseConnect();
}
}
public bool SuaPhieuGiaHan(PhieuGiaHanDTO phieuGiaHanDTO)
{
try
{
OpenConnect();
string store = "sp_PhieuGiaHan_Sua";
sqlCommand = new SqlCommand(store, connect);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(new SqlParameter("@maphieugiahan", phieuGiaHanDTO.MaPhieuGiaHan));
sqlCommand.Parameters.Add(new SqlParameter("@maphieudangky", phieuGiaHanDTO.MaPhieuDangKy));
sqlCommand.Parameters.Add(new SqlParameter("@manhanvien", phieuGiaHanDTO.MaNhanVien));
sqlCommand.Parameters.Add(new SqlParameter("@ngaylap", phieuGiaHanDTO.NgayLap));
sqlCommand.Parameters.Add(new SqlParameter("@ngaybatdau", phieuGiaHanDTO.NgayBatDau));
sqlCommand.Parameters.Add(new SqlParameter("@ngayketthuc", phieuGiaHanDTO.NgayKetThuc));
sqlCommand.Parameters.Add(new SqlParameter("@trangthaikiemduyet", phieuGiaHanDTO.TrangThaiKiemDuyet));
sqlCommand.Parameters.Add(new SqlParameter("@tongtien", phieuGiaHanDTO.TongTien));
sqlCommand.Parameters.Add(new SqlParameter("@lydokhongduyet", phieuGiaHanDTO.LyDoKhongDuyet));
sqlCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
finally
{
CloseConnect();
}
}
private void dgvPhieuGiaHan_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
try
{
DataGridViewRow row = dgvPhieuGiaHan.Rows[e.RowIndex];
int columnIndex = dgvPhieuGiaHan.CurrentCell.ColumnIndex;
string columnName = dgvPhieuGiaHan.Columns[columnIndex].Name;
int maPhieuGH = Int32.Parse(row.Cells["MaPhieuGiaHan"].Value.ToString());
if (columnName.Equals("ChiTietGH"))
{
DialogPhieuGiaHan dialogPhieuGiaHan = new DialogPhieuGiaHan(maPhieuGH);
dialogPhieuGiaHan.StartPosition = FormStartPosition.CenterScreen;
dialogPhieuGiaHan.ShowDialog(this);
}
if (columnName.Equals("XacNhanGh"))
{
int trangThai = 0;
if (row.Cells["TrangThaiKiemDuyetGH"].Value.ToString().Equals("1"))
{
trangThai = 1;
}
string lyDo = "";
if (trangThai == 0)
{
lyDo = row.Cells["LyDoKhongDuyetGH"].Value.ToString();
}
PhieuGiaHanDTO phieuGiaHanDTO = new PhieuGiaHanDTO(maPhieuGH, trangThai, lyDo);
try
{
if (phieuGiaHanBLL.SuaKiemDuyetPhieuGiaHan(phieuGiaHanDTO))
{
MessageBox.Show("Sửa trạng thái phiếu gia hạn thành công");
LoadPhieuGiaHan();
}
else
{
MessageBox.Show("Sửa trạng thái phiếu gia hạn thất bại");
}
}
catch
{
}
}
}
catch { }
}
}
public bool SuaKiemDuyetPhieuGiaHan(PhieuGiaHanDTO phieuGiaHanDTO)
{
return(phieuGiaHanDAL.SuaKiemDuyetPhieuGiaHan(phieuGiaHanDTO));
}
public bool SuaPhieuGiaHan(PhieuGiaHanDTO phieuGiaHanDTO)
{
return(phieuGiaHanDAL.SuaPhieuGiaHan(phieuGiaHanDTO));
}
public bool ThemPhieuGiaHan(PhieuGiaHanDTO phieuGiaHanDTO)
{
return(phieuGiaHanDAL.ThemPhieuGiaHan(phieuGiaHanDTO));
}
private void btnThem_Click(object sender, EventArgs e)
{
if (KiemTraThongTinTrong())
{
MessageBox.Show("Làm ơn điền đầy đủ thông tin phiếu gia hạn");
}
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;
}
PhieuGiaHanDTO phieuGiaHanDTO = new PhieuGiaHanDTO(
maPDK,
Int32.Parse(cbNhanVien.SelectedValue.ToString()),
Convert.ToDateTime(dtpNgayLapPhieu.Text),
Convert.ToDateTime(dtpNgayBatDau.Text),
Convert.ToDateTime(dtpNgayKetThuc.Text),
trangThaiKiemDuyet,
Double.Parse(txtTongTien.Text.ToString())
, "");
try
{
if (phieuGiaHanBLL.ThemPhieuGiaHan(phieuGiaHanDTO))
{
MessageBox.Show("Thêm phiếu gia hạn thành công");
phieuGiaHanBLL.TangSoLanGiaHan(phieuGiaHanDTO.MaPhieuDangKy);
if (MaPDKTuFormPDK == 0)
{
dgvPhieuGiaHan.DataSource = phieuGiaHanBLL.LayDanhSachPhieuPhieuGiaHanCoTen();
}
else
{
dgvPhieuGiaHan.DataSource = phieuGiaHanBLL.LayDanhSachPhieuGiaHanTheoMaPDK(MaPDKTuFormPDK);
}
}
else
{
MessageBox.Show("Thêm phiếu gia hạn thất bại");
}
}
catch
{
}
}
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (KiemTraThongTinTrong())
{
MessageBox.Show("Làm ơn điền đầy đủ thông tin phiếu gia hạn");
}
else
{
if (KiemTraThongTinHopLe())
{
int trangThaiKiemDuyet = 0;
if (rbDaKiemDuyet.Checked)
{
trangThaiKiemDuyet = 1;
}
if (txtMaPhieuGiaHan.Text != "")
{
int maPDK = 0;
if (MaPDKTuFormPDK == 0)
{
maPDK = Int32.Parse(cbMaPhieuDangKy.SelectedValue.ToString());
}
else
{
maPDK = MaPDKTuFormPDK;
}
PhieuGiaHanDTO phieuGiaHanDTO = new PhieuGiaHanDTO(
Int32.Parse(txtMaPhieuGiaHan.Text.ToString()),
maPDK,
Int32.Parse(cbNhanVien.SelectedValue.ToString()),
Convert.ToDateTime(dtpNgayLapPhieu.Text),
Convert.ToDateTime(dtpNgayBatDau.Text),
Convert.ToDateTime(dtpNgayKetThuc.Text),
trangThaiKiemDuyet,
Double.Parse(phieuDangKyBLL.LayDanhSachPhieuDangKyTheoMa(Int32.Parse(cbMaPhieuDangKy.Text.ToString())).Rows[0]["TongTien"].ToString()) * Double.Parse(txtPhanTramGiaHan.Text.ToString())
, "");
try
{
if (phieuGiaHanBLL.SuaPhieuGiaHan(phieuGiaHanDTO))
{
MessageBox.Show("Sửa phiếu gia hạn thành công");
if (MaPDKTuFormPDK == 0)
{
dgvPhieuGiaHan.DataSource = phieuGiaHanBLL.LayDanhSachPhieuPhieuGiaHanCoTen();
}
else
{
dgvPhieuGiaHan.DataSource = phieuGiaHanBLL.LayDanhSachPhieuGiaHanTheoMaPDK(MaPDKTuFormPDK);
}
LamMoiThongTin();
}
else
{
MessageBox.Show("Sửa phiếu gia hạn thất bại");
}
}
catch
{
}
}
else
{
MessageBox.Show("Làm ơn chọn phiếu gia hạn muốn sửa thông tin!");
}
}
}
}
