public static bool GetExistNumClient(long?numCli, NpgsqlConnection dbCon = null)
{
var dbConnection = GetConnection(dbCon);
var result = dbConnection.Query(BaseScriptsPG.GetExistClientScript(), new { numCli });
return(result != null && result.Any());
}
public static Set10CardExist GetExistCardByGuid(Set10ExchangeLoyCard card, NpgsqlConnection dbCon = null)
{
var dbConnection = GetConnection(dbCon);
return(dbConnection.Query <Set10CardExist>(BaseScriptsPG.GetExistCardByGuidScript(), new { card.Set10Guid }).FirstOrDefault());
}
public static void UpdateClient(CardClients client, NpgsqlConnection dbConnection, IDbTransaction t)
{
dbConnection.Execute(BaseScriptsPG.UpdateClientScript(), new { client.Id, client.Auto, client.Birthdate, client.Childrenage, client.Appartment, client.Building, client.City, client.District, client.Districtarea, client.House, client.Other, client.Region, client.Street, client.Zip, client.Deleted, client.Email, client.Firstname, client.Guid, client.Iscompleted, client.Lastchangedate, client.Lastname, client.Marital, client.Middlename, client.Mobileoperator, client.Mobilephone, client.Delivery, client.Deliverydate, client.Passnumber, client.Passserie, client.Phone, client.Bymail, client.Bysms, client.Byphone, client.Byemail, client.Sendcatalog, client.Sex, client.Shopnumber, client.Creationdate, client.Bonusbalance, client.Clienttype, client.ReceiptFeedbackMeans }, t);
}
public static List <CardsBonusaccounts> GetCardBonusAccounts(long?set10Guid, NpgsqlConnection dbCon = null)
{
var dbConnection = GetConnection(dbCon);
return(dbConnection.Query <CardsBonusaccounts>(BaseScriptsPG.GetCardBonusAccountsScript(), new { set10Guid }).ToList());
}