public bool Insert(DataGridView dataGrid, string MaSach, string MaLoaiSach, string MaTacGia, string TenSach, string NgayNhap,
string NhaXB, string NamXB, string GiaSach, string TinhTrang)
{
try
{
Models.Sach sach = new Models.Sach()
{
MaSach = MaSach,
MaLoaiSach = MaLoaiSach,
MaTacGia = MaTacGia,
TenSach = TenSach,
NgayNhap = NgayNhap,
NhaXB = NhaXB,
NamXB = NamXB,
GiaSach = int.Parse(GiaSach),
TinhTrangMuon = TinhTrang,
};
string[] parameters = { "MaSach", "MaLoaiSach", "MaTacGia", "TenSach", "NgayNhap",
"NhaXB", "NamXB", "GiaSach", "TinhTrangMuon" };
string[] values = { sach.MaSach, sach.MaLoaiSach, sach.MaTacGia, sach.TenSach, sach.NgayNhap, sach.NhaXB,
sach.NamXB, sach.GiaSach.ToString(), sach.TinhTrangMuon };
MSS.crud.Insert("SACH", parameters, values);
GetAllSach(dataGrid);
return(true);
}
catch (Exception err)
{
Utils.MSG(err.Message);
return(false);
}
}
public bool Delete(DataGridView dataGrid, string MaSach)
{
try
{
Models.Sach sach = new Models.Sach()
{
MaSach = MaSach,
};
string[] where = { "MaSach" };
string[] whereValues = { sach.MaSach };
MSS.crud.Delete("SACH", where, whereValues);
GetAllSach(dataGrid);
return(true);
}
catch (Exception err)
{
Utils.MSG(err.Message);
return(false);
}
}
