예제 #1
0
        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());
        }
예제 #2
0
        public static Set10CardExist GetExistCardByGuid(Set10ExchangeLoyCard card, NpgsqlConnection dbCon = null)
        {
            var dbConnection = GetConnection(dbCon);

            return(dbConnection.Query <Set10CardExist>(BaseScriptsPG.GetExistCardByGuidScript(), new { card.Set10Guid }).FirstOrDefault());
        }
예제 #3
0
 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);
 }
예제 #4
0
        public static List <CardsBonusaccounts> GetCardBonusAccounts(long?set10Guid, NpgsqlConnection dbCon = null)
        {
            var dbConnection = GetConnection(dbCon);

            return(dbConnection.Query <CardsBonusaccounts>(BaseScriptsPG.GetCardBonusAccountsScript(), new { set10Guid }).ToList());
        }