/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public UserRolesTableRepository(MySQLDatabase database) { _database = database; //_database.Set(typeof(UserRolesTable)); this.dbSet = database.Set<UserRolesTable>(); this.dbSetRoles = database.Set<IdentityRole>(); }
public UserBll() { this.Database = (MySQLDatabase)OwinContextExtensions.Get<ApplicationDbContext>(HttpContextExtensions.GetOwinContext(HttpContext.Current.Request)); this._userTable = (IUserTable)new UserTable(this.Database); this._groupTable = (IGroupTable)new GroupTable(this.Database); this._permissionTable = (IPermissionTable)new PermissionTable(this.Database); this._termTable = (ITermTable)new TermTable(this.Database); }
public GroupBll() { Database = HttpContext.Current.Request.GetOwinContext().Get<ApplicationDbContext>(); _groupTable = new GroupTable(Database); _userTable = new UserTable(Database); _permissionTable = new PermissionTable(Database); _termTable = new TermTable(Database); }
/// <summary> /// Metodo que carga los permisos de un usuario dependiendo del establecimiento /// </summary> /// <param name="username"></param> /// <param name="uorgId"></param> private static void GetPermisosUsuario(string username) { // Get Session var session = HttpContext.Current.Session; // Access to Database var db = new MySQLDatabase(); //MySqlCommand cmd = db.Connection.CreateCommand(); ///// MySqlCommand cmd = new MySqlCommand("SELECT p.`Codigo`,p.`Nombre` FROM cif_bd.Usuariospermisos u INNER JOIN cif_bd.usuarios u1 ON(u.`IdUsuario` = u1.`Id` ) INNER JOIN cif_bd.permisos p ON(u.`IdPermiso` = p.`Id` ) where u1.`UserName` = @UserName UNION select per.Codigo, per.Nombre from rolespermisos rp INNER JOIN cif_bd.permisos per on (rp.IdPermiso = per.Id) where IdRole in (SELECT u.`idrole` FROM cif_bd.usuariosroles u INNER JOIN cif_bd.usuarios u1 ON(u.`Idusuario` = u1.`Id` ) where u1.`UserName` = @UserName ) ; ", db.Connection); ///// try { // Procedure and Params cmd.Parameters.AddWithValue("@username", username); // Execute db.Open(); MySqlDataReader reader = cmd.ExecuteReader(); // Read var permissions = session["permissions"] as IDictionary<string, Permission>; string permissionCode, permissionName; Debug.WriteLine("----- Permisos -----"); while (reader.Read()) { permissionName = reader["NOMBRE"].ToString(); permissionCode = reader["CODIGO"].ToString(); permissions.Add(permissionCode, new Permission { Code = permissionCode, Name = permissionName }); Debug.WriteLine("Codigo: {0}, Nombre: {1}", permissionCode, permissionName); } reader.Dispose(); } catch (MySqlException) { throw; } catch (FormatException) { throw; } finally { // Free memory db.Close(); cmd.Dispose(); db.Dispose(); } }
public TermTable(MySQLDatabase database) { _database = database; }
/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public UserLoginsTable(MySQLDatabase database) { _database = database; }
/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public UserTable(MySQLDatabase database) { _database = database; }
public RefreshTokenBll() { Database = HttpContext.Current.Request.GetOwinContext().Get<ApplicationDbContext>(); _refreshTokenTable = new RefreshTokenTable(Database); }
/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public UserClaimsTable(MySQLDatabase database) { _database = database; }
public StudentYearClassSectionRollTable(MySQLDatabase database) { db = database; }
/// <summary> /// Constructor that takes a MySQLDatabase as argument /// </summary> /// <param name="database"></param> public RoleStore(MySQLDatabase database) { Database = database; roleTable = new RoleTable(database); }
public UserBranchStore(MySQLDatabase database) { Database = database; userBranchTable = new UserBranchTable(database); }
public YearClassSectionTable(MySQLDatabase database) { db = database; }
public ClassTable(MySQLDatabase database) { db = database; }
public TeacherSubjectTable(MySQLDatabase database) { db = database; yearClassSectionTable = new YearClassSectionTable(db); }
public RequestDeviceTable(MySQLDatabase database) { _database = database; }
public DeviceTable(MySQLDatabase database) { _database = database; }
/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public BankGLAccountTable(MySQLDatabase database) { _database = database; }
public PermissionTable(MySQLDatabase database) { _database = database; }
/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public UploadTable(MySQLDatabase database) { _database = database; }
public SectionTable(MySQLDatabase database) { db = database; }
public GroupTable(MySQLDatabase database) { _database = database; }
public SubjectYearTable(MySQLDatabase database) { db = database; }
/// <summary> /// Constructor that takes a MySQLDatabase as argument /// </summary> /// <param name="database"></param> public UploadStore(MySQLDatabase database) { Database = database; uploadTable = new UploadTable(database); }
/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public UserClaimsTableRepository(MySQLDatabase database) { _database = database; this.dbSet = database.Set<UserClaims>(); }
/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public RoleTable(MySQLDatabase database) { _database = database; }
public TermTable(MySQLDatabase database) { db = database; }
/// <summary> /// Metodo que carga los detalles del usuario logueado para su posterior uso /// </summary> /// <param name="username">Nombre de usuario</param> /// <param name="uorgId">Id de unidad organizacional en logueada</param> private static void RegisterUserDetails(string username) { // Get Session var session = HttpContext.Current.Session; // Access to Database var db = new MySQLDatabase(); MySqlCommand cmd = db.Connection.CreateCommand(); try { // Procedure and Params cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SEG.GetUserDetails"; cmd.Parameters.Add("usuario_", MySqlDbType.VarChar, 4000).Value = username; cmd.Parameters.Add("uorg_id_", MySqlDbType.Int64, 4000).Value = 0; cmd.Parameters.Add("id_", MySqlDbType.VarChar, 4000).Direction = ParameterDirection.Output; cmd.Parameters.Add("email_", MySqlDbType.VarChar, 4000).Direction = ParameterDirection.Output; cmd.Parameters.Add("nombres_", MySqlDbType.VarChar, 4000).Direction = ParameterDirection.Output; cmd.Parameters.Add("apellidos_", MySqlDbType.VarChar, 4000).Direction = ParameterDirection.Output; cmd.Parameters.Add("entaportantes_id_", MySqlDbType.Int64).Direction = ParameterDirection.Output; // Execute db.Open(); cmd.ExecuteNonQuery(); // Read var user = session["user"] as IDictionary<string, object>; user.Add("UserName", username); user.Add("UorgId", 0); user.Add("UserId", cmd.Parameters["id_"].Value); user.Add("Email", cmd.Parameters["email_"].Value); user.Add("FirstNames", cmd.Parameters["nombres_"].Value); user.Add("LastNames", cmd.Parameters["apellidos_"].Value); user.Add("EntAportanteId", cmd.Parameters["entaportantes_id_"].Value); } catch (MySqlException) { throw; } catch (FormatException) { throw; } finally { db.Close(); cmd.Dispose(); db.Dispose(); } }
//public object Mapper { get; private set; } public DeviceBll() { Database = HttpContext.Current.Request.GetOwinContext().Get<ApplicationDbContext>(); _deviceTable = new DeviceTable(Database); _requestDeviceTable = new RequestDeviceTable(Database); }
/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public UserRolesTable(MySQLDatabase database) { _database = database; }
/// <summary> /// Constructor that takes a MySQLDatabase instance /// </summary> /// <param name="database"></param> public UserLoginsTableRepository(MySQLDatabase database) { _database = database; this.dbSet = database.Set<UserLoginTable>(); }
public RefreshTokenTable(MySQLDatabase database) { _database = database; }
/// <summary> /// Metodo que carga los roles de un usuario dependiendo del establecimiento /// </summary> /// <param name="username"></param> /// <param name="uorgId"></param> private static void GetRolesUsuario(string username) { // Get Session var session = HttpContext.Current.Session; // Access to Database var db = new MySQLDatabase(); //MySqlCommand cmd = db.Connection.CreateCommand(); MySqlCommand cmd = new MySqlCommand("SELECT r.`Nombre`,r.`Codigo` FROM cif_bd.usuariosroles u INNER JOIN cif_bd.usuarios u1 ON(u.`Idusuario` = u1.`Id` ) INNER JOIN cif_bd.roles r ON(u.`idrole` = r.`Id` ) where u1.`UserName` = @UserName ; ", db.Connection); try { // Procedure and Params cmd.Parameters.AddWithValue("@username", username); // Execute db.Open(); MySqlDataReader reader = cmd.ExecuteReader(); // Read var roles = session["roles"] as IDictionary<string, Role>; string roleName, roleCode; Debug.WriteLine("----- Roles -----"); while (reader.Read()) { roleName = reader["NOMBRE"].ToString(); roleCode = reader["CODIGO"].ToString(); roles.Add(roleCode, new Role { Code = roleCode, Name = roleName }); Debug.WriteLine("Codigo: {0}, Nombre: {1}", roleCode, roleName); } reader.Dispose(); //p1.Dispose(); } catch (MySqlException) { throw; } catch (FormatException) { throw; } finally { db.Close(); cmd.Dispose(); db.Dispose(); } }
public LoginHistoryTable(MySQLDatabase database) { this._database = database; }
/// <summary> /// Constructor that takes a MySQLDatabase as argument /// </summary> /// <param name="database"></param> public BankStore(MySQLDatabase database) { Database = database; bankTable = new BankTable(database); }
public LoginHistoryBll() { Database = HttpContext.Current.Request.GetOwinContext().Get<ApplicationDbContext>(); _loginHistoryTable = new LoginHistoryTable(Database); }