public static bool themDanhBaToDB(DanhBa danhBa)
{
var db = new DanhBaDbContext();
db.DanhBaDbSet.Add(danhBa);
db.SaveChanges();
return(true);
}
public static bool themNhomToDB(Nhom nhom)
{
var db = new DanhBaDbContext();
db.NhomDbSet.Add(nhom);
db.SaveChanges();
return(true);
}
public static bool xoaDanhBaFromDB(string sdt)
{
var db = new DanhBaDbContext();
var temp = db.DanhBaDbSet.Where(e => e.sdt == sdt).FirstOrDefault();
db.DanhBaDbSet.Remove(temp);
db.SaveChanges();
return(true);
}
public static bool xoaNhomFromDBByName(string name)
{
var db = new DanhBaDbContext();
var temp = db.NhomDbSet.Where(e => e.tenNhom == name).FirstOrDefault();
if (temp != null)
{
db.NhomDbSet.Remove(temp);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public static bool xoaDanhBaByNhom(string maNhom)
{
var db = new DanhBaDbContext();
List <DanhBa> list = db.DanhBaDbSet.Where(e => e.maNhom == maNhom).ToList();
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
db.DanhBaDbSet.Remove(list.ElementAt(i));
}
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}