public ActionResult Create(RoleDataModel role)
{
RoleBO.GetInstance().Create(role);
if (Session["roleParentID"] != null)
{
return(RedirectToAction("Index", new { id = Convert.ToInt32(Session["roleParentID"]) }));
}
else
{
return(RedirectToAction("Index"));
}
}
public async Task <ActionResult> RoleDataEdit(string id, string sessionid)
{
ViewBag.SessionID = sessionid;
Authenticate();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RoleDataModel roleDataModel = await roleDataDbContext.RoleDataDbSet.Where(model => model.rolename.Equals(id)).FirstOrDefaultAsync();
if (roleDataModel == null)
{
return(HttpNotFound());
}
return(View(roleDataModel));
}
public override void Create(RoleDataModel role)
{
if (!SecurityManager.SesionStarted())
{
throw new Exception("Session not started");
}
role.CreatedBy = SecurityManager.GetLoggedUser().ID;
role.DateCreated = DateTime.Now;
if (HttpContext.Current.Session["roleParentID"] != null)
{
role. = Convert.ToInt32(HttpContext.Current.Session["roleParentID"]);
}
base.Create(role);
}
private async Task <BaseModel> Insert(RoleDataModel model)
{
var existingData = _unitOfWork.RoleRepository.FindAllBy(c => c.RoleName == model.RoleName);
if (existingData != null)
{
existingData = null;
return(new BaseModel {
Id = 0, Status = false, Messsage = UMessagesInfo.RecordExist
});
}
existingData = null;
var _date = await _unitOfWork.RoleRepository.Insert(model);
return(new BaseModel {
Id = _date.Id, Status = true, Messsage = UMessagesInfo.RecordSaved
});
}
public static List <RoleDataModel> GetBy(int id)
{
List <RoleDataModel> roles = new List <RoleDataModel>();
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_GetRolesBy", connection);
MySqlParameter paramID = new MySqlParameter("pID", id);
paramID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramID);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable results = new DataTable();
adapter.Fill(results);
foreach (DataRow item in results.Rows)
{
RoleDataModel role = new RoleDataModel();
if (item["ID"].GetType() != typeof(DBNull))
{
role.ID = Convert.ToInt32(item["ID"]);
}
if (item["Name"].GetType() != typeof(DBNull))
{
role.Name = Convert.ToString(item["Name"]);
}
if (item["DateCreated"].GetType() != typeof(DBNull))
{
role.DateCreated = Convert.ToDateTime(item["DateCreated"]);
}
if (item["CreatedBy"].GetType() != typeof(DBNull))
{
role.CreatedBy = Convert.ToInt32(item["CreatedBy"]);
}
roles.Add(role);
}
return(roles);
}
//public void ResgistShowRoleProperty(Action<string> showRoleProperty)
//{
// this.showRoleProperty = showRoleProperty;
//}
public void QueryRoleList(string roleInfo)
{
List <SysRoleModel> roleList = bllRole.GetModelByRoleInfo(roleInfo);
ViewDataManager.ROLEVIEWDATA.RoleListData.Clear();
if (roleList == null)
{
return;
}
foreach (SysRoleModel role in roleList)
{
RoleDataModel roleModel = new RoleDataModel();
roleModel.角色名称 = role.SysRole_Name;
roleModel.角色备注 = role.SysRole_Remark;
roleModel.角色描述 = role.SysRole_Desc;
roleModel.角色等级 = role.SysRole_Level;
ViewDataManager.ROLEVIEWDATA.RoleListData.Add(roleModel);
}
}
public async Task <ActionResult> RoleDataEdit(RoleDataModel roleDataModel, string sessionid)
{
ViewBag.SessionID = sessionid;
Authenticate();
try
{
if (ModelState.IsValid)
{
roleDataDbContext.Entry(roleDataModel).State = EntityState.Modified;
await roleDataDbContext.SaveChangesAsync();
return(RedirectToAction("RoleDataIndex", new { sessionid = ViewBag.SessionID }));
}
}
catch
{
Response.Write("<script>alert('Server Error!!');</script>");
ViewBag.errormssg = "Server Error!!";
}
return(View(roleDataModel));
}
/// <summary>
/// Function for Insert and Update records
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <BaseModel> SaveAsync(RoleViewModel model)
{
RoleDataModel roleModel = new RoleDataModel
{
Id = model.Id,
CreatedBy = model.CreatedBy,
UpdatedBy = model.UpdatedBy,
Description = model.Description,
IsActive = model.IsActive,
RoleColor = model.RoleColor,
RoleName = model.RoleName
};
if (model.Id > 0)
{
return(await Update(roleModel));
}
else
{
return(await Insert(roleModel));
}
}
public async Task <JsonResult> RoleDataDelete(string rolename, string sessionid)
{
ViewBag.SessionID = sessionid;
Authenticate();
try
{
if (rolename != null)
{
RoleDataModel roleDataModel = await roleDataDbContext.RoleDataDbSet.Where(model => model.rolename.Equals(rolename)).FirstOrDefaultAsync();
roleDataDbContext.RoleDataDbSet.Remove(roleDataModel);
await roleDataDbContext.SaveChangesAsync();
return(Json("success"));
}
}
catch
{
return(Json("fail"));
}
return(Json("fail"));
}
public static List <RoleDataModel> GetAll()
{
List <RoleDataModel> roles = new List <RoleDataModel>();
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_GetRoles", connection);
DataTable results = new DataTable();
adapter.Fill(results);
foreach (DataRow item in results.Rows)
{
RoleDataModel role = new RoleDataModel();
if (item["ID"].GetType() != typeof(DBNull))
{
role.ID = Convert.ToInt32(item["ID"]);
}
if (item["Name"].GetType() != typeof(DBNull))
{
role.Name = Convert.ToString(item["Name"]);
}
if (item["DateCreated"].GetType() != typeof(DBNull))
{
role.DateCreated = Convert.ToDateTime(item["DateCreated"]);
}
if (item["CreatedBy"].GetType() != typeof(DBNull))
{
role.CreatedBy = Convert.ToInt32(item["CreatedBy"]);
}
roles.Add(role);
}
return(roles);
}
public virtual void Create(RoleDataModel role)
{
RoleDAL.Create(role);
}
private void RegisterUser()
{
List<RoleDataModel> userRoles = new List<RoleDataModel>();
RoleDataService rService = new RoleDataService();
GroupDataModel group = null;
RoleDataModel role;
UserRole selectedRole;
if (_ViewModel.IsTeacher)
selectedRole = UserRole.Teacher;
else
selectedRole = UserRole.Student;
role = rService.GetRole(selectedRole);
if (role != null)
{
userRoles.Add(role);
}
// such role not exist in db? - create it!
else
{
role = new RoleDataModel();
role.Role = selectedRole;
if (selectedRole == UserRole.Student)
{
role.Name = "Student";
GroupDataService gService = new GroupDataService();
group = gService.GetGroup(_ViewModel.SelectedGroup);
if (group == null)
{
group = gService.CreateGroup(_ViewModel.SelectedGroup);
}
}
else
{
role.Name = "Teacher";
}
rService.Add(role);
userRoles.Add(rService.GetRole(selectedRole));
}
// adding group to UserDM if registering student
if (selectedRole == UserRole.Student)
{
GroupDataService gService = new GroupDataService();
group = gService.GetGroup(_ViewModel.SelectedGroup);
if (group == null)
{
group = gService.CreateGroup(_ViewModel.SelectedGroup);
}
}
// create new user object for write to db
UserDataModel newUser = new UserDataModel
{
Username = _ViewModel.Username,
Email = _ViewModel.Email,
Password = Authentication.HashPassword(_ViewModel.Password),
FirstName = _ViewModel.Name,
LastName = _ViewModel.Surname,
MiddleName = _ViewModel.MiddleName,
Group = group,
Roles = userRoles
};
UserDataService uService = new UserDataService();
uService.Add(newUser);
MessageBox.Show(Messages.RegisterSuccessfull, Messages.CaptionRegistered);
this.Close();
}
