public List <CustomerSingleModel> GetAll()
{
using (var db = new EntityContext())
{
var customerList = customerUtility.GetAllCustomer(db);
if (customerList != null)
{
List <CustomerSingleModel> customerModel = customerList.Select(r => new CustomerSingleModel
{
Id = r.Id,
Status = r.Status.Status,
Address = r.Address,
BCEL_Baht = r.BCEL_Baht,
BCEL_Dollar = r.BCEL_Dollar,
BCEL_Kip = r.BCEL_Kip,
isDeleted = r.isDeleted,
Password = r.Password,
Phonenumber = r.Phonenumber
}).ToList();
return(customerModel);
}
else
{
return(new List <CustomerSingleModel>());
}
}
}
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());
}
}