public static List <Set10ExchangeLoyClient> SearchClientInfo(QueryForFindClientInfo query) { var queryDictionary = new Dictionary <string, object>(); if (query.IsLastNameEnabled && !string.IsNullOrEmpty(query.LastName)) { queryDictionary.Add(nameof(query.LastName), query.LastName); } if (query.IsFirstNameEnabled && !string.IsNullOrEmpty(query.FirstName)) { queryDictionary.Add(nameof(query.FirstName), query.FirstName); } if (query.IsMiddleNameEnabled && !string.IsNullOrEmpty(query.MiddleName)) { queryDictionary.Add(nameof(query.MiddleName), query.MiddleName); } if (query.IsMobilePhoneEnabled && !string.IsNullOrEmpty(query.FirstName)) { queryDictionary.Add(nameof(query.MobilePhone), query.MobilePhone); } if (query.IsDateBirthEnabled && query.BirthDate != null) { queryDictionary.Add(nameof(query.BirthDate), query.BirthDate); } if (query.IsCategoryIdEnabled) { queryDictionary.Add(nameof(query.CategoryId), query.CategoryId); } var dbConnection = new SqlConnection(ConnectionSettings.ConMsStr); return(dbConnection.Query <Set10ExchangeLoyClient>(BaseScriptsMs.SearchClientInfoScript(queryDictionary)) .ToList()); }
public static List <Set10ExchangeLoyClient> SearchClientInfo(string numCard) { var card12 = numCard.Length == 8 ? numCard.ToDec() : numCard; var dbConnection = new SqlConnection(ConnectionSettings.ConMsStr); return(dbConnection.Query <Set10ExchangeLoyClient>(BaseScriptsMs.SearchClientInfoScript(), new { card12 }) .ToList()); }
public static IEnumerable <Set10ExchangeLoyClient> GetClientByNumCard(string cardNumber, SqlConnection dbConnection = null) { dbConnection = GetConnection(dbConnection); var client = dbConnection.Query <Set10ExchangeLoyClient>(BaseScriptsMs.ClientByNumCardScript(), new { cardNumber }) .AsEnumerable(); return(client); }
public static IEnumerable <Set10ExchangeLoyCard> GetCardsByClientUid(Guid uid, SqlConnection dbConnection = null) { dbConnection = GetConnection(dbConnection); var cards = dbConnection.Query <Set10ExchangeLoyCard>(BaseScriptsMs.CardsByClientUidScript(), new { uid }) .AsEnumerable(); return(cards); }
public static List <Set10ExchangeLoyClient> AllNewClients() { var categoryId = 3; var s = BaseScriptsMs.NewClientsScript(); var dbConnection = new SqlConnection(ConnectionSettings.ConMsStr); return(dbConnection.Query <Set10ExchangeLoyClient>(s, categoryId).AsEnumerable().ToList()); }
public static List <Set10ExchangeLoyClient> AllChangedClients(SqlConnection dbConnection = null) { dbConnection = GetConnection(dbConnection); return(dbConnection.Query <Set10ExchangeLoyClient>(BaseScriptsMs.ChangesClientsScript()).AsEnumerable().ToList()); }