public CustomerProfileItemsModel GetCustomerProfileItems(int customerId)
{
using (var db = new EntityContext())
{
var sourceCustomer = _customer.GetSingle(db, customerId);
var sourceItem = _item.GetAll(db).Where(i => i.Customer.Id == customerId).ToList();
CustomerProfileItemsModel result = new CustomerProfileItemsModel
{
Profile = _customer.AssignCustomerProfile(sourceCustomer),
Items = _item.AssignItemsList(sourceItem)
};
return(result);
}
}
public List <ItemsModel> GetUnConlidateItems(int customerId)
{
using (var db = new EntityContext())
{
var source = _item.GetAll(db).Where(i => i.Customer.Id == customerId && (i.Status.Id == 6 || i.Status.Id == 10) &&
!db.tbConsolidatedItems.Select(x => x.Items.Id).Contains(i.Id)).ToList();
if (source != null)
{
List <ItemsModel> result = _item.AssignItemsList(source.ToList());
return(result);
}
else
{
return(new List <ItemsModel>());
}
}
}
public List <ItemsModel> GetProductByCustomerId(int CustomerId, DateTime?CreateDate, DateTime?SubmitDate, string Status)
{
using (var db = new EntityContext())
{
List <TbItems> source = _item.GetAll(db).Where(i => i.Customer.Id == CustomerId).ToList();
if (CreateDate != null)
{
source = source.Where(i => i.CreatedDate == CreateDate).ToList();
}
if (SubmitDate != null)
{
source = source.Where(i => i.ConfrimDate == SubmitDate).ToList();
}
if (!string.IsNullOrEmpty(Status))
{
if (db.tbItemStatuses.Any(x => x.Status == Status))
{
source = source.Where(i => i.Status.Status == Status).ToList();
}
}
if (source != null)
{
List <ItemsModel> model = _item.AssignItemsList(source);
return(model);
}
else
{
return(new List <ItemsModel>());
}
}
}
