public ActionResult updateuser(FormCollection fc)
{
int id = Convert.ToInt32(fc["id"]);
tblUser u = dt.tblUsers.Single(v => v.iD.Equals(id));
u.cUserName = fc["cUserName"].Trim();
if (fc["cPassWord"].Trim() != "")
{
u.cPassWord = func.md5(fc["cPassWord"].Trim());
}
dt.Database.ExecuteSqlCommand("delete from tblUserGroup where iUser="******"nhcc"];
if (danhmuc.Length > 0)
{
foreach (var x in fc["nhcc"].Split(','))
{
if (x != null)
{
quyen.iGroup = Convert.ToInt32(x);
quyen.iUser = id;
dt.tblUserGroups.Add(quyen);
dt.SaveChanges();
}
}
}
dt.SaveChanges();
Response.Write(1);
return(null);
}
public int CreateUserGroup(UserGroupModel UGM)
{
try
{
using (var context = new MCQ_Quiz_DBEntities())
{
tblUserGroup TUG = new tblUserGroup();
TUG.UserId = UGM.UserId;
TUG.QuizId = UGM.QuizId;
TUG.RoleId = UGM.RoleId;
TUG.CreatedON = UGM.CreatedON;
TUG.UpdatedON = UGM.UpdatedON;
context.tblUserGroups.Add(TUG);
context.SaveChanges();
return(TUG.UserGrpId);
}
}
catch (Exception)
{
return(0);
}
}
public ActionResult RevokeUser(int GroupId, string UserId)
{
tblUserGroup tblUserGroups = db.tblUserGroup.FirstOrDefault(s => s.FK_Group == GroupId && s.FK_User == UserId);
if (tblUserGroups != null)
{
db.tblUserGroup.Remove(tblUserGroups);
db.SaveChanges();
}
return(RedirectToAction("Details", new { id = GroupId }));
}
public ActionResult AddGroup(int GroupId, string UserId)
{
tblUserGroup tblUserGroups = new tblUserGroup()
{
FK_Group = GroupId,
FK_User = UserId
};
if (tblUserGroups != null)
{
db.tblUserGroup.Add(tblUserGroups);
db.SaveChanges();
}
return(RedirectToAction("Details", new { id = UserId }));
}
public SavingResult DeleteRecord(long DeleteID)
{
SavingResult res = new SavingResult();
using (dbVisionEntities db = new dbVisionEntities())
{
if (DeleteID != 0)
{
tblUserGroup RecordToDelete = db.tblUserGroups.FirstOrDefault(r => r.UserGroupID == DeleteID);
if (RecordToDelete == null)
{
res.ValidationError = "Selected record not found. May be it has been deleted by another User over network.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else
{
//db.tblUserGroupPerimissions.RemoveRange(db.tblUserGroupPerimissions.Where(r => r.UserGroupID == RecordToDelete.UserGroupID));
//db.tblUserGroups.Remove(RecordToDelete);
byte RecordState_Deleted = (byte)eRecordState.Deleted;
RecordToDelete.rstate = RecordState_Deleted;
db.tblUserGroups.Attach(RecordToDelete);
db.Entry(RecordToDelete).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
}
return(res);
}
public SavingResult SaveNewRecord(tblUserGroup SaveModel, List <MenuOptionPermissionViewModel> Permissions, List <Model.Settings.CompanyMultiSelectLookupModel> Companies, List <LocationUserGroupAccessMultiSelectListModel> Location)
{
SavingResult res = new SavingResult();
//--
using (dbVisionEntities db = new dbVisionEntities())
{
if (SaveModel.UserGroupName == "")
{
res.ValidationError = "Can not accept blank value. The User Group Name is required.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else if (IsDuplicateRecord(SaveModel.UserGroupName, SaveModel.UserGroupID, db))
{
res.ValidationError = "Can not accept duplicate value. The User Group Name is already exists.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
else if (SaveModel.SuperAdminGroup)
{
res.ValidationError = "Can not add/edit super admin group.";
res.ExecutionResult = eExecutionResult.ValidationError;
return(res);
}
if (SaveModel.UserGroupID == 0) // New Entry
{
SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.rcdt = DateTime.Now;
db.tblUserGroups.Add(SaveModel);
}
else
{
SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID;
SaveModel.redt = DateTime.Now;
db.tblUserGroups.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
db.tblUserGroupPerimissions.RemoveRange(db.tblUserGroupPerimissions.Where(r => r.UserGroupID == SaveModel.UserGroupID));
db.tblUserGroupPermissionOnCompanies.RemoveRange(db.tblUserGroupPermissionOnCompanies.Where(r => r.UserGroupID == SaveModel.UserGroupID));
db.tblUserGroupPermissionOnLocations.RemoveRange(db.tblUserGroupPermissionOnLocations.Where(r => r.UserGroupID == SaveModel.UserGroupID));
}
db.tblUserGroupPerimissions.AddRange(Permissions.Select(r => new tblUserGroupPerimission()
{
tblUserGroup = SaveModel,
MenuOptionID = r.MenuOptionID,
CanRead = r.CanView,
CanAdd = (r.MenuOptionType == Model.Settings.eMenuOptionType.CRUD && r.CanAdd),
CanEdit = (r.MenuOptionType == Model.Settings.eMenuOptionType.CRUD && r.CanEdit),
CanDelete = (r.MenuOptionType == Model.Settings.eMenuOptionType.CRUD && r.CanDelete),
CanAuthorize = (r.MenuOptionType == Model.Settings.eMenuOptionType.CRUD && r.CanAuthorize),
CanUnAuthorize = (r.MenuOptionType == Model.Settings.eMenuOptionType.CRUD && r.CanUnAuthorize),
rcdt = SaveModel.rcdt,
redt = SaveModel.redt,
rcuid = SaveModel.rcuid,
reuid = SaveModel.reuid,
}));
db.tblUserGroupPermissionOnCompanies.AddRange(Companies.Where(r => r.Selected).Select(r => new tblUserGroupPermissionOnCompany()
{
tblUserGroup = SaveModel,
CompanyID = r.CompanyID,
}));
db.tblUserGroupPermissionOnLocations.AddRange(Location.Where(r => r.Selected).Select(r => new tblUserGroupPermissionOnLocation()
{
tblUserGroup = SaveModel,
LocationID = r.LocationID,
}));
//--
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.UserGroupID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
CommonFunctions.GetFinalError(res, ex);
}
}
return(res);
}
