public static void InsertCard(CardCards card, long?bonusAccountId, NpgsqlConnection dbConnection, IDbTransaction t)
{
dbConnection.Execute(BaseScriptsPG.InsertNewCardScript,
new
{
card.Id,
card.Activationdate,
card.Amount,
card.Barcode,
card.Createdate,
card.Deleted,
card.Expirationdate,
card.Guid,
card.Numberfield,
card.Status,
card.Statusdescription,
card.CardtypeId,
card.ClientId,
card.NewcardtypeId,
card.IdCardref,
card.Counterparty,
card.DebitorType,
bonusAccountId
}, t);
}
public static void DeleteCardByNumCard(CardCards card, NpgsqlConnection dbConnection, IDbTransaction t)
{
dbConnection.Execute(BaseScriptsPG.DeleteCardByNumCardScript, new { Numberfield = card.Numberfield }, t);
}
public static void UpdateCardClientIdIEmpty(CardCards card, NpgsqlConnection dbConnection, IDbTransaction t)
{
dbConnection.Execute(BaseScriptsPG.UpdateCardClientIdIEmptyScript, new { card.Guid, card.ClientId }, t);
}