public bool CapNhatBanSao(string maBanSao, TextBox txtMaSach, TextBox txtMaBanSao, ComboBox cbTrangThai)
{
BanSao banSao = new BanSao();
banSao.MaBanSao = txtMaBanSao.Text;
banSao.MaSach = txtMaSach.Text;
banSao.TrangThai = (ETrangThai)(Convert.ToInt16(cbTrangThai.ValueMember));
return(true);
}
public bool CapNhatBanSao(BanSao banSao)
{
using (QLThuVienEntities ThuVienDS = new QLThuVienEntities())
{
var bSao = ThuVienDS.BanSaos.Find(banSao.MaBanSao);
bSao = banSao;
ThuVienDS.SaveChanges();
}
return(true);
}
public bool ThemBanSao(TextBox txtMaSach, TextBox txtSoLuongBS)
{
int maBanSao = Convert.ToInt16(banSaoDAL.LayMaBanSaoMax(txtMaSach.Text));
List <BanSao> listBanSao = new List <BanSao>();
int soLuong = Convert.ToInt16(txtSoLuongBS.Text);
for (int i = 0; i < soLuong; i++)
{
BanSao banSao = new BanSao();
banSao.MaSach = txtMaSach.Text;
maBanSao = +i + 1;
banSao.MaBanSao = maBanSao.ToString();
banSao.TrangThai = ETrangThai.CoSan;
listBanSao.Add(banSao);
}
banSaoDAL.ThemBanSao(listBanSao);
return(true);
}
public List <BanSao> TimKiemBanSao(BanSao banSao)
{
using (QLThuVienEntities ThuVienDS = new QLThuVienEntities())
{
var listBanSao = from bSao in ThuVienDS.BanSaos select bSao;
if (banSao.MaBanSao != "none")
{
listBanSao = listBanSao.Where <BanSao>(c => c.MaBanSao.Contains(banSao.MaBanSao));
}
if (banSao.Sach.TenSach != "none")
{
listBanSao = listBanSao.Where <BanSao>(c => c.Sach.TenSach.Contains(banSao.Sach.TenSach));
}
if (banSao.TrangThai != ETrangThai.None)
{
listBanSao = listBanSao.Where <BanSao>(c => c.TrangThai == banSao.TrangThai);
}
return(listBanSao.ToList());
}
}
public bool ThemPhieuMuon(TextBox txtMaPhieuMuon, TextBox txtMaNguoiMuon, ComboBox cbThuThu, DataGridView dgvListBanSao, TextBox txtTienCoc)
{
PhieuMuonSach phieuMuon = new PhieuMuonSach();
phieuMuon.MaPhieuMuon = txtMaPhieuMuon.Text;
phieuMuon.MaNguoiMuon = txtMaNguoiMuon.Text;
phieuMuon.MaThuThu = cbThuThu.ValueMember;
phieuMuon.NgayMuonSach = DateTime.Now.Date;
phieuMuon.HanTraSach = phieuMuon.NgayMuonSach.AddDays(20).Date;
for (int i = 0; i < dgvListBanSao.RowCount; i++)
{
BanSao banSao = new BanSao();
banSao.MaBanSao = dgvListBanSao.Rows[i].Cells[0].ToString();
phieuMuon.BanSaos.Add(banSao);
}
decimal tienCoc = decimal.Parse(txtTienCoc.Text, System.Globalization.NumberStyles.AllowThousands);
phieuMuon.TienDatCoc = Math.Round(Convert.ToDecimal(txtTienCoc.Text), 0);
phieuMuonDAL.ThemPhieuMuon(phieuMuon);
return(true);
}
