public DTO_TRASACH tra_Sach(int ctrltinhieu = 0) { DTO_TRASACH dtots = new DTO_TRASACH() { ID_USER = Int32.Parse(ttbMaDocGia.Text), TIENBOITHUONG = Int32.Parse(ttbSachHong.Text) }; List <int> lsidsach = lay_DanhSachMaSachTra(); try { if (bllphieuts.themPhieuTraSach(ref dtots, lsidsach, ctrltinhieu)) { dtgvSachMuon.Refresh(); DTO_DOCGIA dtodocgia = blldocgia.layDocGia(Int32.Parse(ttbMaDocGia.Text)); if (dtodocgia != null) { ttbTenDocGia.Text = dtodocgia.HOVATEN; } ttbNgayTra.Text = DateTime.Now.Date.ToString("dd/MM/yyyy"); return(dtots); } } catch (Exception ex) { MessageBox.Show(ex.Message); } return(null); }
public bool themPhieuTraSach(DTO_TRASACH dtophieuts) { try { _conn.Open(); string sql = string.Format("INSERT INTO TRASACH (ID_USER, NGAYTRA, SONGAYTRE," + " TIENTRE, TIENBOITHUONG, TIENTHUESACH, TONGTIEN, CREATED_AT, UPDATED_AT)" + " VALUES( {0}, '{1}', {2}, {3}, {4}, {5}, {6}, '{7}', '{8}' )", dtophieuts.ID_USER, dtophieuts.NGAYTRA, dtophieuts.SONGAYTRE, dtophieuts.TIENTRE, dtophieuts.TIENBOITHUONG, dtophieuts.TIENTHUESACH, dtophieuts.TONGTIEN, dtophieuts.CREATED_AT.ToString("yyyy-MM-dd HH:mm:ss.fff"), dtophieuts.UPDATED_AT.ToString("yyyy-MM-dd HH:mm:ss.fff")); MySqlCommand cmd = new MySqlCommand(sql, _conn); if (cmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { _conn.Close(); } return(false); }
private void btnLapPhieuThuTP_Click(object sender, EventArgs e) { if (!(kiemTra_DauVao() && kiemTra_TinhHopLe())) { return; } try { DTO_TRASACH dtots = tra_Sach(1); if (dtots != null) { PL_Payment plpayment = new PL_Payment(dtots); plpayment.Show(); } else { MessageBox.Show("Lap Phieu Thu Tien That Bai"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public bool tra_TungSach(ref DTO_TRASACH dtots, int idsach) { BLL_Sach bllsach = new BLL_Sach(); BLL_QuyDinh bllquydinh = new BLL_QuyDinh(); BLL_PhieuMuonSach bllphieums = new BLL_PhieuMuonSach(); DataTable dtphieums = null; DateTime datemuonsach = DateTime.Now; int totalngaytra = 0, maxngaytra = 0, finetratre = 0, feethuesach = 0, feeboithuong = 0; try { dtphieums = bllphieums.layCTMuonSach_ChuaTra(dtots.ID_USER, idsach); datemuonsach = Convert.ToDateTime(dtphieums.Rows[0]["CREATED_AT"].ToString()); totalngaytra = DateTime.Now.Subtract(datemuonsach).Days; maxngaytra = bllquydinh.layQuyDinh("So_Ngay_Muon_Toi_Da"); finetratre = bllquydinh.layQuyDinh("Tien_Phat"); feethuesach = bllquydinh.layQuyDinh("Tien_Muon_Sach"); dtots.SONGAYTRE += ((totalngaytra - maxngaytra > 0) ? (totalngaytra - maxngaytra) : 0); dtots.TIENTRE += dtots.SONGAYTRE * finetratre; dtots.TIENBOITHUONG += 0; dtots.TIENTHUESACH += feethuesach; dtots.TONGTIEN += dtots.TIENTRE + dtots.TIENBOITHUONG + dtots.TIENTHUESACH; return(true); } catch (Exception ex) { //mess } return(false); }
public void tra_TungSach(ref DTO_TRASACH dtots, int idsach, int ishong) { BLL_Sach bllsach = new BLL_Sach(); BLL_QuyDinh bllquydinh = new BLL_QuyDinh(); BLL_PhieuMuonSach bllphieums = new BLL_PhieuMuonSach(); DTO_CHITIETMUONSACH dtoctms = null; DateTime datemuonsach; int numngaytratre = 0, maxngaytra = 0, paymtratre = 0, feethuesach = 0, paymboithuong = 0; try { dtoctms = bllphieums.layCTMuonSach_ChuaTra(dtots.ID_USER, idsach); datemuonsach = dtoctms.CREATED_AT; maxngaytra = bllquydinh.layQuyDinh("So Ngay Muon Toi Da"); // 3 paymtratre = bllquydinh.layQuyDinh("Tien Phat"); // 1 feethuesach = bllquydinh.layQuyDinh("Tien Muon Sach"); // 2 paymboithuong = bllquydinh.layQuyDinh("Tien Boi Thuong"); // 4 numngaytratre = DateTime.Now.Subtract(datemuonsach).Days - maxngaytra; numngaytratre = (numngaytratre > 0 ? numngaytratre : 0); dtots.SONGAYTRE += numngaytratre; dtots.TIENTRE += numngaytratre * paymtratre; dtots.TIENBOITHUONG += ishong * paymboithuong; dtots.TIENTHUESACH += feethuesach; dtots.TONGTIEN = dtots.TIENTRE + dtots.TIENBOITHUONG + dtots.TIENTHUESACH; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public PL_Payment(DTO_TRASACH dtots) { InitializeComponent(); ttbPhiThue.Text = dtots.TIENTHUESACH.ToString(); ttbTienPhat.Text = dtots.TIENTRE.ToString(); ttbTienBoiThuong.Text = dtots.TIENBOITHUONG.ToString(); ttbTongTien.Text = dtots.TONGTIEN.ToString(); }
public void khoiTao_DoiTuongTraSach(ref DTO_TRASACH dtots) { dtots.NGAYTRA = DateTime.Today.Date.ToString("yyyy-MM-dd"); dtots.CREATED_AT = DateTime.Now; dtots.SONGAYTRE = 0; dtots.TIENTRE = 0; dtots.TIENBOITHUONG = 0; dtots.TIENTHUESACH = 0; dtots.TONGTIEN = 0; }
public void tra_Sach(List <int> lsidsach) { DTO_TRASACH dtotrasach = new DTO_TRASACH() { ID_USER = Int32.Parse(ttbMaDocGia.Text) }; bllphieuts.themPhieuTraSach(ref dtotrasach, lsidsach); ttbSoNgayTT.Text = dtotrasach.SONGAYTRE.ToString(); ttbNgayTra.Text = DateTime.Now.Date.ToString(); }
public bool themPhieuTraSach(ref DTO_TRASACH dtots, List <int> lsmasach) { BLL_PhieuMuonSach bllphieums = new BLL_PhieuMuonSach(); khoiTao_DoiTuongTraSach(ref dtots); foreach (int idsach in lsmasach) { tra_TungSach(ref dtots, idsach); themCTP_TraSach(idsach); bllphieums.suaCTP_MuonSach(dtots.ID_USER, idsach); } bllphieums.tongKet_MuonSach(dtots.ID_USER); return(dalphieuts.themPhieuTraSach(dtots)); }
public int themPhieuTraSach(DTO_TRASACH dtophieuts) { try { _conn.Open(); string sqlthem = "", sqllay = ""; sqlthem = string.Format("INSERT INTO TRASACH (ID_USER, NGAYTRA, SONGAYTRE," + " TIENTRE, TIENBOITHUONG, TIENTHUESACH, TONGTIEN, CREATED_AT)" + " VALUES( {0}, '{1}', {2}, {3}, {4}, {5}, {6}, '{7}' )", dtophieuts.ID_USER, dtophieuts.NGAYTRA, dtophieuts.SONGAYTRE, dtophieuts.TIENTRE, dtophieuts.TIENBOITHUONG, dtophieuts.TIENTHUESACH, dtophieuts.TONGTIEN, dtophieuts.CREATED_AT.ToString("yyyy-MM-dd hh:mm:ss")); MySqlCommand cmdthem = new MySqlCommand(sqlthem, _conn); if (cmdthem.ExecuteNonQuery() > 0) { sqllay = string.Format("SELECT ID FROM TRASACH WHERE ID_USER = {0} AND CREATED_AT = '{1}'", dtophieuts.ID_USER, dtophieuts.CREATED_AT.ToString("yyyy-MM-dd hh:mm:ss")); MySqlDataAdapter sda = new MySqlDataAdapter(sqllay, _conn); DataTable dtsacht = new DataTable(); sda.Fill(dtsacht); return(Int32.Parse(dtsacht.Rows[0]["id"].ToString())); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { _conn.Close(); } return(-1); }
public bool themPhieuTraSach(ref DTO_TRASACH dtots, List <int> lsmasach, int ctrltinhieu) { BLL_Sach bllsach = new BLL_Sach(); BLL_PhieuMuonSach bllphieums = new BLL_PhieuMuonSach(); int idtrasach = 0, numsachhong = dtots.TIENBOITHUONG; khoiTao_DoiTuongTraSach(ref dtots); foreach (int idsach in lsmasach) { int ishong = (numsachhong-- > 0 ? 1 : 0); tra_TungSach(ref dtots, idsach, ishong); } if (ctrltinhieu == 1) { return(true); } idtrasach = dalphieuts.themPhieuTraSach(dtots); if (idtrasach > -1) { foreach (int idsach in lsmasach) { themCTP_TraSach(idtrasach, idsach); bllsach.suaTinhTrangSach(idsach, "Con Hang"); bllphieums.suaCTP_MuonSach(dtots.ID_USER, idsach); } bllphieums.tongKet_MuonSach(dtots.ID_USER); return(true); } return(false); }