/// <summary>
/// Author: Phạm Huy Hùng
/// Todo: cập nhật đối tượng
/// </summary>
/// <param name=""></param>
/// <returns></returns>\
public void Update(TblUserGroup o)
{
try
{
using (TkSchoolDbContext db = new TkSchoolDbContext())
{
var res = db.TblUserGroups.Where(x => x.Id == o.Id).SingleOrDefault();
res.Username = o.Username;
res.GroupId = o.GroupId;
res.Status = o.Status;
db.SaveChanges();
}
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
throw new Exception("TblUserGroup::Update::" + ex.Message);
}
else
{
throw new Exception("TblUserGroup::Update::" + ex.InnerException.Message);
}
}
}
/// <summary>
/// Author: Phạm Huy Hùng
/// Todo: tìm kiếm đối tượng theo khóa chính
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public TblUserGroup FindById(TblUserGroup obj)
{
try
{
using (TkSchoolDbContext db = new TkSchoolDbContext())
{
return(db.TblUserGroups.SingleOrDefault(x => x.Id == obj.Id));
}
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
throw new Exception("TblUserGroup::FindById::" + ex.Message);
}
else
{
throw new Exception("TblUserGroup::FindById::" + ex.InnerException.Message);
}
}
}
/// <summary>
/// Author: Phạm Huy Hùng
/// Todo: tạo đối tượng mới
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public void Create(TblUserGroup o)
{
try
{
using (TkSchoolDbContext db = new TkSchoolDbContext())
{
db.TblUserGroups.Add(o);
db.SaveChanges();
}
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
throw new Exception("TblUserGroup::Create::" + ex.Message);
}
else
{
throw new Exception("TblUserGroup::Create::" + ex.InnerException.Message);
}
}
}
/// <summary>
/// Author: Phạm Huy Hùng
/// Todo: xóa đối tượng
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public void Delete(TblUserGroup o)
{
try
{
using (TkSchoolDbContext db = new TkSchoolDbContext())
{
var res = db.TblUserGroups.Where(x => x.Id == o.Id).SingleOrDefault();
db.TblUserGroups.Remove(res);
db.SaveChanges();
}
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
throw new Exception("TblUserGroup::Delete::" + ex.Message);
}
else
{
throw new Exception("TblUserGroup::Delete::" + ex.InnerException.Message);
}
}
}
