C# (CSharp) ACSDining.Infrastructure.DTO.SuperUser.Orders.UpdateUserOrderDto Examples

Example #1

        /// <summary>
        /// Обновляет пользовательский заказ со стороны SU - только факт
        /// </summary>
        /// <param name="context"></param>
        /// <param name="userOrderDto"></param>
        /// <returns></returns>
        public static void UpdateDishQuantityBySu(this ApplicationDbContext context, UpdateUserOrderDto userOrderDto)
        {
            var dayorderidParameter = new SqlParameter("@Dayorderid", userOrderDto.DayOrderId);
            var dishtypeidParameter = new SqlParameter("@Dishtypeid", userOrderDto.CategoryId);
            var quantityParameter   = new SqlParameter("@Quantity", userOrderDto.Quantity);

            context.Database.ExecuteSqlCommand("exec UpdateDishQuantityBySU @Dayorderid,@Dishtypeid,@Quantity",
                                               dayorderidParameter, dishtypeidParameter, quantityParameter);
        }

Example #2

File: ContextStoredFunctions.cs Project: densem-2013/ACSDining

        /// <summary>
        /// Обновляет пользовательский заказ со стороны SU - только факт
        /// </summary>
        /// <param name="context"></param>
        /// <param name="userOrderDto"></param>
        /// <returns></returns>
        public static void UpdateDishQuantityBySu(this ApplicationDbContext context, UpdateUserOrderDto userOrderDto)
        {
            var dayorderidParameter = new SqlParameter("@Dayorderid", userOrderDto.DayOrderId);
            var dishtypeidParameter = new SqlParameter("@Dishtypeid", userOrderDto.CategoryId);
            var quantityParameter = new SqlParameter("@Quantity", userOrderDto.Quantity);

            context.Database.ExecuteSqlCommand("exec UpdateDishQuantityBySU @Dayorderid,@Dishtypeid,@Quantity",
                dayorderidParameter, dishtypeidParameter, quantityParameter);
        }