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(); }