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 <ItemSingleModel> GetItemsByStatusForCustomer(int CustId, int statusId)
{
using (var db = new EntityContext())
{
var items = itemsUtility.GetAllItem(db)
.Where(x => x.Customer.Id == CustId && x.Status.Id == statusId);
var model = itemsUtility.AssingItemsProperty(items.ToList());
return(model);
}
}
public CustomerProfileModel CustomerProfile(int CustId)
{
using (var db = new EntityContext())
{
TbCustomer customer = customerUtility.GetCustomerById(db, CustId);
CustomerSingleModel customerModelSource = customerUtility.CustomerSingleModelProperty(customer);
List <TbItems> items = db.TbItems
.Include(i => i.Customer)
.Include(i => i.Status)
.Where(i => i.Customer.Id == CustId).ToList();
List <ItemSingleModel> itemsModelSource = new List <ItemSingleModel>();
if (items != null)
{
itemsModelSource = itemsUtility.AssingItemsProperty(items);
}
;
CustomerProfileModel profile = new CustomerProfileModel
{
customerModel = customerModelSource,
itemsModel = itemsModelSource
};
return(profile);
}
}
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);
}
}
