public void UpdateCTS(CTSACH cs, PHIEUMUONSACH pms)
{
using (QLTVEntities db = new QLTVEntities())
{
CTSACH c = db.CTSACH.FirstOrDefault(x => x.MACTS == cs.MACTS);
PHIEUMUONSACH d = db.PHIEUMUONSACH.FirstOrDefault(x => x.MAPMS == pms.MAPMS);
c.MATT = cs.MATT;
c.PHIEUMUONSACH.Add(d);
d.CTSACH.Add(c);
db.SaveChanges();
}
}
public bool ChangeAvartar(string path)
{
using (QLTVEntities db = new QLTVEntities())
{
var d = db.TAIKHOAN.FirstOrDefault(x => x.MATK == User.MATK);
if (d != null)
{
d.HINHANH = path;
db.SaveChanges();
return(true);
}
}
return(false);
}
public bool Create <T>(T dto) where T : class
{
using (QLTVEntities db = new QLTVEntities())
{
try
{
db.Set <T>().Add(dto);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(false);
}
}
}
public bool Update <T>(T dto, Expression <Func <T, bool> > currentEntityFilter) where T : class
{
using (QLTVEntities db = new QLTVEntities())
{
try
{
var current = db.Set <T>().FirstOrDefault(currentEntityFilter);
if (current is null)
{
return(false);
}
db.Entry(current).CurrentValues.SetValues(dto);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public bool Delete <T>(Expression <Func <T, bool> > currentEntityFilter) where T : class
{
using (QLTVEntities db = new QLTVEntities())
{
try
{
var current = db.Set <T>().FirstOrDefault(currentEntityFilter);
if (current is null)
{
return(false);
}
db.Set <T>().Remove(current);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(false);
}
}
}