public static IEnumerable <CardsBonusAccountsTrans> GetTransactions(Set10ExchangeLoyClient client, DateTime bDate, DateTime eDate, NpgsqlConnection dbCon = null) { var dbConnection = GetConnection(dbCon); var result = dbConnection.Query <CardsBonusAccountsTrans>(BaseScriptsPG.GetTransactionsScript, new { client.BonusAccountId, bDate, eDate }); return(result); }
private void SaveKit(IEnumerable <string> cards) { var client = new ClientKit(); var clientInfo = new Set10ExchangeLoyClient(Guid.NewGuid(), null, DbPg.GetHibernateSequenceNextVal(), null, null, null, null, null, 0, 3, 10, DateTime.Now, string.Empty); var cardsList = new ObservableCollection <Set10ExchangeLoyCard>(); foreach (var card in cards) { cardsList.Add(new Set10ExchangeLoyCard(clientInfo.Uid, clientInfo.Set10Guid, DbPg.GetHibernateSequenceNextVal(), card, clientInfo.BonusAccountId)); } client.Client = clientInfo; client.Cards = cardsList; try { client.Save(); if (IsPrintLabel) { Printer.Print(client.Cards[0]?.CardHexNumber, client.Cards[1]?.CardHexNumber, client.Client.Set10Guid.ToString()); } IsScansCount++; EventMsg = $"Комплект с номером {client.Client.Set10Guid} создан"; } catch (Exception ex) { EventMsg = ex.Message; } }
public static ClientKit GetClientFullInfo(Set10ExchangeLoyClient client, SqlConnection dbConnection = null) { var clientFull = new ClientKit(); clientFull.Client = client; clientFull.Cards = new ObservableCollection <Set10ExchangeLoyCard>(DbMs.GetCardsByClientUid(client.Uid, dbConnection)); return(clientFull); }
private void Client(Set10ExchangeLoyClient client, bool isExistClient, IDbTransaction transaction, NpgsqlConnection dbConnection) { var cli = new CardClients { Id = client.Set10Guid.Value, Auto = false, Birthdate = client.BirthDate, Childrenage = string.Empty, Appartment = string.Empty, Building = string.Empty, City = string.Empty, District = string.Empty, Districtarea = string.Empty, House = string.Empty, Other = string.Empty, Region = string.Empty, Street = string.Empty, Zip = string.Empty, Deleted = false, Email = client.EMail, Firstname = client.FirstName, Guid = client.Set10Guid, Iscompleted = true, Lastchangedate = DateTime.Now, Lastname = client.LastName, Marital = false, Middlename = client.MiddleName, Mobileoperator = string.Empty, Mobilephone = client.MobilePhone, Delivery = string.Empty, Deliverydate = null, Passnumber = string.Empty, Passserie = string.Empty, Phone = string.Empty, Bymail = false, Bysms = false, Byphone = false, Byemail = false, Sendcatalog = false, Sex = 0, Shopnumber = string.Empty, Creationdate = DateTime.Now, Bonusbalance = 0, Clienttype = 0, ReceiptFeedbackMeans = 0, SmartphoneType = null, WantsECard = false }; if (isExistClient) { DbPg.UpdateClient(cli, dbConnection, transaction); } else { DbPg.InsertClient(cli, dbConnection, transaction); } }
public static void SaveClientInfo(Set10ExchangeLoyClient client) { using (var dbConnection = new SqlConnection(ConnectionSettings.ConMsStr)) { dbConnection.Open(); using (var tran = dbConnection.BeginTransaction()) { if (client.IsNew) { dbConnection.Execute(BaseScriptsMs.InsertClientSript, new { client.Uid, client.Set10Guid, client.BonusAccountId, client.LastName, client.FirstName, client.MiddleName, client.BirthDate, client.MobilePhone, client.SexId, client.CategoryId, client.ChangeTypeId, client.Ldm }); } else if (!client.IsNew) { dbConnection.Execute(BaseScriptsMs.UpdateClientSript, new { client.Uid, client.LastName, client.FirstName, client.MiddleName, client.BirthDate, client.MobilePhone, client.SexId, client.CategoryId }); } try { tran.Commit(); } catch (Exception e) { tran.Rollback(); throw new Exception("SaveClientInfo error!", e); } } } }
private void Cards(Set10ExchangeLoyClient client, List <CardsCompositions> cardComposition, IDbTransaction transaction, NpgsqlConnection dbConnection) { foreach (var card in cardComposition) { var set10Card = new CardCards(card.MasterCard.Set10Guid.Value, DateTime.Now.Date, 0, null, DateTime.Now.Date, false, DateTime.Parse("01-01-2021"), card.MasterCard.Set10Guid.Value, card.MasterCard.CardNumber, (card.MasterCard.IsBlocked == false ? 0 : 2), string.Empty, 2059, client.Set10Guid, null, null, null, String.Empty); if (card.CardById == null && card.CardByNumCard != null) { DbPg.DeleteCardByNumCard(set10Card, dbConnection, transaction); } if (card.CardById == null) { DbPg.InsertCard(set10Card, card.MasterCard.BonusAccountId, dbConnection, transaction); } else { DbPg.UpdateCard(set10Card, dbConnection, transaction); } if (card.CardById?.Clientid == null) { DbPg.UpdateCardClientIdIEmpty(set10Card, dbConnection, transaction); } } }
public static IEnumerable <Set10ExchangeLoyAmmounts> GetBonus(Set10ExchangeLoyClient client, NpgsqlConnection dbCon = null) { var dbConnection = GetConnection(dbCon); return(dbConnection.Query <Set10ExchangeLoyAmmounts>(BaseScriptsPG.BonusByGuidScript, new { client.Set10Guid })); }
public SelectedClientInfoEventArgs(Set10ExchangeLoyClient clientInfo) { Client = clientInfo; }
//private bool CheckIdentityCard(CardsCompositions cardCompot) //{ // if (cardCompot.CardById.) // return false; //} private void BonusAccounts(Set10ExchangeLoyClient client, IDbTransaction transaction, NpgsqlConnection dbConnection) { DbPg.InsertBonusAccount(client.BonusAccountId, client.BonusAccountId, dbConnection, transaction); }