public JsonResult Permisos(AUTH_USER auth_user) { AUTH_USER_SERV serv = new AUTH_USER_SERV(); var obj = serv.Permisos(auth_user); return(Json(obj, JsonRequestBehavior.AllowGet)); }
private void InitUserSystem(AUTH_USER user, AUTH_CITY city, AUTH_SYSTEM system) { var userSystems = user.AUTH_USER_SYSTEM.Where(us => us.AUTH_CITY.CITY_ID == city.CITY_ID && us.AUTH_SYSTEM.SYSTEM_ID == system.SYSTEM_ID); if (userSystems.Count() == 0) { AUTH_USER_SYSTEM us = new AUTH_USER_SYSTEM() { //USER_SYSTEM_ID = Guid.NewGuid().ToString(), USER_SYSTEM_ID = UserSystemRepository.GetNewID("AUTH_USER_SYSTEM", "USER_SYSTEM_ID"), AUTH_USER = user, AUTH_CITY = city, AUTH_SYSTEM = system, IS_ACTIVE = user.USER_NAME == "Admin"?"1":"0" }; UserSystemRepository.Add(us); UserSystemRepository.SaveChanges(); } //var userSystem = user.AUTH_USER_SYSTEM.Single(us => us.AUTH_CITY.CITY_ID == city.CITY_ID // && us.AUTH_SYSTEM.SYSTEM_ID == system.SYSTEM_ID); var userSystem = user.AUTH_USER_SYSTEM.Single(us => us.AUTH_CITY.CITY_ID == city.CITY_ID && us.AUTH_SYSTEM.SYSTEM_ID == system.SYSTEM_ID); InitUserModule(userSystem); }
public AUTH_USER Login(AUTH_USER auth_user) { using (DBContextPDM db = new DBContextPDM()) { using (var ctxTrans = db.Database.BeginTransaction()) { try { var UsuarioParameter = new SqlParameter(); var PasswordParameter = new SqlParameter(); var ModuleParameter = new SqlParameter(); UsuarioParameter.ParameterName = "@Usuario"; UsuarioParameter.Direction = ParameterDirection.Input; UsuarioParameter.SqlDbType = SqlDbType.VarChar; UsuarioParameter.Value = auth_user.Usuario; PasswordParameter.ParameterName = "@Contrasenia"; PasswordParameter.Direction = ParameterDirection.Input; PasswordParameter.SqlDbType = SqlDbType.VarChar; PasswordParameter.Value = auth_user.Contrasenia; ModuleParameter.ParameterName = "@CodModulo"; ModuleParameter.Direction = ParameterDirection.Input; ModuleParameter.SqlDbType = SqlDbType.VarChar; ModuleParameter.Value = auth_user.CodModulo; var user = db.Database.SqlQuery <AUTH_USER>("CLC.[dbo].[PR_SEG_USUARIO_VAL_Logueo] @Usuario, @Contrasenia, @CodModulo", UsuarioParameter, PasswordParameter, ModuleParameter ).FirstOrDefault(); ctxTrans.Commit(); // OK return(user); } catch (NullReferenceException ex) { ctxTrans.Rollback(); // ERROR throw ex; } catch (SqlException ex) { ctxTrans.Rollback(); // ERROR throw ex; } catch (Exception ex) { ctxTrans.Rollback(); // ERROR throw ex; } } } }
public int Permisos(AUTH_USER auth_user) { using (DBContextPDM db = new DBContextPDM()) { using (var ctxTrans = db.Database.BeginTransaction()) { try { var UsuarioParameter = new SqlParameter(); var ModuleParameter = new SqlParameter(); UsuarioParameter.ParameterName = "@CodUsuario"; UsuarioParameter.Direction = ParameterDirection.Input; UsuarioParameter.SqlDbType = SqlDbType.SmallInt; UsuarioParameter.Value = auth_user.CodUsuario; ModuleParameter.ParameterName = "@CodModulo"; ModuleParameter.Direction = ParameterDirection.Input; ModuleParameter.SqlDbType = SqlDbType.VarChar; ModuleParameter.Value = auth_user.CodModulo; var permiso = db.Database.SqlQuery <Int16>("CLC.dbo.PR_SEG_USUARIO_VAL_Permiso @CodUsuario, @CodModulo", UsuarioParameter, ModuleParameter ).FirstOrDefault(); ctxTrans.Commit(); // OK return(permiso); } catch (InvalidOperationException ex) { ctxTrans.Rollback(); // ERROR throw ex; } catch (NullReferenceException ex) { ctxTrans.Rollback(); // ERROR throw ex; } catch (SqlException ex) { ctxTrans.Rollback(); // ERROR throw ex; } catch (Exception ex) { ctxTrans.Rollback(); // ERROR throw ex; } } } }
public void Update(AUTH_USER entidad) { throw new NotImplementedException(); }