public async Task <int> UpdateOrderDetailStatus(OrderStatusHistory obj) { try { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@OrderStatusHistoryId", obj.OrderStatusHistoryId); parameters.Add("@OrderDetailsID", obj.OrderDetailsID); parameters.Add("@OrderStatusId", obj.OrderStatusId); parameters.Add("@CreatedDate", obj.CreatedDate); parameters.Add("@CreatedBy", obj.CreatedBy); parameters.Add("@OrderId", obj.OrderId); parameters.Add("@SetNo", obj.SetNo); parameters.Add("@ProductId", obj.ProductId); if (obj.OrderStatusId == 3) { parameters.Add("@TransportID", obj.TransportID); parameters.Add("@DispatchDate", obj.DispatchDate); parameters.Add("@Bilty", obj.Bilty); } var res = await SqlMapper.ExecuteAsync(con, "p_OrderStatusHistory_ins", param : parameters, commandType : StoredProcedure); return(Convert.ToInt32(res)); } catch (Exception ex) { throw (ex); } }
public string CreateOrderFromCart(Order order) { var autoNumber = context.AutoNumbers.FirstOrDefault(num => num.FormCode == "Order" && num.Year == DateTime.Today.Year) ?? new AutoNumber { FormCode = "Order", Year = DateTime.Today.Year, LastNumber = 0 }; if (autoNumber.LastNumber == 0) { context.Add(autoNumber); } autoNumber.LastNumber++; context.Add(order); string prefix = String.Empty; order.OrderNo = String.Format("{0}{1}{2}", prefix.RandomLetters(3).ToUpper(), DateTime.Today.Year, autoNumber.LastNumber.ToString("00000")); SetAuditFields(order); var orderStatusHistory = new OrderStatusHistory(); orderStatusHistory.Order = order; orderStatusHistory.IsActive = true; orderStatusHistory.OrderStatusId = (int)OrderStatuses.Unpaid; orderStatusHistory.CreatedBy = principal.Identity.Name; orderStatusHistory.CreatedDate = DateTime.Now; orderStatusHistory.EffectiveDate = DateTime.Today; context.Add(orderStatusHistory); context.SaveChanges(); return(order.OrderNo); }
public void SetStatusOrder(int orderId, int orderStatusId, string notes, bool sendMail) { var order = context.Orders.SingleOrDefault(o => o.Id == orderId); if (order != null) { order.OrderStatusId = orderStatusId; var orderStatusHistory = new OrderStatusHistory(); orderStatusHistory.OrderId = orderId; orderStatusHistory.IsActive = true; orderStatusHistory.Notes = notes; orderStatusHistory.SendMail = sendMail; orderStatusHistory.OrderStatusId = orderStatusId; orderStatusHistory.CreatedBy = principal.Identity.Name; orderStatusHistory.EffectiveDate = DateTime.Today; orderStatusHistory.CreatedDate = DateTime.Now; context.Add(orderStatusHistory); context.SaveChanges(); } }
public Task <int> UpdateOrderDetailStatus(OrderStatusHistory obj) { return(_OrderRepository.UpdateOrderDetailStatus(obj)); }