public string GetPasswordHashAsync(TUser user)
{
List <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@userId", user.Id)
};
string query = $"SELECT {Users.PasswordHash.Name} from {Users.TableName} where {Users.Id.Name} = @userId";
return(db.GetDataRow(query, null)[Users.PasswordHash.Name].ToString());
}
public TRole FindById(string roleId)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@roleId", roleId)
};
string query = $"select * from {Roles.TableName} where {Roles.Id.Name}=@roleId";
DataRow row = db.GetDataRow(query, parameters);
return(Converters.DataRowToRole <TRole>(row));
}
public TUser GetUserById(string Id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@UserId", Id)
};
string query = $"select * from {Users.TableName} where {Users.Id.Name}=@UserId";
DataRow row = db.GetDataRow(query, parameters);
return(Converters.DataRowToUser <TUser>(row));
}
public City GetCity(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id)
};
DataRow row = _dbContext.GetDataRow(Tables.Cities.Select, parameters);
return(CityConverter.RowToCity(row));
}
public Bank GetBank(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id)
};
DataRow row = _dbContext.GetDataRow(Tables.Banks.Select, parameters);
return(BankConverter.RowToBank(row));
}
public Street GetStreet(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id)
};
DataRow row = _dbContext.GetDataRow(Tables.Streets.Select, parameters);
return(StreetConverter.RowToStreet(row));
}
public TUser Find(UserLoginInfo login)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@LoginProvider", login.LoginProvider),
new MySqlParameter("@ProviderKey", login.ProviderKey)
};
string query = $"select {UserLogins.UserId.Name} from {UserLogins.TableName} where {UserLogins.LoginProvider.Name}=@LoginProvider and {UserLogins.ProviderKey.Name}=@ProviderKey ";
DataRow row = db.GetDataRow(query, parameters);
if (row != null)
{
string id = row[UserLogins.UserId.Name].ToString();
parameters.Add(new MySqlParameter("@UserId", id));
string sqlStr = $"select * from {Users.TableName} where {Users.Id.Name}=@UserId";
DataRow rowUser = db.GetDataRow(sqlStr, null);
return(Converters.DataRowToUser <TUser>(rowUser));
}
return(null);
}
public Address GetAddress(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id)
};
DataRow row = _dbContext.GetDataRow(Tables.Address.Select, parameters);
return(AddressConverter.RowToAddress(row));
}
public Scolarship GetScolarship(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id),
};
DataRow row = _dbContext.GetDataRow(Tables.Scolarships.Select, parameters);
if (row == null)
{
return(null);
}
return(ScolarshipConverter.RowToScolarship(row));
}
public BranchType GetBranchType(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id),
};
DataRow row = _dbContext.GetDataRow(Tables.BranchTypes.Select, parameters);
if (row == null)
{
return(null);
}
return(BranchTypeConverter.RowToBranchType(row));
}
public UserExtraDetails GetUserDetails(string Id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", Id),
};
string sql = $"SELECT * FROM {Tables.UserExtraDetails.TableName} WHERE {Tables.UserExtraDetails.UserId.Name}=@id";
DataRow row = _dbContext.GetDataRow(sql, parameters);
if (row == null)
{
return(null);
}
return(UserExtraDetailsConverter.RowToUserExtraDetails(row));
}