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());
}