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