public int InsertOrderHistory(int StoreId, int LoggedInUserId, OrderHistoryEntity objHistoryEntity) { var ParameterStoreId = new SqlParameter { ParameterName = "StoreId", DbType = DbType.Int32, Value = StoreId }; var ParameterLoggedInUserId = new SqlParameter { ParameterName = "LoggedInUserId", DbType = DbType.Int32, Value = LoggedInUserId }; var paramOrderId = new SqlParameter { ParameterName = "order_id", DbType = DbType.Int32, Value = objHistoryEntity.order_id }; var paramnotify = new SqlParameter { ParameterName = "notify", DbType = DbType.Int32, Value = objHistoryEntity.notify }; var paramcomment = new SqlParameter { ParameterName = "comment", DbType = DbType.String, Value = objHistoryEntity.comment }; var paramorderStatusId = new SqlParameter { ParameterName = "order_status_id", DbType = DbType.Int32, Value = objHistoryEntity.order_status_id }; int result = objGenericRepository.ExecuteSQL <int>("InsertOrderHistory", paramOrderId, paramnotify, paramcomment, paramorderStatusId).FirstOrDefault(); return(result); }
public Task AddAsync(IOrderHistory order, ITrade trade) { var entity = OrderHistoryEntity.Create(order); // ReSharper disable once RedundantArgumentDefaultValue //TODO: use event datetime return(_tableStorage.InsertAndGenerateRowKeyAsDateTimeAsync(entity, DateTime.UtcNow, RowKeyDateTimeFormat.Iso)); }
public void Create(OrderHistory orderHistory) { string date = DateTime.UtcNow.ToString("MM-dd-yyyy"); string time = DateTime.Now.ToString("HH:mm"); var Entity = new OrderHistoryEntity { CustomerId = orderHistory.CustomerId, LocationId = orderHistory.LocationId, Date = date, Time = time }; _context.OrderHistoryEntity.Add(Entity); _context.SaveChanges(); }
private async Task DoAdd(SqlConnection conn, SqlTransaction transaction, IOrderHistory order, ITrade trade) { var orderHistoryEntity = OrderHistoryEntity.Create(order); await conn.ExecuteAsync( $"insert into {TableName} ({GetColumns}) values ({GetFields})", orderHistoryEntity, transaction); if (trade != null) { var tradeEntity = TradeEntity.Create(trade); await conn.ExecuteAsync( $"insert into {TradesSqlRepository.TableName} ({TradesSqlRepository.GetColumns}) values ({TradesSqlRepository.GetFields})", tradeEntity, transaction); } }
public HttpResponseMessage InsertOrderHistory(int StoreId, int LoggedInUserId, OrderHistoryEntity objHistoryEntity) { try { var result = _orderService.InsertOrderHistory(StoreId, LoggedInUserId, objHistoryEntity); return(Request.CreateResponse(HttpStatusCode.OK, result)); } catch (Exception) { throw; } }