private void SuaPhieuMuon_GUI()
{
PhieuMuonDTO phieuMuonDTO = new PhieuMuonDTO();
SachDTO sachDTO = new SachDTO();
TheDocGiaDTO theDG = new TheDocGiaDTO();
GetPhieuMuon_Data_From_GUI(phieuMuonDTO);
theDG.Madg = phieuMuonDTO.Madg;
int flag = 0;
foreach (string ma in ListMaSach)
{
sachDTO.Masach = ma;
bool updateSach = sachBus.UpdateData(sachDTO);
if (updateSach)
{
flag = 1;
}
}
bool result = phieuMuonBus.SuaPhieuMuon(phieuMuonDTO);
bool resultDG = theDGBus.UpdateSoSachMuon(theDG, intTongSoSachDangChon);
if (result && resultDG && flag == 1)
{
//SACH SOLUONG VA LUOT MUON
MessageBox.Show("ĐÃ CẬP NHẬT PHIẾU MƯỢN THÀNH CÔNG!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("ĐÃ CÓ LỖI XẢY RA, VUI LÒNG KIỂM TRA LẠI", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static List <TTPhieuMuonDTO> SelecLendNote(PhieuMuonDTO phieuMuon)
{
string sqlstr = $"EXEC dbo.SelecLendNote '{phieuMuon.Ngaymuon}'";
List <TTPhieuMuonDTO> chiTiet = new List <TTPhieuMuonDTO>();
MySQL.Open();
using (SqlDataReader dataReader = MySQL.ExecuteSQL(sqlstr))
{
while (dataReader.Read())
{
chiTiet.Add(
new TTPhieuMuonDTO(
phieuMuon,
new SachDTO(
new DauSachDTO(
dataReader["dausach"].ToString(),
Int32.Parse(dataReader["songaytoida"].ToString())
),
Int32.Parse(dataReader["stt"].ToString())
),
Int32.Parse(dataReader["phat"].ToString()),
DateTime.TryParse(dataReader["mapt"].ToString(), out DateTime mapt) ? mapt : new DateTime()
)
);
}
}
MySQL.Close();
return(chiTiet);
}
public List <PhieuMuonDTO> ConvertToList(DataTable temp)
{
List <PhieuMuonDTO> ans = new List <PhieuMuonDTO>();
if (temp == null)
{
return(ans);
}
for (int i = 0; i < temp.Rows.Count; ++i)
{
PhieuMuonDTO receipt = new PhieuMuonDTO(temp.Rows[i]);
if (ans.Count == 0)
{
ans.Add(receipt);
}
else if (receipt.Mapm != ans[ans.Count - 1].Mapm)
{
ans.Add(receipt);
}
}
return(ans);
}
private void btnAdd_Click(object sender, EventArgs e)
{
DataGridViewRow dgvRow = dtgrvSachTV.CurrentRow;
int MaSach = (int)dgvRow.Cells[0].Value;
SachBUS sb = new SachBUS();
sb.UpdateRecord(MaSach, true);
ChiTietMuonDTO ctmuon = new ChiTietMuonDTO();
ctmuon.MaSach = MaSach;
ctmuon.NgayTra = dtNgTra.Value;
ChiTietMuonBUS ctmBus = new ChiTietMuonBUS();
ctmBus.Insert(ctmuon);
PhieuMuonDTO phieuMuon = new PhieuMuonDTO();
phieuMuon.MaDocGia = int.Parse(txtMaDG.Text);
phieuMuon.NgayMuon = DateTime.Now;
PhieuMuonBUS pmBus = new PhieuMuonBUS();
pmBus.Insert(phieuMuon);
btnChon_Click(sender, e);
}
public bool them(PhieuMuonDTO item)
{
try
{
con.Open();
string sql = "INSERT INTO PhieuMuon VALUES(@maphieu, @madg, @ngaymuon, @manv)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("maphieu", item.MaPhieuMuon);
cmd.Parameters.AddWithValue("madg", item.MaDocGia);
cmd.Parameters.AddWithValue("ngaymuon", item.NgayMuon);
cmd.Parameters.AddWithValue("manv", item.MaNhanVien);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return(false);
}
public void UpdatePhieuMuon(PhieuMuonDTO phieumuonDTO)
{
var phieumuon = phieumuonRepository.GetBy(phieumuonDTO.MaPM);
phieumuon.TrangThai = 0;
phieumuonRepository.Update(phieumuon);
}
public void CreatePhieuMuon(PhieuMuonDTO phieumuonDTO)
{
var phieumuon = phieumuonDTO.MappingPhieuMuon();
phieumuon.TrangThai = 1;
phieumuonRepository.Add(phieumuon);
}
public static PhieuMuon MappingPhieuMuon(this PhieuMuonDTO pmDTO)
{
if (!(pmDTO.ChiTietPhieuMuons == null))
{
return(new PhieuMuon
{
MaPM = pmDTO.MaPM,
MaDG = pmDTO.MaDG,
NgayMuon = pmDTO.NgayMuon,
TongPhiMuon = pmDTO.TongPhiMuon,
UserId = pmDTO.UserId,
//ChiTietPhieuMuons = pmDTO.ChiTietPhieuMuons
ChiTietPhieuMuons = pmDTO.ChiTietPhieuMuons.MappingCTPMs().ToList()
});
}
else
{
return(new PhieuMuon
{
MaPM = pmDTO.MaPM,
MaDG = pmDTO.MaDG,
NgayMuon = pmDTO.NgayMuon,
TongPhiMuon = pmDTO.TongPhiMuon,
UserId = pmDTO.UserId,
});
}
}
public int ThemPhieuMuon(PhieuMuonDTO PM)
{
int nRow = 0;
try
{
string strSQL = "INSERT INTO PhieuMuonSach VALUES(@MaPM,@NgayMuon,@MaDG,@NgayHetHan)";
provider.Connect();
nRow = provider.ExecuteNonQuery(CommandType.Text, strSQL,
new SqlParameter {
ParameterName = "@MaPM", Value = PM.MaPM
},
new SqlParameter {
ParameterName = "@NgayMuon", Value = PM.NgayMuon
},
new SqlParameter {
ParameterName = "@MaDG", Value = PM.MaDG
},
new SqlParameter {
ParameterName = "@NgayHetHan", Value = PM.NgayHetHan
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(nRow);
}
public bool them(PhieuMuonDTO temp, bool MuonSach)
{
Console.WriteLine("Them the doc gia.");
string query = string.Empty;
if (MuonSach)
{
query += "INSERT INTO[dbo].[tblPhieuMuon]([maPhieu],[maSach],[maDocGia],[ngayMuon],[thoiHang])";
query += " VALUES(@maPhieu,@maSach,@maDocGiam,@ngayMuon,@thoiHang)";
}
else
{
query += "INSERT INTO[dbo].[tblPhieuTra]([maPhieu],[maSach],[maDocGia],[ngayTra])";
query += " VALUES(@maPhieu,@maSach,@maDocGiam,@ngayTra)";
}
Console.WriteLine("Query: " + query);
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
Console.WriteLine("Bat đầu ex query");
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
if (MuonSach)
{
cmd.Parameters.AddWithValue("@maPhieu", temp.MaPhieuMuon);
cmd.Parameters.AddWithValue("@maSach", temp.MaSach);
cmd.Parameters.AddWithValue("@maDocGiam", temp.MaDocGia);
cmd.Parameters.AddWithValue("@ngayMuon", temp.NgayMuon.Year + "-" + temp.NgayMuon.Month + "-" + temp.NgayMuon.Day);
cmd.Parameters.AddWithValue("@thoiHang", temp.ThoiHan);
}
else
{
cmd.Parameters.AddWithValue("@maPhieu", temp.MaPhieuTra);
cmd.Parameters.AddWithValue("@maSach", temp.MaSach);
cmd.Parameters.AddWithValue("@maDocGiam", temp.MaDocGia);
cmd.Parameters.AddWithValue("@ngayTra", temp.NgayTra.Year + "-" + temp.NgayTra.Month + "-" + temp.NgayTra.Day);
}
Console.WriteLine("Ma Ta:" + temp.MaPhieuTra + "ma sach" + temp.MaSach + " Ma doc gia " + temp.MaDocGia);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
Console.WriteLine("ex query thanh cong");
}
catch (Exception ex)
{
con.Close();
Console.WriteLine("ex query that bai");
return(false);
}
}
}
return(true);
}
public void GetInfo_From(PhieuMuonDTO phieuMuon)
{
strMaDG = phieuMuon.Madg;
strNgayMuon = phieuMuon.Ngaymuon.ToShortDateString();
//Tách từng mã sách ra thành 1 list mã sách
ListMaSach = InputChecking.Instance.SeparateWords(phieuMuon.Masach.ToString());
}
private void btnLapPhieu_Click(object sender, EventArgs e)
{
if (STTSach > 1 && txtMaDG.Text != "" && dtgrvPM[1, 0].Value.ToString() != "")
{
if (TinhTrangDG.CompareTo("TTDG01") == 0)
{
DateTime ngayMuon = new DateTime(dtNgayMuon.Value.Year, dtNgayMuon.Value.Month, dtNgayMuon.Value.Day);
DateTime newTime = ngayMuon.AddDays(MaxNgayMuon);
PhieuMuonDTO PhieuMuon = new PhieuMuonDTO();
PhieuMuon.MaPM = txtMaPhieuMuon.Text;
PhieuMuon.NgayMuon = dtNgayMuon.Value;
PhieuMuon.MaDG = txtMaDG.Text;
PhieuMuon.NgayHetHan = newTime;
QuanLyPhieuMuonBUS BUS = new QuanLyPhieuMuonBUS();
int nRow = BUS.ThemPhieuMuon(PhieuMuon);
CT_PhieuMuonDTO CTPM;
for (int i = 0; i < dtgrvPM.RowCount; i++)
{
if (Convert.ToString(dtgrvPM.Rows[i].Cells[1].Value) != "")
{
CTPM = new CT_PhieuMuonDTO();
CTPM.MaPM = txtMaPhieuMuon.Text;
CTPM.MaSach = Convert.ToString(dtgrvPM.Rows[i].Cells[1].Value);
BUS.ThemChiTietPhieuMuon(CTPM);
BUS.CapNhatTinhTrangSach(CTPM.MaSach);
}
}
if (nRow > 0)
{
MessageBox.Show("Lập phiếu mượn thành công", "THÔNG BÁO");
LoadThemThanhCong();
}
else
{
MessageBox.Show("Lập phiếu mượn thất bại", "THÔNG BÁO");
}
}
else
{
MessageBox.Show("Không thể mượn sách vì thẻ độc giả đã hết hạn", "THÔNG BÁO");
return;
}
}
else if (txtMaDG.Text == "")
{
MessageBox.Show("Xin vui lòng nhập mã độc giả", "THÔNG BÁO");
txtMaDG.Focus();
return;
}
else if (STTSach == 1 || dtgrvPM[1, 0].Value.ToString() == "")
{
MessageBox.Show("Vui lòng thêm sách vào phiếu mượn", "THÔNG BÁO");
}
}
public bool XoaPhieuMuon(PhieuMuonDTO phieuMuon)
{
string query = string.Empty;
object[] para = { phieuMuon.Mapm };
query += "DELETE FROM PHIEUMUON WHERE MAPM = @MAPM";
return(dataprovider.excuteNonQuery(query, para));
}
public static int InserLendNote(PhieuMuonDTO phieuMuon)
{
string sqlstr = $"EXEC dbo.InserLendNote '{phieuMuon.Ngaymuon}', '{phieuMuon.Madg.Madg}'";
MySQL.Open();
int numrow = MySQL.ExecuteNonSQL(sqlstr);
MySQL.Close();
return(numrow);
}
/* Phương thức thêm phiếu mượn rồi trả về số dòng thực hiện được
* thêm phiếu mượn trước rồi thêm chi tiết phiếu mượn sau */
public static int AddLendNote(List <TTPhieuMuonDTO> phieuMuons)
{
PhieuMuonDTO phieuMuon = phieuMuons[0].Mapm;
int check = TTPhieuMuonDAO.InserLendNote(phieuMuon);
if (check > 0)
{
return(check + TTPhieuMuonDAO.InserDetailLendNote(phieuMuons));
}
return(0);
}
public bool ThemPhieuMuon(PhieuMuonDTO phieuMuon)
{
string query = string.Empty;
object[] listpara = { phieuMuon.Masach, phieuMuon.Madg, phieuMuon.Ngaymuon, phieuMuon.Hantra, phieuMuon.Soluong, phieuMuon.Mucphat };
query += "INSERT INTO PHIEUMUON(MASACH, MADG, NGAYMUON, HANTRA, SOLUONG, MUCPHAT) ";
query += "VALUES ( @MASACH , @MADG , @NGAYMUON , @HANTRA , @SOLUONG , @MUCPHAT )";
return(dataprovider.excuteNonQuery(query, listpara));
}
public frmTraSach(PhieuMuonDTO selectedreceipt)
{
InitializeComponent();
sachBUS = new SachBUS();
theDGBus = new TheDocGiaBUS();
phieumuonBUS = new PhieuMuonBUS();
phieutraBUS = new PhieuTraBUS();
SelectedReceipt = selectedreceipt;
SelectedBookIDs = new List <string>();
}
public int ThemPhieuMuon(PhieuMuonDTO PM)
{
try
{
QuanLyPhieuMuonDAO DAO = new QuanLyPhieuMuonDAO();
return(DAO.ThemPhieuMuon(PM));
}
catch (SqlException ex)
{
throw ex;
}
}
public static void MappingPhieuMuon(this PhieuMuonDTO pmDTO, PhieuMuon pm)
{
pm.MaPM = pmDTO.MaPM;
pm.MaDG = pmDTO.MaDG;
pm.NgayMuon = pmDTO.NgayMuon;
pm.TongPhiMuon = pmDTO.TongPhiMuon;
pm.UserId = pmDTO.UserId;
//pm.ChiTietPhieuMuons = pmDTO.ChiTietPhieuMuons;
if (pmDTO.ChiTietPhieuMuons != null)
{
pm.ChiTietPhieuMuons = pmDTO.ChiTietPhieuMuons.MappingCTPMs().ToList();
}
}
public List <PhieuMuonDTO> GetMaSach()
{
List <PhieuMuonDTO> list = new List <PhieuMuonDTO>();
string query = "SELECT DISTINCT MaSach FROM dbo.PHIEUMUON ";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
PhieuMuonDTO phieuMuon = new PhieuMuonDTO(item);
list.Add(phieuMuon);
}
return(list);
} //Lấy danh sách mã sách
public frmChiTietPhieuMuon(PhieuMuonDTO phieuMuon)
{
InitializeComponent();
sachBus = new SachBUS();
theDGBus = new TheDocGiaBUS();
GetInfo_From(phieuMuon);
GetTenDG_From_MaDG();
AddSach_Into_ListSach();
SetTenDG_NgayMuon();
LoadDataGirdView_ChiTietPM();
}
public bool SuaPhieuMuon(PhieuMuonDTO phieuMuon)
{
string query = string.Empty;
object[] listpara = { phieuMuon.Masach, phieuMuon.Madg, phieuMuon.Soluong, phieuMuon.Mapm };
query += "UPDATE PHIEUMUON ";
query += "SET MASACH = @MASACH , MADG = @MADG , SOLUONG = @SOLUONG ";
query += " WHERE MAPM = @MAPM";
return(dataprovider.excuteNonQuery(query, listpara));
}
private void cbMaSach_SelectedIndexChanged(object sender, EventArgs e)
{
string id;
ComboBox cb = sender as ComboBox;
if (cb.SelectedItem is null)
{
return;
}
PhieuMuonDTO selected = cb.SelectedItem as PhieuMuonDTO;
id = selected.MaSach;
loadPMTheoMaSach(id);
}
/**
* @param phieuMuon
*/
public void SuaPhieuMuon(PhieuMuonDTO phieuMuon)
{
querry = "update PhieuMuon set MaDocGia=@MaDocGia,NgayMuon=@NgayMuon,MaNhanVien=@MaNhanVien where MaPhieuMuon=@MaPhieuMuon";
connection.Open();
command = new SqlCommand(querry, connection.sqlConnection);
command.Parameters.AddWithValue("MaPhieuMuon", phieuMuon.MaPhieuMuon);
command.Parameters.AddWithValue("MaDocGia", phieuMuon.MaPhieuMuon);
command.Parameters.AddWithValue("NgayMuon", phieuMuon.NgayMuon);
command.Parameters.AddWithValue("MaNhanVien", phieuMuon.MaNhanVien);
command.ExecuteNonQuery();
// TODO implement here
connection.Close();
// TODO implement here
}
/**
* @param phieuMuon
*/
public void ThemPhieuMuon(PhieuMuonDTO phieuMuon)
{
querry = "insert PhieuMuon values(@MaPhieuMuon,@MaDocGia,@NgayMuon,@MaNhanVien)";
connection.Open();
command = new SqlCommand(querry, connection.sqlConnection);
command.Parameters.AddWithValue("MaPhieuMuon", phieuMuon.MaPhieuMuon);
command.Parameters.AddWithValue("MaDocGia", phieuMuon.MaDocGia);
command.Parameters.AddWithValue("NgayMuon", phieuMuon.NgayMuon);
command.Parameters.AddWithValue("MaNhanVien", phieuMuon.MaNhanVien);
command.ExecuteNonQuery();
// TODO implement here
connection.Close();
// TODO implement here
}
private void GetPhieuMuon_Data_From_GUI(PhieuMuonDTO phieuMuonDTO)
{
phieuMuonDTO.Madg = cmbxMaDG_frmMuon.Text.ToString();
phieuMuonDTO.Soluong = intTongSoSachDangChon;
phieuMuonDTO.Ngaymuon = DateTime.Now;
phieuMuonDTO.Hantra = phieuMuonDTO.CalDueDate(Qd);
phieuMuonDTO.Masach = string.Empty;
phieuMuonDTO.Mapm = mapm;
phieuMuonDTO.Mucphat = MucPhat;
foreach (string Ma in ListMaSach)
{
phieuMuonDTO.Masach += (Ma + " ");
}
}
public static void Insert(PhieuMuonDTO PhieuMuon)
{
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Insert into PHIEUMUON(NgayMuon, MaDG) values(?, ?)";
OleDbCommand command = new OleDbCommand(cmdText, connection);
command.Parameters.Add("@NgayMuon", OleDbType.Date);
command.Parameters.Add("@MaDG", OleDbType.Integer);
command.Parameters["@NgayMuon"].Value = PhieuMuon.NgayMuon;
command.Parameters["@MaDG"].Value = PhieuMuon.MaDocGia;
command.ExecuteNonQuery();
command.CommandText = "select @@IDENTITY";
PhieuMuon.MaPhieuMuon = (int)command.ExecuteScalar();
connection.Close();
}
public IActionResult Index(string sortOrder, string searchString, int pageIndex = 1)
{
int pageSize = 8;
int count;
var dsphieumuon = phieuMuonService.GetPhieuMuons(sortOrder, searchString, pageIndex, pageSize, out count);
var phieumuon = new PhieuMuonDTO();
var ctpm = new ChiTietPhieuMuonDTO();
var listSach = sachService.GetSachs(sortOrder, searchString, pageIndex, pageSize, out count);
var phieumuonVM = new PhieuMuonIndexVm()
{
PhieuMuons = new PaginatedList <PhieuMuonDTO>(dsphieumuon, count, pageIndex, pageSize),
SearchString = searchString,
SortOrder = sortOrder,
phieumuon = phieumuon,
ctpm = ctpm
};
return(View(phieumuonVM));
}
public List <PhieuMuonDTO> Select()
{
List <PhieuMuonDTO> ListPhieuMuon = new List <PhieuMuonDTO>();
string query = "SELECT[MAPM],[MASACH],[MADG],[NGAYMUON],[HANTRA] ,[SOLUONG] FROM[PHIEUMUON]";
DataTable DtPhieuMuon = DataProvider.Instance.Excutequery(query);
foreach (DataRow row in DtPhieuMuon.Rows)
{
PhieuMuonDTO phieuMuon = new PhieuMuonDTO();
phieuMuon.NewReceipt(row);
ListPhieuMuon.Add(phieuMuon);
}
return(ListPhieuMuon);
}
public List <PhieuMuonDTO> Select_MaSach_By_MaPhieuMuon(string sKeyword)
{
List <PhieuMuonDTO> ListPhieuMuon = new List <PhieuMuonDTO>();
string query = "SELECT[MAPM],[MASACH],[MADG],[NGAYMUON],[HANTRA] FROM[PHIEUMUON] ";
query += "WHERE MAPM = @sKeyword ";
DataTable DtPhieuMuon = dataprovider.Excutequery(query);
foreach (DataRow row in DtPhieuMuon.Rows)
{
PhieuMuonDTO phieuMuon = new PhieuMuonDTO();
phieuMuon.NewReceipt(row);
ListPhieuMuon.Add(phieuMuon);
}
return(ListPhieuMuon);
}
