private void btnHoanTat_Click(object sender, EventArgs e)
{
PhieuThanhLySachDTO phieuThanhLySachDTO = new PhieuThanhLySachDTO();
phieuThanhLySachDTO.MaPhieuthanhLy = txtMaPhieu.Text;
phieuThanhLySachDTO.MaNV = cbbNhanVien.SelectedValue.ToString();
phieuThanhLySachDTO.NgayThanhLy = dtNgayThanhLy.Value.ToString("MM-dd-yyyy");
QuanLyThanhLySachBUS quanLyThanhLySachBUS = new QuanLyThanhLySachBUS();
quanLyThanhLySachBUS.ThemPhieuThanhLySach(phieuThanhLySachDTO);
foreach (DataGridViewRow row in dgvChiTietPhieuThanhLy.Rows)
{
if (row.Index == dgvChiTietPhieuThanhLy.Rows.Count - 1)
{
break;
}
ChiTietPhieuThanhLySachDTO ChiTiet = new ChiTietPhieuThanhLySachDTO();
ChiTiet.MaPhieuThanhLy = txtMaPhieu.Text;
ChiTiet.MaSach = row.Cells["MaSach"].Value.ToString();
ChiTiet.MaLyDoThanhLy = row.Cells["LyDoThanhLy"].Value.ToString();
quanLyThanhLySachBUS.ThemChiTietPhieuThanhLySach(ChiTiet);
quanLyThanhLySachBUS.XoaSach(ChiTiet.MaSach);
}
MessageBox.Show("Lập phiếu thanh lý sách thành công");
LoadMaPhieuThanhLy();
LamMoiForm();
}
public int ThemPhieuThanhLySach(PhieuThanhLySachDTO phieuThanhLySach)
{
try
{
string strSQL = "INSERT INTO THANHLYSACH VALUES(@MaPhieuThanhLy, @MaNV, @NgayThanhLy)";
provider.Connect();
int Row = provider.ExecuteNonQuery(CommandType.Text, strSQL,
new SqlParameter {
ParameterName = "@MaPhieuThanhLy", Value = phieuThanhLySach.MaPhieuthanhLy
},
new SqlParameter {
ParameterName = "@MaNV", Value = phieuThanhLySach.MaNV
},
new SqlParameter {
ParameterName = "@NgayThanhLy", Value = phieuThanhLySach.NgayThanhLy
}
);
return(Row);
}
catch (Exception ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
}
public int ThemPhieuThanhLySach(PhieuThanhLySachDTO phieuThanhLySach)
{
try
{
QuanLyThanhLySachDAO quanLyThanhLySachDAO = new QuanLyThanhLySachDAO();
int Row = quanLyThanhLySachDAO.ThemPhieuThanhLySach(phieuThanhLySach);
return(Row);
}
catch (Exception ex)
{
throw ex;
}
}
