public async Task <IHttpActionResult> Post(OrderStatisticViewModel model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var stf = await _orderStatisticService.InsertAsync(model, GetCurrentUserID()); _unitOfWorkAsync.Commit(); var resultObject = new OrderStatisticViewModel() { ID = stf.Id, OrderDetailId = stf.OrderDetailId, OrderId = stf.OrderId, ProductAttributeId = stf.ProductAttributeId, ProductAttributeName = stf.ProductAttributeName, ProductAttributeNote = stf.ProductAttributeNote, Serial = stf.Serial, CreatDate = DateTime.Now, LastModifiedDate = DateTime.Now }; return(Created(resultObject)); } catch (Exception ex) { throw ex; } }
public bool Update(OrderStatisticViewModel model, string CurrentId) { var data = Find(model.ID); if (data != null) { data.ProductAttributeNote = model.ProductAttributeNote; data.Serial = model.Serial; data.LastModifiedDate = DateTime.Now; } return(true); }
public async Task <OrderStatisticViewModel> UpdateAsync(OrderStatisticViewModel model, string CurrentId) { try { await Task.Run(() => Update(model, CurrentId)); return(model); } catch (Exception e) { throw (e); } }
public OrderStatistic Insert(OrderStatisticViewModel model, string CurrentId) { var data = new OrderStatistic(); data.OrderDetailId = model.OrderDetailId; data.OrderId = model.OrderId; data.CreatDate = DateTime.Now; data.LastModifiedDate = DateTime.Now; data.ProductAttributeId = model.ProductAttributeId; data.ProductAttributeName = model.ProductAttributeName; data.ProductAttributeNote = model.ProductAttributeNote; data.Serial = model.Serial; data.Delete = false; base.Insert(data); return(data); }
public async Task <IHttpActionResult> Put(Guid key, OrderStatisticViewModel model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { await _orderStatisticService.UpdateAsync(model, GetCurrentUserID()); _unitOfWorkAsync.Commit(); return(Updated(model)); } catch (Exception e) { throw e; } }
public IQueryable <OrderDetailViewModel> GetOrderDetailByOrder(SearchViewModel model) { var result = Queryable().Where(x => x.Delete == false && ((!model.From.HasValue) || (DbFunctions.TruncateTime(x.CreatDate) >= DbFunctions.TruncateTime(model.From))) && ((!model.To.HasValue) || (DbFunctions.TruncateTime(x.CreatDate) <= DbFunctions.TruncateTime(model.To)))). Select(x => new OrderDetailViewModel { ID = x.Id, ProductID = x.ProductId, ProductName = x.ProductName, Quantity = x.Quantity, Price = x.Price, Serial = x.Serial, CreatDate = x.CreatDate, IsGift = x.IsGift, UserName = x.UserAccount.UserName, OrderCode = x.Order.Code, OrderID = x.Order.Id }).ToList(); if (result != null) { foreach (var item in result) { var r = _orderStatisticService.Queryable().Where(x => x.Delete == false && x.OrderDetailId == item.ID).ToList(); if (r != null) { foreach (var item1 in r) { var a = new OrderStatisticViewModel(); a.ProductAttributeName = item1.ProductAttributeName; a.ProductAttributeId = item1.ProductAttributeId; a.ProductAttributeNote = item1.ProductAttributeNote; a.Serial = item1.Serial; a.ID = item1.Id; item.OrderStatistics.Add(a); } } } } return(result.AsQueryable()); }
public async Task <OrderStatistic> InsertAsync(OrderStatisticViewModel model, string CurrentId) { return(await Task.Run(() => Insert(model, CurrentId))); }