private void GetWarehouseImportList()
{
SQLQueryCustodian _sqlCmdObserver = new SQLQueryCustodian((queryResult) =>
{
WarehouseImportItemSource = new ObservableCollection <MSW_WHMP_WarehouseImportOV>();
LstWarehouseImport = queryResult.Result as List <tblWarehouseImport>;
if (queryResult.MesResult == MessageQueryResult.Done)
{
foreach (var item in queryResult.Result as List <tblWarehouseImport> )
{
var detail = new MSW_WHMP_WarehouseImportOV();
detail.ImportID = item.ImportID;
detail.ImportTime = item.ImportTime;
detail.ImportDescription = item.ImportDescription;
detail.IsActive = item.IsActive;
detail.PurchasePrice = item.PurchasePrice;
detail.TotalPrice = item.TotalPrice;
detail.SupplierID = item.SupplierID;
detail.SupplierName = item.tblSupplier.SupplierName;
detail.tblWarehouseImportDetails = item.tblWarehouseImportDetails.Where(o => o.IsActive).ToList();
WarehouseImportItemSource.Add(detail);
}
}
Invalidate("WarehouseImportItemSource");
});
DbManager.Instance.ExecuteQuery(SQLCommandKey.GET_ALL_ACTIVE_WAREHOUSE_IMPORT_DATA_CMD_KEY
, _sqlCmdObserver);
}
private bool FilterByStartDate(MSW_WHMP_WarehouseImportOV item, DateTime?startDate)
{
if (startDate == null)
{
return(true);
}
else
{
return(RUNE.IS_SUPPORT_FILTER_WAREHOUSE_IMPORT_BY_START_DATE
? item.ImportTime >= startDate
: false);
}
}
private bool FilterByEndDate(MSW_WHMP_WarehouseImportOV item, DateTime?endDate)
{
if (endDate == null)
{
return(true);
}
else
{
return(RUNE.IS_SUPPORT_FILTER_WAREHOUSE_IMPORT_BY_END_DATE
? item.ImportTime <= endDate
: false);
}
}
private bool SearchByMedicineName(MSW_WHMP_WarehouseImportOV item, string filterText)
{
return(RUNE.IS_SUPPORT_SEARCH_WAREHOUSE_IMPORT_BY_MEDICINE_NAME
? item.tblWarehouseImportDetails.Where(o => CultureInfo.CurrentCulture.CompareInfo.IndexOf(o.tblMedicine.MedicineName, filterText, CompareOptions.IgnoreCase) >= 0).FirstOrDefault() != null
: false);
}
private bool SearchBySupplierName(MSW_WHMP_WarehouseImportOV item, string filterText)
{
return(RUNE.IS_SUPPORT_SEARCH_WAREHOUSE_IMPORT_BY_SUPPLIER_NAME
? CultureInfo.CurrentCulture.CompareInfo.IndexOf(item.SupplierName, filterText, CompareOptions.IgnoreCase) >= 0
: false);
}
private bool FilterWarehouseImportInfoList(MSW_WHMP_WarehouseImportOV item, string filterText, DateTime?startDate, DateTime?endDate)
{
return((SearchByMedicineID(item, filterText) || SearchByMedicineName(item, filterText) || SearchBySupplierName(item, filterText)) &&
FilterByStartDate(item, startDate) &&
FilterByEndDate(item, endDate));
}
