// hien thi list dto
public bool danhsachPhieuTra(List <phieutraDTO> listPTDTO)
{
string query = string.Format("select* from [phieutra] ");
SqlParameter[] parm = new SqlParameter[1];
// ko can thiet nhung phai co
docgiaDTO dg = new docgiaDTO();
parm[0] = new SqlParameter("@masach", SqlDbType.Int);
parm[0].Value = dg.MaThe;
DataTable datatable = new DataTable();
datatable = conn.excuteNonQuery(query, parm);
//gan value trong datatable vao DTO
foreach (DataRow dr in datatable.Rows)
{
phieutraDTO ptDTO = new phieutraDTO();
ptDTO.Mapt = int.Parse(dr["mapt"].ToString());
ptDTO.Ngaytra = DateTime.Parse(dr["ngaytra"].ToString());
ptDTO.Tienphatkinay = int.Parse(dr["tienphatkinay"].ToString());
ptDTO.Mathe = int.Parse(dr["mathe"].ToString());
listPTDTO.Add(ptDTO);
}
return(true);
}
public bool suaPhieuTra(phieutraDTO ptDTO)
{
string query = string.Format(" update [phieutra] set ngaytra=@ngaytra,tienphatkinay=@tienphatkinay,mathe=@mathe where mapt=@mapt ");
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@mapt", SqlDbType.Int);
param[0].Value = Convert.ToString(ptDTO.Mapt);
param[1] = new SqlParameter("@ngaytra", SqlDbType.DateTime);
param[1].Value = Convert.ToString(ptDTO.Ngaytra);
param[2] = new SqlParameter("@tienphatkinay", SqlDbType.Int);
param[2].Value = Convert.ToString(ptDTO.Tienphatkinay);
param[3] = new SqlParameter("@mathe", SqlDbType.Int);
param[3].Value = Convert.ToString(ptDTO.Mathe);
conn.excuteNonQuery2(query, param);
return(true);
}
public bool themPhieuTra(phieutraDTO ptDTO)
{
string query = string.Format("insert into [phieutra] values (@mapt,@ngaytra,@tienphatkinay,@mathe)");
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@mapt", SqlDbType.Int);
param[0].Value = Convert.ToString(ptDTO.Mapt);
param[1] = new SqlParameter("@ngaytra", SqlDbType.DateTime);
param[1].Value = Convert.ToString(ptDTO.Ngaytra);
param[2] = new SqlParameter("@tienphatkinay", SqlDbType.Int);
param[2].Value = Convert.ToString(ptDTO.Tienphatkinay);
param[3] = new SqlParameter("@mathe", SqlDbType.Int);
param[3].Value = Convert.ToString(ptDTO.Mathe);
conn.excuteNonQuery2(query, param);
return(true);
}
/// <summary>
/// Trả sách
/// </summary>
/// <param name="bandoc">Mã bạn đọc </param>
/// <param name="sachs">danh sách các bạn đọc </param>
/// <returns></returns>
public List <ctptDTO> TraSach(docgiaDTO bandoc, List <sachDTO> sachtra)
{
docgiaDAL banDocDAL = new docgiaDAL();
sachDAL sachDAL = new sachDAL();
quydinhDAL quyDinhDAL = new quydinhDAL();
phieutraDAL phieutraDAL = new phieutraDAL();
ctptDAL ctptDAL = new ctptDAL();
giahanDAL giaHanDAL = new giahanDAL();
List <sachDTO> sachdangmuon = new List <sachDTO>();
List <DateTime> danhsachngaymuonsach = new List <DateTime>();
List <phieutraDTO> danhsachphieutra = new List <phieutraDTO>();
List <ctptDTO> danhsachchitietphieutra = new List <ctptDTO>();
quydinhDTO danhsachquydinh = new quydinhDTO();
quydinhDTO quydinh = new quydinhDTO();
quyDinhDAL.listquydinh(danhsachquydinh);
quydinh = danhsachquydinh;
sachDAL.SachDangMuon(bandoc.MaThe, sachdangmuon, danhsachngaymuonsach);
phieutraDAL.danhsachPhieuTra(danhsachphieutra);
//Thêm phiếu trả
phieutraDTO phieutra = new phieutraDTO();
phieutra.Mapt = danhsachphieutra.Count + 1;
phieutra.Mathe = bandoc.MaThe;
phieutra.Ngaytra = DateTime.Now;
phieutra.Tienphatkinay = 0;
phieutraDAL.themPhieuTra(phieutra);
int tienphatkinay = 0;
foreach (sachDTO saxtra in sachtra)
{
giahanDTO giaHanDTO = new giahanDTO();
giaHanDAL.laygiahancuasach(saxtra.Masach, giaHanDTO);
// kiễm tra quá hạn , tính tiền phạt khi trễ, mất sách
DateTime ngaymuonsach = LayDatetimeDcMuonCuaSach(saxtra.Masach, sachdangmuon, danhsachngaymuonsach);
int songaydamuon = SoNgayMuon(ngaymuonsach, DateTime.Now);
int tienphatsachnay = 0;
if (saxtra.Trangthai == (int)TrangThaiSach.DaMat)
{
tienphatsachnay = saxtra.Giatri;
}
if (songaydamuon > quydinh.Songayduocmuon + giaHanDTO.Solangiahan * 7)
{
tienphatsachnay = (songaydamuon - (quydinh.Songayduocmuon + giaHanDTO.Solangiahan * 7)) * quydinh.Tienphattrasachtremoingay;
}
tienphatkinay += tienphatsachnay;
//thêm chi tiết phiếu trả
ctptDTO ctptra = new ctptDTO();
ctptra.Mapt = phieutra.Mapt;
ctptra.Masach = saxtra.Masach;
ctptra.Songaydamuon = songaydamuon;
ctptra.Tienphatsach = tienphatsachnay;
ctptDAL.themCTPT(ctptra);
danhsachchitietphieutra.Add(ctptra);
//quẳng sách lại zô kho
QuanLiSachBUS qlsachBUS = new QuanLiSachBUS();
if (saxtra.Trangthai != (int)TrangThaiSach.DaMat)
{
qlsachBUS.Travekho(saxtra);
}
else
{
qlsachBUS.MatSach(saxtra);
}
//xóa ngày cho phép giữ sách
GiaHanSachBUS ghsax = new GiaHanSachBUS();
ghsax.XoaSoLanMuonSach(saxtra.Masach);
}
//sửa thông tin phiếu trả
phieutra.Tienphatkinay = tienphatkinay;
phieutraDAL.suaPhieuTra(phieutra);
//thêm nợ vào bạn đọc
bandoc.Tongtienno += tienphatkinay;
banDocDAL.suaDocGia(bandoc, bandoc.MaThe);
return(danhsachchitietphieutra);
}
