public static void PurgeIdentityTables(OracleDataContext context) { context.ExecuteNonQuery("DELETE FROM userroles"); context.ExecuteNonQuery("DELETE FROM userlogins"); context.ExecuteNonQuery("DELETE FROM userclaims"); context.ExecuteNonQuery("DELETE FROM roles"); context.ExecuteNonQuery("DELETE FROM users"); }
public int Insert(IdentityRole role) { if (role == null) { throw new ArgumentNullException("role"); } return(_db.ExecuteNonQuery( "INSERT INTO roles (id, name) VALUES (:id, :name)", new OracleParameter { ParameterName = ":id", Value = role.Id, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":name", Value = role.Name, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input })); }
public int Insert(IdentityUser user, string roleId) { if (user == null) { throw new ArgumentNullException("user"); } return(_db.ExecuteNonQuery( "INSERT INTO userroles (userid, roleid) values (:userid, :roleid)", new OracleParameter { ParameterName = ":userid", Value = user.Id, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":roleid", Value = roleId, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input })); }
public int Insert(IdentityUser user, string roleId) { if (user == null) { throw new ArgumentNullException("user"); } return(_db.ExecuteNonQuery( "INSERT INTO " + TableName + " (" + UsuarioCol + ", " + RolCol + ") values (:userid, :roleid)", new OracleParameter { ParameterName = ":userid", Value = long.Parse(user.Id), OracleDbType = OracleDbType.Int16, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":roleid", Value = roleId, OracleDbType = OracleDbType.Int16, Direction = ParameterDirection.Input })); }
public int Insert(IdentityUser user) { if (user == null) { throw new ArgumentNullException("user"); } return(_db.ExecuteNonQuery( "INSERT INTO \"" + TableName + "\" (" + PwdHashCol + ", " + NombreCol + ", " + EmailCol + ", " + CargoCol + ", " + " " + DireccionCol + ", " + TelefonoCol + ", " + CelularCol + "," + ExtensionCol + "," + FaxCol + "," + EstadoCol + "," + IdOrganizacionCol + ") VALUES " + "(:pwdhash, :nombre, :email, :cargo, :direccion," + " :telefono, :celular, :extension, :fax, :estado, :IdOrganizacion)", new OracleParameter { ParameterName = ":pwdhash", Value = user.PwdHash, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":nombre", Value = user.Nombre, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":email", Value = user.Email, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":cargo", Value = user.Cargo, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":direccion", Value = user.Direccion, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":telefono", Value = user.Telefono, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":celular", Value = user.Celular, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":extension", Value = user.Extension, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":fax", Value = user.Fax, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":estado", Value = user.Estado? 1 : 0, OracleDbType = OracleDbType.Int16, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":IdOrganizacion", Value = user.ID_ORGANIZACION, OracleDbType = OracleDbType.Long, Direction = ParameterDirection.Input })); }
public int Insert(Claim userClaim, string userId) { if (userClaim == null) { throw new ArgumentNullException("userClaim"); } return(_db.ExecuteNonQuery( "INSERT INTO userclaims (userid, claimtype, claimvalue) VALUES (:userId, :type, :value)", new OracleParameter { ParameterName = ":userId", Value = userId, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":type", Value = userClaim.Type, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":value", Value = userClaim.Value, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input })); }
public int Insert(IdentityUser user) { if (user == null) { throw new ArgumentNullException("user"); } return(_db.ExecuteNonQuery( "INSERT INTO users (id, username, passwordhash, securitystamp) VALUES (:id, :name, :passwordhash, :securitystamp)", new OracleParameter { ParameterName = ":id", Value = user.Id, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":name", Value = user.UserName, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":passwordhash", Value = user.PasswordHash, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":securitystamp", Value = user.SecurityStamp, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input })); }
public int Insert(IdentityUser user, UserLoginInfo login) { if (user == null) { throw new ArgumentNullException("user"); } if (login == null) { throw new ArgumentNullException("login"); } return(_db.ExecuteNonQuery( "INSERT INTO userlogins (userid, loginprovider, providerkey) VALUES (:userid, :loginprovider, :providerkey)", new OracleParameter { ParameterName = ":userid", Value = user.Id, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":loginprovider", Value = login.LoginProvider, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input }, new OracleParameter { ParameterName = ":providerkey", Value = login.ProviderKey, OracleDbType = OracleDbType.Varchar2, Direction = ParameterDirection.Input })); }