public ActionResult Action(webpages_Roles objSubmit)
{
if (objSubmit.RoleId == 0)
{
objSubmit.DateCreated = DateTime.Now;
objSubmit.DateUpdated = DateTime.Now;
objSubmit.IsDeleted = false;
objSubmit.IsShow = true;
userRoleRepository.Add(objSubmit);
}
else
{
var obj = userRoleRepository.GetById <webpages_Roles>(objSubmit.RoleId);
UpdateModel(obj);
objSubmit.DateUpdated = DateTime.Now;
userRoleRepository.Update(obj);
}
return(Json(new
{
Error = false
}, JsonRequestBehavior.AllowGet));
}
/**
* Retorna true se o privilégio do usuário logado é de vendedor da ATOS
*/
public static bool isAtosRoleVendedor(string token)
{
webpages_Users user = GetUser(token);
if (user == null)
{
return(false);
}
using (var _db = new painel_taxservices_dbContext())
{
_db.Configuration.ProxyCreationEnabled = false;
webpages_Roles role = _db.webpages_UsersInRoles
.Where(r => r.UserId == user.id_users)
.Where(r => r.RoleId > 50)
.Select(r => r.webpages_Roles)
.FirstOrDefault();
if (role == null)
{
return(false);
}
return(role.RoleLevel >= 0 && role.RoleLevel <= 2 && role.RoleName.ToUpper().Equals("COMERCIAL"));
}
}
public void UpdateRole(webpages_Roles roleInput)
{
if (ModelState.IsValid)
{
try
{
var repo = new Durandal2UserMaintContext();
var role =
(from v in repo.webpages_Roles where v.RoleId == roleInput.RoleId select v).FirstOrDefault();
if (role != null)
{
role.RoleName = roleInput.RoleName;
repo.SaveChanges();
}
else
{
throw new Exception("Role to update not found");
}
}
catch (Exception)
{
throw;
}
}
else
{
string errors = ModelState.Values.SelectMany(modelState => modelState.Errors).Aggregate(string.Empty, (current, error) => current + (error.ErrorMessage + Environment.NewLine));
throw new Exception(errors);
}
}
public ActionResult Details(int id = 0)
{
UserProfile up = new UserProfile();
try
{
//Check Authorization
string roleName = System.Web.Security.Roles.GetRolesForUser().Single();
if (roleName.ToUpper() == "USER")
{
return(RedirectToAction("login", "account"));
}
up = db.tbl_UserProfile.Find(id);
webpages_UsersInRoles wr = db.tbl_webpages_UsersInRoles.Find(up.UserId);
webpages_Roles r = db.tbl_webpages_Roles.Find(wr.RoleId);
up.RoleId = wr.RoleId;
up.RoleName = r.RoleName;
if (up == null)
{
return(HttpNotFound());
}
}
catch (Exception e)
{
ExceptionHandler handler = new ExceptionHandler();
handler.HandleException(e);
}
return(View(up));
}
public String GetRole(string username, string pass)
{
USER_PASSWORD id = (from u in data.USER_PASSWORD where u.USER_NAME.Equals(username) && u.PASSWORD.Equals(pass) select u).First();
webpages_Roles role = data.webpages_Roles.Where(r => r.USER_PASSWORD.Any(u => u.USER_NAME.Equals(username) && u.PASSWORD.Equals(pass))).First();
return(role.RoleName);
}
private void AsignUserRoles(CGDataEntities.CGWebEntities webEntities)
{
SimpleRoleProvider provider = new SimpleRoleProvider();
List <int> roleKeyList = _usersInRoles.Select(T => T.Value).Distinct().ToList();
foreach (int roleKey in roleKeyList)
{
string roleName = _roles[roleKey];
int[] usersInRoleIndexes = _usersInRoles.Where(kv => kv.Value.Equals(roleKey)).Select(kv => kv.Key).ToArray();
string[] userNames = new string[usersInRoleIndexes.Count()];
for (int i = 0; i < usersInRoleIndexes.Count(); i++)
{
userNames[i] = _userProfileList[usersInRoleIndexes[i]].Username;
}
//wont work without HttpContext :(
//provider.AddUsersToRoles(userNames, roleNames);
webpages_Roles currentRole = webEntities.webpages_Roles.Where(R => R.RoleName.Equals(roleName)).Single();
foreach (UserProfile profile in webEntities.UserProfiles.Where(UP => userNames.Contains(UP.UserName)))
{
profile.webpages_Roles.Add(currentRole);
}
webEntities.SaveChanges();
}
log.Info("Added Roles to system.");
}
public ActionResult DeleteConfirmed(int id)
{
webpages_Roles webpages_roles = db.webpages_Roles.Find(id);
db.webpages_Roles.Remove(webpages_roles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Registru/Edit/5
public ActionResult Edit(int id)
{
UserProfile userProfile = _database.UserProfiles.Single(userPorofile => userPorofile.UserId == id);
webpages_Roles role = userProfile.webpages_Roles.FirstOrDefault();
ViewBag.RoleName = role.RoleName;
return(View(userProfile));
}
private static webpages_Roles CreateAdminRole(UserDbContext context)
{
var admin = new webpages_Roles {
RoleName = "Administrators"
};
context.webpages_Roles.Add(admin);
return(admin);
}
public static RoleModel ToModel(this webpages_Roles role)
{
return(new RoleModel()
{
Id = role.RoleId,
RoleName = role.RoleName,
Description = role.Description,
});
}
public ActionResult Edit(webpages_Roles webpages_roles)
{
if (ModelState.IsValid)
{
db.Entry(webpages_roles).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(webpages_roles));
}
//
// GET: /Roles/Delete/5
public ActionResult Delete(int id = 0)
{
webpages_Roles webpages_roles = db.webpages_Roles.Find(id);
if (webpages_roles == null)
{
return(HttpNotFound());
}
return(View(webpages_roles));
}
public webpages_Roles DeleteRole(int id)
{
webpages_Roles db = context.webpages_roles.Find(id);
if (db != null)
{
context.webpages_roles.Remove(db);
context.SaveChanges();
}
return(db);
}
public void InsertOrUpdate(webpages_Roles entity)
{
if (entity.RoleId == default(int))
{
_context.SetAdd(entity);
}
else
{
_context.SetModified(entity);
}
}
public void InsertOrUpdate(webpages_Roles entity)
{
if (entity.RoleId == default(int))
{
_context.SetAdd(entity);
}
else
{
_context.SetModified(entity);
}
}
public ActionResult Create(webpages_Roles webpages_roles)
{
if (ModelState.IsValid)
{
db.webpages_Roles.Add(webpages_roles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(webpages_roles));
}
public async Task <ActionResult> Edit([Bind(Include = "RoleId,RoleName")] webpages_Roles webpages_Roles)
{
if (ModelState.IsValid)
{
db.Entry(webpages_Roles).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(webpages_Roles));
}
public async Task <ActionResult> Create([Bind(Include = "RoleId,RoleName")] webpages_Roles webpages_Roles)
{
if (ModelState.IsValid)
{
db.webpages_Roles.Add(webpages_Roles);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(webpages_Roles));
}
public static void CreateUser(int UserId, int RoleId)
{
using (ManagementSystemEntities db = new ManagementSystemEntities())
{
UserProfile user = db.UserProfiles.FirstOrDefault(a => a.UserId == UserId);
if (user != null)
{
webpages_Roles userRole = db.webpages_Roles.FirstOrDefault(a => a.RoleId == RoleId);
user.webpages_Roles.Add(userRole);
db.SaveChanges();
}
}
}
public async Task <ActionResult> DeleteConfirmed(int?id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
webpages_Roles webpages_Roles = await db.webpages_Roles.FindAsync(id);
db.webpages_Roles.Remove(webpages_Roles);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
/// <summary>
/// Apaga uma Webpages_Roles
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static void Delete(string token, Int32 RoleId, painel_taxservices_dbContext _dbContext = null)
{
painel_taxservices_dbContext _db;
if (_dbContext == null)
{
_db = new painel_taxservices_dbContext();
}
else
{
_db = _dbContext;
}
try
{
webpages_Roles role = _db.webpages_Roles.Where(r => r.RoleId == RoleId).FirstOrDefault();
if (role == null)
{
throw new Exception("Role inexistente"); // não existe role com o Id informado
}
Int32 RoleLevelMin = Permissoes.GetRoleLevelMin(token, _db);
//if (role.RoleName.ToUpper().Equals("COMERCIAL") || role.RoleLevel < RoleLevelMin) throw new Exception("401"); // não possui autorização para remover o privilégio
if (Permissoes.isAtosRoleVendedor(role) || role.RoleLevel < RoleLevelMin)
{
throw new Exception("401"); // não possui autorização para remover o privilégio
}
GatewayWebpagesPermissions.Delete(token, RoleId, _db);
GatewayWebpagesUsersInRoles.Delete(token, RoleId, true, _db);
_db.webpages_Roles.Remove(_db.webpages_Roles.Where(e => e.RoleId.Equals(RoleId)).First());
_db.SaveChanges();
}
catch (Exception e)
{
if (e is DbEntityValidationException)
{
string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e);
throw new Exception(erro.Equals("") ? "Falha ao apagar role" : erro);
}
throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message);
}
finally
{
if (_dbContext == null)
{
// Fecha conexão
_db.Database.Connection.Close();
_db.Dispose();
}
}
}
// GET: Roles/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
webpages_Roles webpages_Roles = await db.webpages_Roles.FindAsync(id);
if (webpages_Roles == null)
{
return(HttpNotFound());
}
return(View(webpages_Roles));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
webpages_Roles webpages_roles = db.webpages_Roles.Find(id);
if (webpages_roles == null)
{
return(HttpNotFound());
}
return(View(webpages_roles));
}
// GET: Roles/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
webpages_Roles webpages_Roles = await db.webpages_Roles.FindAsync(id);
if (webpages_Roles == null)
{
return(HttpNotFound());
}
return(View(webpages_Roles));
}
/// <summary>
/// Adiciona nova Webpages_Roles
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static Int32 Add(string token, webpages_Roles param, painel_taxservices_dbContext _dbContext = null)
{
painel_taxservices_dbContext _db;
if (_dbContext == null)
{
_db = new painel_taxservices_dbContext();
}
else
{
_db = _dbContext;
}
try
{
// Por segurança, só deixa alterar se o usuário tiver permissão para setar aquela role
Int32 RoleLevelMin = Permissoes.GetRoleLevelMin(token, _db);
if (param.RoleLevel < RoleLevelMin)
{
throw new Exception("401"); // não possui autorização para criar um privilégio com esse RoleLevel
}
if (_db.webpages_Roles.Where(r => r.RoleName.ToUpper().Equals(param.RoleName.ToUpper())).FirstOrDefault() != null)
{
throw new Exception("Já existe uma role com o nome '" + param.RoleName.ToUpper() + "'"); // já existe um privilégio com esse nome
}
_db.webpages_Roles.Add(param);
_db.SaveChanges();
return(param.RoleId);
}
catch (Exception e)
{
if (e is DbEntityValidationException)
{
string erro = MensagemErro.getMensagemErro((DbEntityValidationException)e);
throw new Exception(erro.Equals("") ? "Falha ao salvar role" : erro);
}
throw new Exception(e.InnerException == null ? e.Message : e.InnerException.InnerException == null ? e.InnerException.Message : e.InnerException.InnerException.Message);
}
finally
{
if (_dbContext == null)
{
// Fecha conexão
_db.Database.Connection.Close();
_db.Dispose();
}
}
}
public void SaveRole(webpages_Roles role)
{
if (role.RoleId == 0)
{
context.webpages_roles.Add(role);
}
else
{
webpages_Roles db = context.webpages_roles.Find(role.RoleId);
if (db != null)
{
db.RoleName = role.RoleName;
}
}
context.SaveChanges();
}
public string GetRoleName(int roleId)
{
string ret = "";
webpages_Roles role = repository.Roles_GetByRoleId(roleId);
if (role != null)
{
ret = role.RoleName;
}
else
{
throw new Exception("Invalid Role Id provided");
}
return(ret);
}
// POST /webpages_Roles/token/
public HttpResponseMessage Post(string token, [FromBody] webpages_Roles param)
{
// Abre nova conexão
using (painel_taxservices_dbContext _db = new painel_taxservices_dbContext())
{
tbLogAcessoUsuario log = new tbLogAcessoUsuario();
try
{
HttpResponseMessage retorno = new HttpResponseMessage();
log = Bibliotecas.LogAcaoUsuario.New(token, JsonConvert.SerializeObject(param), "Post", _db);
if (Permissoes.Autenticado(token, _db))
{
Int32 dados = GatewayWebpagesRoles.Add(token, param, _db);
log.codResposta = (int)HttpStatusCode.OK;
Bibliotecas.LogAcaoUsuario.Save(log, _db);
return(Request.CreateResponse <Int32>(HttpStatusCode.OK, dados));
}
else
{
log.codResposta = (int)HttpStatusCode.Unauthorized;
log.msgErro = "Unauthorized";
Bibliotecas.LogAcaoUsuario.Save(log, _db);
return(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
}
catch (Exception e)
{
if (e.Message.Equals("401"))
{
log.codResposta = (int)HttpStatusCode.Unauthorized;
log.msgErro = "Unauthorized";
Bibliotecas.LogAcaoUsuario.Save(log);
return(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
else
{
log.codResposta = (int)HttpStatusCode.InternalServerError;
log.msgErro = e.Message;
Bibliotecas.LogAcaoUsuario.Save(log);
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
}
}
public int GetRoleId(string roleName)
{
int ret = 0;
webpages_Roles role = repository.Roles_GetByRoleName(roleName);//.webpages_Roles.Where(m => m.RoleName == roleName).FirstOrDefault();
if (role != null)
{
ret = role.RoleId;
}
else
{
throw new Exception("Invalid Role name provided");
}
return(ret);
}
public ActionResult DeleteConfirmed(int id)
{
UserProfile userProfile = _database.UserProfiles.Single(user => user.UserId == id);
userProfile.Active = !userProfile.Active;
_database.ObjectStateManager.ChangeObjectState(userProfile, EntityState.Modified);
_database.SaveChanges();
webpages_Roles role = userProfile.webpages_Roles.FirstOrDefault();
if (role.RoleName == "Customer")
{
return(RedirectToAction("RegisteredCustomers"));
}
else
{
return(RedirectToAction("RegisteredRestaurants"));
}
}
public static void InsertNewEmployee(EmployeeUsersDetails employeeUser)
{
int userId = UserProfilesRepository.GetUserByUserName(employeeUser.UserName).UserId;
Employee employee = new Employee();
employee.CurrentSalary = employeeUser.CurrentSalary;
employee.JoinDate = employeeUser.JoinDate;
employee.UserId = userId;
employee.CreateDate = DateTimeHelper.Today();
if (employeeUser.RoleId == 0)
{
webpages_Roles role = RolesRepositories.GetEmployeeRole();
employeeUser.RoleId = role.RoleId;
}
EmployeesRepositories.InsertNewEmployee(employee);
RolesRepositories.CreateUser(userId, employeeUser.RoleId);
}
