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>()); } } }