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