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