public static Client GetLastClient(SqlConnectionStringBuilder stringBuilder, Bank bank) { var sqlQuery = @"SELECT TOP 1 * FROM Clients ORDER BY ID DESC"; Client lastClient = null; using (var connector = new SqlConnector(stringBuilder)) { var reader = connector.GetData(sqlQuery); while (reader.Read()) { lastClient = ConvertSqlData.ToClient(reader, bank); } } return(lastClient); }
public static Client GetClientById(SqlConnectionStringBuilder stringBuilder, int id, Bank bank) { var sqlQuery = $@"SELECT * FROM Clients WHERE Id = {id}"; Client currentClient = null; using (var connector = new SqlConnector(stringBuilder)) { var reader = connector.GetData(sqlQuery); while (reader.Read()) { currentClient = ConvertSqlData.ToClient(reader, bank); } } return(currentClient); }
private void DbFillClients(SqlConnectionStringBuilder connectionStringBuilder) { Clients = new List <AClient>(); var sqlGetClients = @"SELECT * FROM Clients"; using (var connector = new SqlConnector(connectionStringBuilder)) { using (var reader = connector.GetData(sqlGetClients)) { while (reader.Read()) { var currentClient = ConvertSqlData.ToClient(reader, this); GetCredits((int)reader[0], connectionStringBuilder, currentClient); GetDeposits((int)reader[0], connectionStringBuilder, currentClient); Clients.Add(currentClient); } } } }