public bool Save(object dataBoundItem)
{
if (dataBoundItem is MuonTB ob)
{
var db = new dbQLTSEntities();
if (ob.IDMuonTB <= 0)
{
ob.CreateBy = COMMON.User.IDAccount;
ob.CreateTime = DateTime.Now;
ob.Status = false;
db.MuonTBs.Add(ob);
}
else
{
var obj = db.MuonTBs.ToList().FirstOrDefault(q => q.IDMuonTB == ob.IDMuonTB);
if (obj is MuonTB)
{
db.Entry(obj).CurrentValues.SetValues(ob);
}
else
{
return(false);
}
}
db.SaveChanges();
return(true);
}
return(false);
}
public object Search(string sKey)
{
var acc = new dbQLTSEntities().Accounts.ToList().Where(q => q.FullName.Contains(sKey)).Select(q => q.IDAccount).ToList();
return(new BindingList <MuonTB>(new dbQLTSEntities().MuonTBs.ToList()
.Where(q => q.Account.FullName.Contains(sKey) ||
acc.Any(a => a == q.IDAccount || a == q.CreateBy) ||
q.Account.FullName.Contains(sKey) ||
q.Account.FullName.Contains(sKey) ||
q.CreateTime.ToString().Contains(sKey) ||
q.TimeEnd.ToString().Contains(sKey) ||
q.TimeStart.ToString().Contains(sKey) ||
q.IDMuonTB.ToString().Contains(sKey) ||
q.Note.Contains(sKey)
).ToList()));
}
public bool Delete(object dataBoundItem)
{
if (dataBoundItem is MuonTB muontb)
{
var db = new dbQLTSEntities();
if (db.MuonTBs.ToList().FirstOrDefault(q => q.IDMuonTB == muontb.IDMuonTB) is MuonTB value)
{
var ct = value.CTMuonTBs.ToArray();
foreach (var item in ct)
{
db.CTMuonTBs.Remove(item);
}
db.MuonTBs.Remove(value);
return(db.SaveChanges() > 0);
}
else
{
throw new Exception("Vui lòng reload");
}
}
return(false);
}