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