public void LevelMatchFilter_EntriesWhichEvaluatesConditionToTrueReturnsMatch()
{
string condition = "message=='Hello World!'";
ConditionFilter filter = new ConditionFilter { Condition = condition, Action = LogFilterResult.Filter };
filter.Initialize(new InitializationContext(null, null));
Logger logger = new Logger(null, typeof(ConditionFilterTests));
ILogEntry trueEntry = new LogEntry(DateTimeOffset.Now, LogLevel.Information, "Hello World!", logger, null);
ILogEntry falseEntry = new LogEntry(DateTimeOffset.Now, LogLevel.Information, "Goodbye World!", logger, null);
Assert.AreEqual(LogFilterResult.Filter, filter.Evaluate(trueEntry));
Assert.AreEqual(LogFilterResult.Neutral, filter.Evaluate(falseEntry));
}
/// <summary>
/// Gets a GenericCollectionViewModel of PurchaseInvoiceViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel <PurchaseInvoiceViewModel> Get(int?pageIndex, int?pageSize)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <PurchaseInvoice, long> condition = new ConditionFilter <PurchaseInvoice, long>
{
PageIndex = pageIndex,
PageSize = pageSize,
//Query = (item =>
// item.Language == lang)
};
var entityCollection = this._PurchaseInvoicesRepository.Get(condition).ToList();
var modelCollection = entityCollection.Select(entity => entity.ToModel()).ToList();
var result = new GenericCollectionViewModel <PurchaseInvoiceViewModel>
{
Collection = modelCollection,
TotalCount = modelCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
foreach (var invoice in entityCollection)
{
var viewModel = result.Collection.FirstOrDefault(i => i.Id == invoice.Id);
viewModel.Brands = new List <BrandLightViewModel>();
var ProductList = invoice.Products;
foreach (var v in ProductList)
{
BrandLightViewModel brandViewModel = new BrandLightViewModel
{
Id = v.BrandId.Value
};
Brand b = this._BrandsRepository.Get().FirstOrDefault(bar => bar.Id == brandViewModel.Id);
brandViewModel.Name = b.ChildTranslatedBrands.FirstOrDefault(x => x.Language == lang).Name;
brandViewModel.Code = b.Code;
brandViewModel.DisplyedName = $"{b.Code}-{b.ChildTranslatedBrands.FirstOrDefault(x => x.Language == lang).Name}";
//brandViewModel.Name = $"{brandViewModel.Code} - {brandViewModel.Name}";
viewModel.Brands.Add(brandViewModel);
}
}
return(result);
}
/// <summary>
/// Gets a GenericCollectionViewModel of AccountChartSettingViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel <AccountChartSettingViewModel> Get(int?pageIndex, int?pageSize)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <AccountChartSetting, long> condition = new ConditionFilter <AccountChartSetting, long>
{
PageIndex = pageIndex,
PageSize = pageSize,
};
var entityCollection = this._AccountChartSettingsRepository.Get(condition).ToList();
var modelCollection = entityCollection.Select(entity => entity.ToModel()).ToList();
var result = new GenericCollectionViewModel <AccountChartSettingViewModel>
{
Collection = modelCollection,
TotalCount = modelCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return(result);
}
/// <summary>
/// Gets a GenericCollectionViewModel of MobileViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel <MobileLightViewModel> GetLightModel(int?pageIndex, int?pageSize)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <Mobile, long> condition = new ConditionFilter <Mobile, long>
{
PageIndex = pageIndex,
PageSize = pageSize,
};
var entityCollection = this._MobilesRepository.Get(condition).ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToLightModel()).ToList();
var result = new GenericCollectionViewModel <MobileLightViewModel>
{
Collection = dtoCollection,
TotalCount = dtoCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return(result);
}
public GenericCollectionViewModel <EffiencyRaiseHistoryViewModel> Get(int?pageIndex, int?pageSize)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <EfficiencyRaiseHistory, long> condition = new ConditionFilter <EfficiencyRaiseHistory, long>
{
PageIndex = pageIndex,
PageSize = pageSize
};
var entityCollection = this._IEffiencyRaiseHistory.Get(condition).ToList();
var modelCollection = entityCollection.Select(entity => entity.ToModel()).ToList();
var result = new GenericCollectionViewModel <EffiencyRaiseHistoryViewModel>
{
Collection = modelCollection,
TotalCount = modelCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return(result);
}
/// <summary>
/// Update an entity.
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public SafeViewModel Update(SafeViewModel model)
{
this.ThrowExceptionIfExist(model);
//var entity = model.ToEntity();
var entity = this._SafesRepository.Get(model.Id);
entity.Code = model.Code;
entity.Date = model.Date;
//entity.AccountChartId = model.AccountChartId;
entity.BranchId = model.BranchId;
entity = this._SafesRepository.Update(entity);
ConditionFilter <Safe, long> conditionFilter = new ConditionFilter <Safe, long>()
{
Query = (x =>
x.ParentKeySafeId == entity.Id)
};
var childs = this._SafesRepository.Get(conditionFilter);
if (childs.Count() > 0)
{
var ar = childs.FirstOrDefault(x => x.Language == Language.Arabic);
ar.Name = model.NameAr;
ar.Description = model.DescriptionAr;
this._SafesRepository.Update(ar);
var en = childs.FirstOrDefault(x => x.Language == Language.English);
en.Name = model.NameEn;
en.Description = model.DescriptionEn;
this._SafesRepository.Update(en);
}
#region Commit Changes
this._unitOfWork.Commit();
#endregion
model = entity.ToModel();
return(model);
}
public bool BindModel(HttpActionContext actionContext, ModelBindingContext bindingContext)
{
if (bindingContext.ModelType != typeof (ConditionFilter))
{
return false;
}
var val = bindingContext.ValueProvider.GetValue(bindingContext.ModelName);
if (val == null)
{
return false;
}
var queryString = HttpUtility.ParseQueryString(val.RawValue.ToString());
var conditionFilter = new ConditionFilter
{
Page = queryString.GetValueFromQueryString<int>("page"),
PageSize = queryString.GetValueFromQueryString<int>("pageSize"),
OscarWinner = queryString.GetValueFromQueryString<bool>("oscarWinner")
};
bindingContext.Model = conditionFilter;
return true;
}
public async Task <IActionResult> Contents(int cxt, string id)
{
try {
var conditionFilter = new ConditionFilter
{
UserId = id,
ContextId = cxt
};
var contentReturned = await _recommendationContentService.PerformContentFilteringAsync(conditionFilter);
return(Json(new
{
data = contentReturned,
totalResult = contentReturned.Count()
}));
}
catch (Exception ex)
{
return(Json(new { error = "An error occured" }));
}
}
/// <summary>
/// Gets a GenericCollectionViewModel of DelegateManViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel <DelegateManViewModel> Get(int?pageIndex, int?pageSize)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <DelegateMan, long> condition = new ConditionFilter <DelegateMan, long>
{
PageIndex = pageIndex,
PageSize = pageSize,
Query = (x => x.Language == lang)
};
var entityCollection = this._DelegateMansRepository.Get(condition).ToList();
var modelCollection = entityCollection.Select(entity => entity.ToModel()).ToList();
var result = new GenericCollectionViewModel <DelegateManViewModel>
{
Collection = modelCollection,
TotalCount = modelCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return(result);
}
private void ribbonDatePicker1_ValueChanged(object sender, EventArgs e)
{
if (!(ribbonDatePicker1.Value.Year == 2000 && ribbonDatePicker1.Value.Month == 1 && ribbonDatePicker1.Value.Day == 1))
{
// create a new ConditionFilter
var filter = new ConditionFilter();
// configure filter
filter.Condition1.Operator = ConditionOperator.LessThanOrEqualTo;
filter.Condition1.Parameter = ribbonDatePicker1.Value;
// assign new filter to column
c1FlexGrid1.Cols["BirthDate"].Filter = filter;
rbtnClearFilter2.Enabled = true;
}
else
{
c1FlexGrid1.Cols["BirthDate"].Filter = null;
rbtnClearFilter2.Enabled = false;
}
}
private void ribbonNumericBox1_ValueChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ribbonNumericBox1.Text))
{
// create a new ConditionFilter
var filter = new ConditionFilter();
// configure filter
filter.Condition1.Operator = ConditionOperator.Equals;
filter.Condition1.Parameter = ribbonNumericBox1.Value;
// assign new filter to column
c1FlexGrid1.Cols["EmployeeID"].Filter = filter;
rbtnClearFilter3.Enabled = true;
}
else
{
c1FlexGrid1.Cols["EmployeeID"].Filter = null;
rbtnClearFilter3.Enabled = false;
}
}
public string GenerateNewCode()
{
long newCode = 0;
try
{
ConditionFilter <Testament, long> condition = new ConditionFilter <Testament, long>
{
Query = x =>
x.ParentKeyTestamentId == null &&
string.IsNullOrEmpty(x.Code) == false
,
Order = Order.Descending
};
var z = this._testamentRepository.Get(condition);
var lastEntity = z.FirstOrDefault();
newCode = 1;
if (lastEntity != null)
{
try
{
newCode = long.Parse(lastEntity.Code) + 1;
}
catch
{
newCode = lastEntity.Id;
}
}
//entity.Code = newCode.ToString();
}
catch
{
//entity.Code = entity.Id.ToString();
newCode = 0;
}
return(newCode.ToString());
}
/// <summary>
/// Gets a GenericCollectionViewModel of BranchViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel <BranchLightViewModel> GetLightModel(int?pageIndex, int?pageSize)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <Branch, int> condition = new ConditionFilter <Branch, int>
{
PageIndex = pageIndex,
PageSize = pageSize,
Query = (x =>
x.Language == lang)
};
var entityCollection = this._BranchsRepository.Get(condition).ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToLightModel()).ToList();
var result = new GenericCollectionViewModel <BranchLightViewModel>
{
Collection = dtoCollection,
TotalCount = dtoCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return(result);
}
/// <summary>
/// Gets a GenericCollectionViewModel of ReceivingMethodViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel <ReceivingMethodViewModel> Get(int?pageIndex, int?pageSize)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <ReceivingMethod, int> condition = new ConditionFilter <ReceivingMethod, int>
{
PageIndex = pageIndex,
PageSize = pageSize,
Query = (item =>
item.Language == lang)
};
var entityCollection = this._ReceivingMethodsRepository.Get(condition).ToList();
var modelCollection = entityCollection.Select(entity => entity.ToModel()).ToList();
var result = new GenericCollectionViewModel <ReceivingMethodViewModel>
{
Collection = modelCollection,
TotalCount = modelCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return(result);
}
/// <summary>
/// Update an entity.
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public BankMovementCostCentersViewModel Update(BankMovementCostCentersViewModel model)
{
this.ThrowExceptionIfExist(model);
var entity = model.ToEntity();
entity = this._BankMovementCostCentersRepository.Update(entity);
ConditionFilter <CostCenter, long> conditionFilter = new ConditionFilter <CostCenter, long>()
{
Query = (x =>
x.ParentKeyCostCenterId == entity.Id)
};
#region Commit Changes
this._unitOfWork.Commit();
#endregion
model = entity.ToModel();
return(model);
}
/// <summary>
/// Gets a GenericCollectionViewModel of InventoryOpeningBalanceViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel <InventoryOpeningBalanceLightViewModel> GetLightModel(int?pageIndex, int?pageSize)
{
//var lang = this._languageService.CurrentLanguage;
ConditionFilter <InventoryOpeningBalance, long> condition = new ConditionFilter <InventoryOpeningBalance, long>
{
PageIndex = pageIndex,
PageSize = pageSize,
//Query = (item =>
// item.Language == lang)
};
var entityCollection = this._InventoryOpeningBalancesRepository.Get(condition).ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToLightModel()).ToList();
var result = new GenericCollectionViewModel <InventoryOpeningBalanceLightViewModel>
{
Collection = dtoCollection,
TotalCount = dtoCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return(result);
}
/// <summary>
/// Gets a GenericCollectionViewModel of ProductViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel <ProductViewModel> Get(int?pageIndex, int?pageSize)
{
//var lang = this._languageService.CurrentLanguage;
ConditionFilter <Product, long> condition = new ConditionFilter <Product, long>
{
PageIndex = pageIndex,
PageSize = pageSize,
//Query = (item =>
// item.Language == lang)
};
var entityCollection = this._ProductsRepository.Get(condition).ToList();
var modelCollection = entityCollection.Select(entity => entity.ToModel()).ToList();
var result = new GenericCollectionViewModel <ProductViewModel>
{
Collection = modelCollection,
TotalCount = modelCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return(result);
}
private void ribbonComboBox2_TextChanged(object sender, EventArgs e)
{
// has filter text
if (!string.IsNullOrEmpty(ribbonComboBox2.Text))
{
// create a new ConditionFilter
var filter = new ConditionFilter();
// configure filter
filter.Condition1.Operator = ConditionOperator.BeginsWith;
filter.Condition1.Parameter = ribbonComboBox2.Text;
// assign new filter to column
c1FlexGrid1.Cols["LastName"].Filter = filter;
rbtnClearFilter1.Enabled = true;
}
else
{
c1FlexGrid1.Cols["LastName"].Filter = null;
rbtnClearFilter1.Enabled = false;
}
}
/// <summary>
/// Gets a GenericCollectionViewModel of SalesRebateProductViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel<SalesRebateProductLightViewModel> GetLightModel(int? pageIndex, int? pageSize)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter<SalesRebateProduct, long> condition = new ConditionFilter<SalesRebateProduct, long>
{
PageIndex = pageIndex,
PageSize = pageSize,
Query = (item =>
item.Language == lang)
};
var entityCollection = this._SalesRebateProductsRepository.Get(condition).ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToLightModel()).ToList();
var result = new GenericCollectionViewModel<SalesRebateProductLightViewModel>
{
Collection = dtoCollection,
TotalCount = dtoCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return result;
}
/// <summary>
/// Update an entity.
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ClosedMonthViewModel Update(ClosedMonthViewModel model)
{
//this.ThrowExceptionIfExist(model);
//this.ValidateFromAndTo(model);
// var entity = model.ToEntity();
var entity = this._ClosedMonthsRepository.Get(model.Id);
entity.IsClosed = model.IsClosed;
entity = this._ClosedMonthsRepository.Update(entity);
ConditionFilter <ClosedMonth, long> conditionFilter = new ConditionFilter <ClosedMonth, long>()
{
Query = (x =>
x.ParentKeyClosedMonthId == entity.Id)
};
var childs = this._ClosedMonthsRepository.Get(conditionFilter);
if (childs.Count() > 0)
{
var ar = childs.FirstOrDefault(x => x.Language == Language.Arabic);
ar.Name = model.NameAr;
ar.Description = model.DescriptionAr;
this._ClosedMonthsRepository.Update(ar);
var en = childs.FirstOrDefault(x => x.Language == Language.English);
en.Name = model.NameEn;
en.Description = model.DescriptionEn;
this._ClosedMonthsRepository.Update(en);
}
#region Commit Changes
this._unitOfWork.Commit();
#endregion
model = entity.ToModel();
return(model);
}
public List <AccountChartLightViewModel> GetAccountCharts(long safeId, long currencyId)
{
IEnumerable <AccountChart> accountCharts;
List <AccountChartLightViewModel> accountChartViewModels = new List <AccountChartLightViewModel>();
var lang = this._languageService.CurrentLanguage;
ConditionFilter <Safe, long> condition = new ConditionFilter <Safe, long>
{
Query = (item => item.Language == lang)
};
var safe = this._SafesRepository.Get().Where(x => x.Id == safeId && x.SafeAccountCharts.Any(s => s.AccountChart.CurrencyId == currencyId));
if (safe.Count() > 0)
{
accountCharts = safe.Select(x => x.SafeAccountCharts).FirstOrDefault().Select(c => c.AccountChart);
accountChartViewModels = accountCharts.Select(x => x.ToLightModel()).ToList();
foreach (var item in accountChartViewModels)
{
item.DisplyedName = $"{item.DisplyedName}{accountCharts.FirstOrDefault(x => x.Id == item.Id).ChildTranslatedAccountCharts.FirstOrDefault(x => x.Language == lang).Name}";
}
}
return(accountChartViewModels);
}
/// <summary>
/// Gets a GenericCollectionViewModel of BrandViewModel by pagination.
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public GenericCollectionViewModel <BrandLightViewModel> GetLightModel(int?pageIndex, int?pageSize)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <Brand, long> condition = new ConditionFilter <Brand, long>
{
PageIndex = pageIndex,
PageSize = pageSize,
Query = (item =>
item.ParentKeyBrandId != null &&
item.Language == lang &&
item.ParentKeyBrand.ParentBrandId == null)
};
var entityCollection = this._BrandsRepository.Get(condition).ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToLightModel()).ToList();
//foreach (var item in dtoCollection)
//{
// foreach (var child in item.ChildBrands)
// {
// string name = "";
// if (lang == Language.Arabic)
// name = child.NameAr;
// else if (lang == Language.English)
// name = child.NameEn;
// child.DisplyedName = $"{child.Code}-{name}";
// }
//}
var result = new GenericCollectionViewModel <BrandLightViewModel>
{
Collection = dtoCollection,
TotalCount = dtoCollection.Count,
PageIndex = pageIndex,
PageSize = pageSize
};
return(result);
}
/// <summary>
/// Gets a BankMovementViewModel by its id.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public BankMovementViewModel Get(long id)
{
var entity = this._BankMovementsRepository.Get(id);
var model = entity.ToModel();
ConditionFilter <BankMovementCostCenters, long> condition = new ConditionFilter <BankMovementCostCenters, long>
{
Query = (item =>
item.BankMovementId == id)
};
var movementCostCenters = _bankMovementCostCentersRepository.Get(condition).ToList();
if (movementCostCenters.Any())
{
model.CostCenters = movementCostCenters.Select(x => x.ToModel()).ToList();
}
if (model.JournalTypeId == 13)
{
var bankMovements = this._closedChequeRepository.Get().Where(x => x.BankMovementId == id);
model.Cheques = this._donationsRepository.Get().Where(x => bankMovements.Any(c => c.DonationId == x.Id)).ToList().Select(x => x.ToChecksUnderCollectionModel()).ToList();
}
if (entity.ChildTranslatedBankMovements != null)
{
model.DescriptionAr = entity.ChildTranslatedBankMovements.FirstOrDefault(e =>
e.Language == Framework.Common.Enums.Language.Arabic).Description;
model.DescriptionEn = entity.ChildTranslatedBankMovements.FirstOrDefault(e =>
e.Language == Framework.Common.Enums.Language.English).Description;
}
return(model);
}
/// <summary>
/// عملة النظام
/// </summary>
/// <returns></returns>
public SystemCurrencySettingViewModel GetSystemCurrency()
{
var keys = this._SettingsRepository.Get().ToList();
var result = new SystemCurrencySettingViewModel
{
SystemCurrency = keys.FirstOrDefault(k => k.Key == "SystemCurrency").Value,
};
if (string.IsNullOrEmpty(result.SystemCurrency) == false)
{
try
{
result.CurrencyId = long.Parse(result.SystemCurrency);
}
catch (Exception ex)
{
}
}
if (result.CurrencyId.HasValue)
{
ConditionFilter <Currency, long> condition = new ConditionFilter <Currency, long>
{
Query = (x =>
x.Id == result.CurrencyId)
};
var currency = this._currencysRepository.Get(condition).FirstOrDefault();
if (currency != null)
{
result.Currency = currency.ToLightModel();
}
}
return(result);
}
/// <summary>
/// Gets a InventoryOpeningBalanceViewModel by vendor id.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public GenericCollectionViewModel <InventoryOpeningBalanceLookupViewModel> GetOpeningBalancesByVendorID(long id)
{
ConditionFilter <InventoryOpeningBalance, long> condition = new ConditionFilter <InventoryOpeningBalance, long>()
{
Query = (x => x.VendorId == id)
};
var entityCollection = this._InventoryOpeningBalancesRepository.Get(condition).ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToLookupModel()).ToList();
foreach (var item in dtoCollection)
{
foreach (var product in item.Products)
{
Brand brand = this._brandsRepository.Get().FirstOrDefault(x => x.Id == product.BrandId);
product.BrandName = $"{brand.Code}-{brand.ChildTranslatedBrands.FirstOrDefault(x => x.Language == this._languageService.CurrentLanguage).Name}";
}
}
var result = new GenericCollectionViewModel <InventoryOpeningBalanceLookupViewModel>
{
Collection = dtoCollection,
};
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
//public GenericCollectionViewModel<InventoryOpeningBalanceLightViewModel> GetByFilters(InventoryOpeningBalanceFilterViewModel model)
//{
// var lang = this._languageService.CurrentLanguage;
// ConditionFilter<InventoryOpeningBalance, long> condition = new ConditionFilter<InventoryOpeningBalance, long>()
// {
// Order = Order.Descending
// };
// if (model.Sort?.Count > 0)
// {
// if (model.Sort[0].Dir != "desc") condition.Order = Order.Ascending;
// }
// //model.DateFrom = model.DateFrom.SetTimeToNow();
// model.DateTo = model.DateTo.SetTimeToNow();
// if (model.DateFrom == null && model.DateTo == null && model.Inventory == null)
// {
// condition.Query = (x => x.ParentKeyInventoryOpeningBalanceId == null);
// }
// else if (model.DateFrom != null && model.DateTo == null && model.Inventory != null)
// {
// condition.Query = (x => x.ParentKeyInventoryOpeningBalanceId == null && x.CreationDate >= model.DateFrom && x.InventoryId == model.Inventory);
// }
// else if (model.DateFrom != null && model.DateTo == null && model.Inventory == null)
// {
// condition.Query = (x => x.ParentKeyInventoryOpeningBalanceId == null && x.CreationDate >= model.DateFrom);
// }
// else if (model.DateFrom == null && model.DateTo != null && model.Inventory != null)
// {
// condition.Query = (x => x.ParentKeyInventoryOpeningBalanceId == null && x.CreationDate <= model.DateTo && x.InventoryId == model.Inventory);
// }
// else if (model.DateFrom == null && model.DateTo != null && model.Inventory == null)
// {
// condition.Query = (x => x.ParentKeyInventoryOpeningBalanceId == null && x.CreationDate <= model.DateTo);
// }
// else if (model.DateFrom != null && model.DateTo != null && model.Inventory == null)
// {
// condition.Query = (x => x.ParentKeyInventoryOpeningBalanceId == null && x.CreationDate >= model.DateFrom && x.CreationDate <= model.DateTo);
// }
// else if (model.DateFrom == null && model.DateTo == null && model.Inventory != null)
// {
// condition.Query = (x => x.ParentKeyInventoryOpeningBalanceId == null && x.InventoryId == model.Inventory);
// }
// else if (model.DateFrom != null && model.DateTo != null && model.Inventory != null)
// {
// condition.Query = (x => x.ParentKeyInventoryOpeningBalanceId == null && x.CreationDate >= model.DateFrom && x.CreationDate <= model.DateTo &&
// x.InventoryId == model.Inventory);
// }
// var entityCollection = this._InventoryOpeningBalancesRepository.Get(condition).ToList();
// var dtoCollection = entityCollection.Select(entity => entity.ToLightModel()).ToList();
// foreach (var item in entityCollection)
// {
// var ViewModel = dtoCollection.Find(x => x.Id == item.Id);
// ViewModel.Description = item.ChildTranslatedInventoryOpeningBalance.FirstOrDefault(z => z.Language == lang).Description;
// if (item.Inventory != null)
// {
// ViewModel.Inventory = item.Inventory.ChildTranslatedInventorys.First(x => x.Language == lang).Name; ;
// }
// }
// if (model.Filters != null)
// {
// foreach (var item in model.Filters)
// {
// switch (item.Field)
// {
// case "description":
// dtoCollection = dtoCollection.Where(x => x.Description.Contains(item.Value)).ToList();
// break;
// case "code":
// dtoCollection = dtoCollection.Where(x => x.Code.Contains(item.Value)).ToList();
// break;
// default:
// break;
// }
// }
// }
// var total = dtoCollection.Count();
// dtoCollection = dtoCollection.Skip(model.PageIndex * model.PageSize).Take(model.PageSize).ToList();
// var result = new GenericCollectionViewModel<InventoryOpeningBalanceLightViewModel>
// {
// Collection = dtoCollection,
// TotalCount = total,
// PageIndex = model.PageIndex,
// PageSize = model.PageSize
// };
// return result;
//}
public GenericCollectionViewModel <InventoryOpeningBalanceLightViewModel> GetByFilter(InventoryOpeningBalanceFilterViewModel model)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <InventoryOpeningBalance, long> condition = new ConditionFilter <InventoryOpeningBalance, long>()
{
Order = Order.Descending
};
if (model.Sort?.Count > 0)
{
if (model.Sort[0].Dir != "desc")
{
condition.Order = Order.Ascending;
}
}
//if (model.DateFrom.HasValue) model.DateFrom = model.DateFrom.SetTimeToNow();
if (model.DateTo.HasValue)
{
model.DateTo = model.DateTo.SetTimeToMax();
}
// The IQueryable data to query.
IQueryable <InventoryOpeningBalance> queryableData = this._InventoryOpeningBalancesRepository.Get(condition);
queryableData = queryableData.Where(x => x.ParentKeyInventoryOpeningBalanceId.HasValue == false);
if (string.IsNullOrEmpty(model.Code) == false)
{
queryableData = queryableData.Where(x => x.Code.Contains(model.Code));
}
if (model.DateFrom.HasValue)
{
queryableData = queryableData.Where(x => x.Date >= model.DateFrom.Value);
}
if (model.DateTo.HasValue)
{
queryableData = queryableData.Where(x => x.Date <= model.DateTo.Value);
}
if (model.Inventory.HasValue)
{
queryableData = queryableData.Where(x => x.InventoryId == model.Inventory.Value);
}
if (string.IsNullOrEmpty(model.Description) == false)
{
queryableData = queryableData.Where(x =>
x.ChildTranslatedInventoryOpeningBalance.FirstOrDefault(y => y.Language == Language.Arabic).Description.Contains(model.Description));
}
if (string.IsNullOrEmpty(model.Description) == false)
{
queryableData = queryableData.Where(x =>
x.ChildTranslatedInventoryOpeningBalance.FirstOrDefault(y => y.Language == Language.English).Description.Contains(model.Description));
}
var entityCollection = queryableData.ToList();
foreach (var item in entityCollection)
{
item.Description = item.ChildTranslatedInventoryOpeningBalance.FirstOrDefault(z => z.Language == lang).Description;
if (item.Inventory != null)
{
item.Inventory.Name = item.Inventory.ChildTranslatedInventorys.FirstOrDefault(x => x.Language == lang).Name;
}
}
var dtoCollection = entityCollection.Select(entity => entity.ToLightModel()).ToList();
var total = dtoCollection.Count();
dtoCollection = dtoCollection.Skip(model.PageIndex * model.PageSize).Take(model.PageSize).ToList();
var result = new GenericCollectionViewModel <InventoryOpeningBalanceLightViewModel>
{
Collection = dtoCollection,
TotalCount = total,
PageIndex = model.PageIndex,
PageSize = model.PageSize
};
return(result);
}
/// <summary>
/// Gets a GenericCollectionViewModel of InventoryOpeningBalanceViewModel by condition.
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public GenericCollectionViewModel <InventoryOpeningBalanceLightViewModel> GetLightModel(ConditionFilter <InventoryOpeningBalance, long> condition)
{
var entityCollection = this._InventoryOpeningBalancesRepository.Get(condition).ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToLightModel()).ToList();
var result = new GenericCollectionViewModel <InventoryOpeningBalanceLightViewModel>
{
Collection = dtoCollection,
TotalCount = dtoCollection.Count,
PageIndex = condition.PageIndex,
PageSize = condition.PageSize
};
return(result);
}
public GenericCollectionViewModel <ListCostCenterLightViewModel> GetByFilter(CostCenterFilterViewModel model)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <CostCenter, long> condition = new ConditionFilter <CostCenter, long>()
{
Order = Order.Descending
};
if (model.Sort?.Count > 0)
{
if (model.Sort[0].Dir != "desc")
{
condition.Order = Order.Ascending;
}
}
//if (model.DateFrom.HasValue) model.DateFrom = model.DateFrom.SetTimeToNow();
//if (model.DateTo.HasValue) model.DateTo = model.DateTo.SetTimeToNow();
// The IQueryable data to query.
IQueryable <CostCenter> queryableData = this._CostCentersRepository.Get(condition);
queryableData = queryableData.Where(x => x.Language == lang && x.ParentKeyCostCenter != null);
if (string.IsNullOrEmpty(model.Code) == false)
{
queryableData = queryableData.Where(x => x.ParentKeyCostCenter.Code.Contains(model.Code));
}
if (string.IsNullOrEmpty(model.Name) == false)
{
queryableData = queryableData.Where(x => x.Name.Contains(model.Name));
}
if (model.OpeningCreditFrom.HasValue)
{
queryableData = queryableData.Where(x => x.ParentKeyCostCenter.OpeningCredit >= model.OpeningCreditFrom);
}
if (model.OpeningCreditTo.HasValue)
{
queryableData = queryableData.Where(x => x.ParentKeyCostCenter.OpeningCredit <= model.OpeningCreditTo);
}
if (model.CostCenterTypeId.HasValue)
{
queryableData = queryableData.Where(x => x.ParentKeyCostCenter.CostCenterTypeId == model.CostCenterTypeId);
}
//if (model.DateFrom.HasValue)
// queryableData = queryableData.Where(x => x.ParentKeyBank.Date >= model.DateFrom);
//if (model.DateTo.HasValue)
// queryableData = queryableData.Where(x => x.ParentKeyBank.Date <= model.DateTo);
//if (model.IsActive != null)
// queryableData = queryableData.Where(x => x.IsActive);
var entityCollection = queryableData.ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToListModel()).ToList();
//foreach (var item in entityCollection)
//{
// //var ViewModel = dtoCollection.Find(x => x.Id == item.ParentKeyCostCenterId);
// //ViewModel.Name = item.ChildTranslatedCostCenters.FirstOrDefault(x => x.Language == lang).Name;
// //ViewModel.Description = item.ChildTranslatedCostCenters.FirstOrDefault(x => x.Language == lang).Description;
// //if (item.ParentKeyBank != null)
// //{
// // ViewModel.BankName = item.ParentKeyBank.ChildTranslatedBanks.First(x => x.Language == lang).Name;
// //}
//}
//if (model.Filters != null)
//{
// foreach (var item in model.Filters)
// {
// switch (item.Field)
// {
// case "source":
// dtoCollection = dtoCollection.Where(x => x.Source.Contains(item.Value)).ToList();
// break;
// case "amount":
// dtoCollection = dtoCollection.Where(x => x.Amount.Equals(Convert.ToDecimal(item.Value))).ToList();
// break;
// default:
// break;
// }
// }
//}
var total = dtoCollection.Count();
dtoCollection = dtoCollection.Skip(model.PageIndex * model.PageSize).Take(model.PageSize).ToList();
var result = new GenericCollectionViewModel <ListCostCenterLightViewModel>
{
Collection = dtoCollection,
TotalCount = total,
PageIndex = model.PageIndex,
PageSize = model.PageSize
};
return(result);
}
public GenericCollectionViewModel <ListCurrencyRateLightViewModel> GetByFilter(CurrencyRateFilterViewModel model)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <CurrencyRate, long> condition = new ConditionFilter <CurrencyRate, long>()
{
Order = Framework.Common.Enums.Order.Descending
};
if (model.Sort?.Count > 0)
{
if (model.Sort[0].Dir != "desc")
{
condition.Order = Framework.Common.Enums.Order.Ascending;
}
}
//if (model.DateFrom.HasValue) model.DateFrom = model.DateFrom.SetTimeToNow();
if (model.DateTo.HasValue)
{
model.DateTo = model.DateTo.SetTimeToMax();
}
// The IQueryable data to query.
IQueryable <CurrencyRate> queryableData = this._CurrencyRatesRepository.Get(condition);
//queryableData = queryableData.Where(x => x.Language == lang && x.ParentKeyCurrencyRate != null);
queryableData = queryableData.Where(x => x.ParentKeyCurrencyRate == null);
if (model.Currency.HasValue)
{
queryableData = queryableData.Where(x => x.CurrencyId == model.Currency);
}
if (model.ExchangeCurrency.HasValue)
{
queryableData = queryableData.Where(x => x.ExchangeCurrencyId == model.ExchangeCurrency);
}
if (model.PriceFrom.HasValue)
{
queryableData = queryableData.Where(x => x.Price >= model.PriceFrom);
}
if (model.PriceTo.HasValue)
{
queryableData = queryableData.Where(x => x.Price <= model.PriceTo);
}
if (model.DateFrom.HasValue)
{
queryableData = queryableData.Where(x => x.Date >= model.DateFrom);
}
if (model.DateTo.HasValue)
{
queryableData = queryableData.Where(x => x.Date <= model.DateTo);
}
var entityCollection = queryableData.ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToListModel()).ToList();
foreach (var item in entityCollection)
{
var ViewModel = dtoCollection.Find(x => x.Id == item.Id);
ViewModel.Currency = item.Currency.ChildTranslatedCurrencys.FirstOrDefault(x => x.Language == lang).Name;
ViewModel.ExchangeCurrency = item.ExchangeCurrency.ChildTranslatedCurrencys.FirstOrDefault(x => x.Language == lang).Name;
//if (item.ParentKeyBank != null)
//{
// ViewModel.BankName = item.ParentKeyBank.ChildTranslatedBanks.First(x => x.Language == lang).Name;
//}
}
//if (model.Filters != null)
//{
// foreach (var item in model.Filters)
// {
// switch (item.Field)
// {
// case "source":
// dtoCollection = dtoCollection.Where(x => x.Source.Contains(item.Value)).ToList();
// break;
// case "amount":
// dtoCollection = dtoCollection.Where(x => x.Amount.Equals(Convert.ToDecimal(item.Value))).ToList();
// break;
// default:
// break;
// }
// }
//}
var total = dtoCollection.Count();
dtoCollection = dtoCollection.Skip(model.PageIndex * model.PageSize).Take(model.PageSize).ToList();
var result = new GenericCollectionViewModel <ListCurrencyRateLightViewModel>
{
Collection = dtoCollection,
TotalCount = total,
PageIndex = model.PageIndex,
PageSize = model.PageSize
};
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public GenericCollectionViewModel <ListPurchasLightViewModel> GetByFilter(PurchasInvoiceFilterViewModel model)
{
var lang = this._languageService.CurrentLanguage;
ConditionFilter <PurchaseInvoice, long> condition = new ConditionFilter <PurchaseInvoice, long>()
{
Order = Order.Descending
};
if (model.Sort?.Count > 0)
{
if (model.Sort[0].Dir != "desc")
{
condition.Order = Order.Ascending;
}
}
//if (model.DateFrom.HasValue) model.DateFrom = model.DateFrom.SetTimeToNow();
if (model.DateTo.HasValue)
{
model.DateTo = model.DateTo.SetTimeToMax();
}
IQueryable <PurchaseInvoice> queryableData = this._PurchaseInvoicesRepository.Get(condition);
//queryableData = queryableData.Where(x => x.Language == lang && x.ParentKeyVendor != null);
if (string.IsNullOrEmpty(model.Id) == false)
{
queryableData = queryableData.Where(x => x.Id.ToString().Contains(model.Id));
}
if (string.IsNullOrEmpty(model.Code) == false)
{
queryableData = queryableData.Where(x => x.Code.Contains(model.Code));
}
if (model.Vendor.HasValue)
{
queryableData = queryableData.Where(x => x.VendorId == model.Vendor);
}
if (model.Inventory.HasValue)
{
queryableData = queryableData.Where(x => x.InventoryId == model.Inventory);
}
if (model.DateFrom.HasValue)
{
queryableData = queryableData.Where(x => x.Date >= model.DateFrom);
}
if (model.DateTo.HasValue)
{
queryableData = queryableData.Where(x => x.Date <= model.DateTo);
}
var entityCollection = queryableData.ToList();
var dtoCollection = entityCollection.Select(entity => entity.ToListModel()).ToList();
foreach (var item in entityCollection)
{
var ViewModel = dtoCollection.Find(x => x.Id == item.Id);
//ViewModel.Amount = item.Amount.ToString() + " " + item.Currency.ChildTranslatedCurrencys.FirstOrDefault(z => z.Language == lang).Name;
if (item.Vendor != null)
{
ViewModel.Vendor = item.Vendor.ChildTranslatedVendors.First(x => x.Language == lang).Name;
}
if (item.Inventory != null)
{
ViewModel.Inventory = item.Inventory.ChildTranslatedInventorys.First(x => x.Language == lang).Name;;
}
}
var total = dtoCollection.Count();
dtoCollection = dtoCollection.Skip(model.PageIndex * model.PageSize).Take(model.PageSize).ToList();
var result = new GenericCollectionViewModel <ListPurchasLightViewModel>
{
Collection = dtoCollection,
TotalCount = total,
PageIndex = model.PageIndex,
PageSize = model.PageSize
};
return(result);
}
/// <summary>
/// Add an entity.
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
/// p<InventoryOpeningBalanceAddViewModel, InventoryOpeningBalance>
public InventoryOpeningBalanceAddViewModel AddInventoryOpeningBalance(InventoryOpeningBalanceAddViewModel model)
{
this._closedMonthsService.ValidateIfMonthIsClosed(model.Date);
DateTime CurrentDate = DateTime.Now;
var entity = model.ToEntity();
foreach (var item in entity.Products)
{
item.CreationDate = CurrentDate;
item.InventoryId = long.Parse(model.InventoryId);
}
foreach (var item in entity.InventoryOpeningBalanceCostCenter)
{
item.CreationDate = CurrentDate;
}
#region translation
entity.Description = "";
entity.CreationDate = CurrentDate;
entity.Code = model.Code;
entity.Language = Language.None;
InventoryOpeningBalance InventoryOpeningBalanceAr = new InventoryOpeningBalance();
InventoryOpeningBalanceAr.Description = model.DescriptionAr;
InventoryOpeningBalanceAr.Language = Language.Arabic;
InventoryOpeningBalanceAr.CreationDate = CurrentDate;
InventoryOpeningBalance InventoryOpeningBalanceEn = new InventoryOpeningBalance();
InventoryOpeningBalanceEn.Description = model.DescriptionEn;
InventoryOpeningBalanceEn.Language = Language.English;
InventoryOpeningBalanceEn.CreationDate = CurrentDate;
entity.ChildTranslatedInventoryOpeningBalance.Add(InventoryOpeningBalanceAr);
entity.ChildTranslatedInventoryOpeningBalance.Add(InventoryOpeningBalanceEn);
#endregion
//foreach (var item in entity.Products.ToList())
//{
// ConditionFilter<Product, long> ProductCondition = new ConditionFilter<Product, long>();
// long InventoryId = long.Parse(model.InventoryId);
// ProductCondition.Query = x => x.InventoryOpeningBalance.InventoryId == InventoryId && x.BrandId==item.BrandId;
// var product = this._ProductsRepository.Get(ProductCondition).FirstOrDefault();
// if (product != null)
// {
// product.Quantity += item.Quantity;
// this._ProductsRepository.Update(product);
// entity.Products.Remove(item);
// }
//}
entity = this._InventoryOpeningBalancesRepository.Add(entity);
#region Commit Changes
this._unitOfWork.Commit();
#endregion
#region Generate New Code
try
{
ConditionFilter <InventoryOpeningBalance, long> condition = new ConditionFilter <InventoryOpeningBalance, long>
{
Query = x =>
x.ParentKeyInventoryOpeningBalanceId == null &&
string.IsNullOrEmpty(x.Code) == false
,
Order = Order.Descending
};
var z = this._InventoryOpeningBalancesRepository.Get(condition);
var lastEntity = z.FirstOrDefault();
long newCode = 1;
if (lastEntity != null)
{
try
{
newCode = long.Parse(lastEntity.Code) + 1;
}
catch
{
newCode = entity.Id;
}
}
entity.Code = newCode.ToString();
}
catch
{
entity.Code = entity.Id.ToString();
}
entity = this._InventoryOpeningBalancesRepository.Update(entity);
this._unitOfWork.Commit();
#endregion
model.Id = entity.Id;
model.Code = entity.Code;
//model = entity.ToModel();
return(model);
}
public void LevelMatchFilter_ThrowsIfLevelIsNotSetAtInitialization()
{
ConditionFilter filter = new ConditionFilter();
filter.Initialize(new InitializationContext(null, null));
}
