public ActionResult Edit(UserGroupViewModel model)
{
ViewBag.Role = _userGrDao.ListAllRole();
if (ModelState.IsValid)
{
var userGr = new USERGROUP();
userGr.ID = model.ID;
userGr.Name = model.Name;
var result = _userGrDao.Update(userGr);
if (result == -1)
{
ModelState.AddModelError("", "Tên đã tồn tại");
}
else if (result == 1)
{
new CredentialDao().Update(userGr, model.Role);
SetAlert("Cập nhật thành công", "success");
return(RedirectToAction("Index", "UserGroup"));
}
else
{
ModelState.AddModelError("", "Cập nhật thất bại");
}
}
return(View(model));
}
public ActionResult Create(UserGroupViewModel model)
{
ViewBag.Role = _userGrDao.ListAllRole();
try
{
if (ModelState.IsValid)
{
var userGr = new USERGROUP();
userGr.ID = StringHelper.ToUnsignString(model.Name);
userGr.Name = model.Name;
int id = _userGrDao.Insert(userGr);
if (id == -1)
{
ModelState.AddModelError("", "Tên đã tồn tại");
}
else if (id == 1)
{
new CredentialDao().Create(userGr, model.Role);
SetAlert("Thêm thành công", "success");
return(RedirectToAction("Index", "UserGroup"));
}
else
{
ModelState.AddModelError("", "Thêm thất bại");
}
}
return(View(model));
}
catch
{ return(View()); }
}
public void Create(USERGROUP userGroup, string Role)
{
if (!string.IsNullOrEmpty(Role))
{
foreach (var role in Role.Split(','))
{
this.Insert(role, userGroup.ID);
}
}
}
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr)
{
USERGROUP theEntity = new USERGROUP();
theEntity.USERGROUPID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty;
theEntity.GROUPID = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty;
theEntity.USERID = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty;
return(theEntity);
}
public void Update(USERGROUP userGroup, string Role)
{
this.RemoveAllCredential(userGroup.ID);
if (!string.IsNullOrEmpty(Role))
{
foreach (var role in Role.Split(','))
{
this.Insert(role, userGroup.ID);
}
}
}
public int Insert(USERGROUP entity)
{
if (db.USERGROUP.Any(x => x.Name == entity.Name))
{
return(-1);
}
try
{
db.USERGROUP.Add(entity);
db.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
public int Update(USERGROUP entity)
{
if (db.USERGROUP.Any(x => x.Name == entity.Name && x.ID != entity.ID))
{
return(-1);
}
var UserGroup = db.USERGROUP.Find(entity.ID);
try
{
UserGroup.Name = entity.Name;
db.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
USERGROUP theEntity = (USERGROUP)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.USERGROUPID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("userGROUP_ID", theEntity.USERGROUPID));
}
if (!string.IsNullOrEmpty(theEntity.USERID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("user_id", theEntity.USERID));
}
if (!string.IsNullOrEmpty(theEntity.GROUPID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("group_ID", theEntity.GROUPID));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
