public static Credit GetLastCreditByHolder(SqlConnectionStringBuilder stringBuilder, AClient holder) { int isEntity = 0; if (holder is Entity) { isEntity = 1; } else if (holder is Client) { isEntity = 0; } var sqlQuery = $@"SELECT TOP 1 * FROM Credits WHERE HolderId = {holder.Id} and isEntity = {isEntity} ORDER BY ID DESC"; Credit lastCredit = null; using (var connector = new SqlConnector(stringBuilder)) { var reader = connector.GetData(sqlQuery); while (reader.Read()) { lastCredit = ConvertSqlData.ToCredit(reader, holder); } } return(lastCredit); }
public static IEnumerable <Credit> GetCreditsByHolder(SqlConnectionStringBuilder stringBuilder, AClient holder) { var sqlQuery = $@"SELECT * FROM Credits WHERE HolderId = {holder.Id}"; List <Credit> credits = new List <Credit>(); using (var connector = new SqlConnector(stringBuilder)) { var reader = connector.GetData(sqlQuery); while (reader.Read()) { var credit = ConvertSqlData.ToCredit(reader, holder); credits.Add(credit); } } return(credits); }
private void GetCredits(int index, SqlConnectionStringBuilder connectionStringBuilder, AClient holder, int entity = 0) { var sqlCreditQuery = $@"SELECT * FROM Credits WHERE HolderId = {index} AND isEntity = {entity}"; using (var connector = new SqlConnector(connectionStringBuilder)) { using (var creditReader = connector.GetData(sqlCreditQuery)) { while (creditReader.Read()) { var credit = ConvertSqlData.ToCredit(creditReader, holder); if (credit != null) { Credits.Add(credit); holder.Credits.Add(credit); } } } } }