public List <ItemSingleModel> GetAll()
{
using (var db = new EntityContext())
{
var items = itemsUtility.GetAllItem(db).ToList(); //Get data from database
var model = itemsUtility.AssingItemsProperty(items); //post data to model
return(model);
}
}
public List <CustomerItemModel> GetCustomerList()
{
using (var db = new EntityContext())
{
var customers = customerUtility.GetAllCustomer(db);
List <CustomerItemModel> model = new List <CustomerItemModel>();
foreach (var customer in customers)
{
CustomerItemModel ci = new CustomerItemModel();
ci.CustomerId = customer.Id;
ci.CustomerName = customer.Name;
ci.CountItems = itemsUtility.GetAllItem(db).Count(i => i.Customer.Id == customer.Id);
ci.CountItemsToPickup = itemsUtility.GetAllItem(db).Count(i => i.Customer.Id == customer.Id && i.Status.Id == 2);
ci.CountItemsPickedUp = itemsUtility.GetAllItem(db).Count(i => i.Customer.Id == customer.Id && i.Status.Id == 3);
ci.CountItemsInProcess = itemsUtility.GetAllItem(db).Count(i => i.Customer.Id == customer.Id && i.Status.Id == 4);
ci.CountItemsToSend = itemsUtility.GetAllItem(db).Count(i => i.Customer.Id == customer.Id && i.Status.Id == 5);
ci.CountItemsAlreadySend = itemsUtility.GetAllItem(db).Count(i => i.Customer.Id == customer.Id && i.Status.Id == 6);
ci.CountItemsCannotContact = itemsUtility.GetAllItem(db).Count(i => i.Customer.Id == customer.Id && i.Status.Id == 7);
model.Add(ci);
}
return(model.ToList());
}
}
public ConsolidatedItemsModel GetItems(int consolidatedId)
{
using (var db = new EntityContext())
{
var source = db.tbConsolidateLists
.Include(x => x.Customer)
.FirstOrDefault(x => x.Id == consolidatedId);
var itemsource = _itemUtility.GetAllItem(db).Where(x => db.tbConsolidatedItems.Where(c => c.Consolidator.Id == consolidatedId).Select(c => c.Items.Id).Contains(x.Id)).ToList();
ConsolidatedItemsModel model = new ConsolidatedItemsModel
{
ConsolidationId = source.Id,
ConsolidationNumber = source.ConsolidateNumber,
Customername = source.Customer.Name,
CustomerPhonenumber = source.Customer.Phonenumber,
Items = _itemUtility.AssingItemsProperty(itemsource)
};
return(model);
}
}
