//TODO: do we need it?
public int DeleteAddress(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id)
};
return(_dbContext.Delete(Tables.Address.Delete, parameters));
}
public int Delete(TRole role)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@RoleId", role.Id)
};
string query = $"delete from {Roles.TableName} where {Roles.Id.Name}=@RoleId";
return(db.Delete(query, parameters));
}
public int DeleteUser(TUser user)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@UserId", !string.IsNullOrEmpty(user.Id) ? user.Id :null)
};
string query = $"delete from {Users.TableName} where {Users.Id.Name}=@UserId";
return(db.Delete(query, parameters));
}
public int RemoveFromRoleAsync(TUser user, string roleId)
{
string qry = $"DELETE FROM {UserRoles.TableName} WHERE {UserRoles.UserId.Name} = @UserId AND {UserRoles.RoleId.Name} = @RoleId";
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@UserId", (user as User).Id),
new MySqlParameter("@RoleId", roleId)
};
return(db.Delete(qry, parameters));
}
public int RemoveLogin(TUser user, UserLoginInfo login)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@LoginProvider", login.LoginProvider),
new MySqlParameter("@ProviderKey", login.ProviderKey),
new MySqlParameter("@UserId", user.Id)
};
string query = $"delete from {UserLogins.TableName} where {UserLogins.LoginProvider.Name}=@LoginProvider and {UserLogins.ProviderKey.Name}=@ProviderKey and {UserLogins.UserId.Name}=@UserId";
return(db.Delete(query, parameters));
}
public int RemoveClaim(TUser user, Claim claim)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@UserId", user.Id),
new MySqlParameter("@ClaimType", claim.Type),
new MySqlParameter("@ClaimValue", claim.Value)
};
string query = $"delete from {UserClaims.TableName} where {UserClaims.Id.Name}= @UserId and {UserClaims.ClaimType.Name}=@ClaimType and {UserClaims.ClaimValue.Name}=@ClaimValue";
return(db.Delete(query, parameters));
}
public int Delete(Branch branch)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
};
string sql = "delete from branch_activity_hours where branch_id = " + branch.Id + ";" +
"delete from branch_exams where branch_id = " + branch.Id + ";" +
"delete from branch_staff where branch_id = " + branch.Id + ";" +
"delete from branch_students where branch_id = " + branch.Id + ";" +
"delete from financial_support_request where branch_id = " + branch.Id + ";" +
"delete from branch_study_path where branch_id = " + branch.Id + ";" +
"delete from loan_support_request where branch_id = " + branch.Id + ";" +
"delete from health_support_request where branch_id = " + branch.Id + ";" +
"delete from attendance where branch_id = " + branch.Id + ";" +
"delete from attendance_rules where branch_id = " + branch.Id + ";" +
"delete from dental_health_support_request where branch_id = " + branch.Id + ";" +
"delete from branches where id = " + branch.Id + ";";
return(_dbContext.Delete(sql, parameters));
}