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 FindClientTabItemViewModel(string nameHeader) : base(nameHeader)
{
QueryClientInfo = new QueryForFindClientInfo();
InitializeCommands();
FindByLastNameBit = true;
ClientCategories = DbMs.GetClientCategory();
}
private void ClearQueryCommandMethod()
{
QueryClientInfo = new QueryForFindClientInfo();
QCardNumber = string.Empty;
}
