Пример #1
0
            public OrdersRow AddOrdersRow(string CustomerID, EmployeesRow parentEmployeesRowByEmployeesOrders, System.DateTime OrderDate, string ShipAddress, string ShipName, System.DateTime ShippedDate)
            {
                OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));

                rowOrdersRow.ItemArray = new object[] {
                    CustomerID,
                    parentEmployeesRowByEmployeesOrders[0],
                    OrderDate,
                    null,
                    ShipAddress,
                    ShipName,
                    ShippedDate
                };
                this.Rows.Add(rowOrdersRow);
                return(rowOrdersRow);
            }
Пример #2
0
            public OrdersRow AddOrdersRow(System.DateTime OrderDate, System.DateTime RequiredDate, System.DateTime ShippedDate, int ShipVia, decimal Freight, string ShipName, string ShipPostalCode, string ShipCountry)
            {
                OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));

                rowOrdersRow.ItemArray = new object[] {
                    null,
                    OrderDate,
                    RequiredDate,
                    ShippedDate,
                    ShipVia,
                    Freight,
                    ShipName,
                    ShipPostalCode,
                    ShipCountry
                };
                this.Rows.Add(rowOrdersRow);
                return(rowOrdersRow);
            }
Пример #3
0
            public OrdersRow AddOrdersRow(int OrderID, int ProductID, string ProductName, decimal UnitPrice, short Quantity, float Discount, decimal Extended_Price, System.DateTime OrderDate)
            {
                OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));

                object[] columnValuesArray = new object[] {
                    OrderID,
                    ProductID,
                    ProductName,
                    UnitPrice,
                    Quantity,
                    Discount,
                    Extended_Price,
                    OrderDate
                };
                rowOrdersRow.ItemArray = columnValuesArray;
                this.Rows.Add(rowOrdersRow);
                return(rowOrdersRow);
            }
            public OrdersRow AddOrdersRow(CustomersRow parentCustomersRowByCustomersOrders, System.DateTime OrderDate, System.Decimal Freight, string ShipAddress, string ShipName, string ShipCity, string ShipPostalCode, string ShipCountry)
            {
                OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));

                rowOrdersRow.ItemArray = new object[] {
                    null,
                    parentCustomersRowByCustomersOrders[0],
                    OrderDate,
                    Freight,
                    ShipAddress,
                    ShipName,
                    ShipCity,
                    ShipPostalCode,
                    ShipCountry
                };
                this.Rows.Add(rowOrdersRow);
                return(rowOrdersRow);
            }
Пример #5
0
            public OrdersRow AddOrdersRow(string CustomerID, int EmployeeID, System.DateTime OrderDate, System.DateTime RequiredDate, System.DateTime ShippedDate, int ShipVia, System.Decimal Freight, string ShipName, string ShipAddress, string ShipCity, string ShipRegion, string ShipPostalCode, string ShipCountry)
            {
                OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));

                rowOrdersRow.ItemArray = new object[] {
                    null,
                    CustomerID,
                    EmployeeID,
                    OrderDate,
                    RequiredDate,
                    ShippedDate,
                    ShipVia,
                    Freight,
                    ShipName,
                    ShipAddress,
                    ShipCity,
                    ShipRegion,
                    ShipPostalCode,
                    ShipCountry
                };
                this.Rows.Add(rowOrdersRow);
                return(rowOrdersRow);
            }
Пример #6
0
 public void AddOrdersRow(OrdersRow row)
 {
     this.Rows.Add(row);
 }
 public OrdersRowChangeEvent(OrdersRow row, global::System.Data.DataRowAction action) {
     this.eventRow = row;
     this.eventAction = action;
 }
 public OrdersRow AddOrdersRow(
             string OrderNo, 
             string OrderType, 
             double OrderValue, 
             System.DateTime OrderDate, 
             double PaidValue, 
             double OutstandingValue, 
             System.DateTime RequiredDate, 
             double DeliveryCost, 
             string DeliveryNumber, 
             int PaymentType, 
             double PaymentValue, 
             string Remarks, 
             CompaniesRow parentCompaniesRowByFK_Orders_Companies, 
             string CompanyCode, 
             string CompanyName, 
             CurrenciesRow parentCurrenciesRowByFK_Orders_Currencies, 
             string CurrencyCode, 
             string CurrencyName, 
             OrdersRow parentOrdersRowByFK_Orders_Parent, 
             string ParentNo, 
             System.DateTime ParentDate, 
             double ParentValue, 
             int WarehouseID, 
             string WarehouseCode, 
             string WarehouseName) {
     OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));
     object[] columnValuesArray = new object[] {
             null,
             OrderNo,
             OrderType,
             OrderValue,
             OrderDate,
             PaidValue,
             OutstandingValue,
             RequiredDate,
             DeliveryCost,
             DeliveryNumber,
             PaymentType,
             PaymentValue,
             Remarks,
             null,
             CompanyCode,
             CompanyName,
             null,
             CurrencyCode,
             CurrencyName,
             null,
             ParentNo,
             ParentDate,
             ParentValue,
             WarehouseID,
             WarehouseCode,
             WarehouseName};
     if ((parentCompaniesRowByFK_Orders_Companies != null)) {
         columnValuesArray[13] = parentCompaniesRowByFK_Orders_Companies[0];
     }
     if ((parentCurrenciesRowByFK_Orders_Currencies != null)) {
         columnValuesArray[16] = parentCurrenciesRowByFK_Orders_Currencies[0];
     }
     if ((parentOrdersRowByFK_Orders_Parent != null)) {
         columnValuesArray[19] = parentOrdersRowByFK_Orders_Parent[0];
     }
     rowOrdersRow.ItemArray = columnValuesArray;
     this.Rows.Add(rowOrdersRow);
     return rowOrdersRow;
 }
 public OrderDetailsRow AddOrderDetailsRow(OrdersRow parentOrdersRowByFK_OrderDetails_Orders, ItemsRow parentItemsRowByFK_OrderDetails_Items, string ItemCode, string ItemName, string MeasureCode, string MeasureName, double Quantity, double UnitPrice, double TaxPct, int TrxType, string Remarks, OrdersRow parentOrdersRowByFK_OrderDetails_Reference, string ReferenceNo, System.DateTime ReferenceDate, double ReferenceValue) {
     OrderDetailsRow rowOrderDetailsRow = ((OrderDetailsRow)(this.NewRow()));
     object[] columnValuesArray = new object[] {
             null,
             null,
             null,
             ItemCode,
             ItemName,
             MeasureCode,
             MeasureName,
             Quantity,
             UnitPrice,
             TaxPct,
             TrxType,
             Remarks,
             null,
             ReferenceNo,
             ReferenceDate,
             ReferenceValue};
     if ((parentOrdersRowByFK_OrderDetails_Orders != null)) {
         columnValuesArray[1] = parentOrdersRowByFK_OrderDetails_Orders[0];
     }
     if ((parentItemsRowByFK_OrderDetails_Items != null)) {
         columnValuesArray[2] = parentItemsRowByFK_OrderDetails_Items[0];
     }
     if ((parentOrdersRowByFK_OrderDetails_Reference != null)) {
         columnValuesArray[12] = parentOrdersRowByFK_OrderDetails_Reference[0];
     }
     rowOrderDetailsRow.ItemArray = columnValuesArray;
     this.Rows.Add(rowOrderDetailsRow);
     return rowOrderDetailsRow;
 }
Пример #10
0
 public OrdersRowChangeEventArgs(OrdersRow row, DataRowAction action)
 {
     _eventRow = row;
     _eventAction = action;
 }
Пример #11
0
				public void AddOrdersRow(OrdersRow row) 
				{
					this.Rows.Add(row);
				}
Пример #12
0
 public OrdersRowChangeEvent(OrdersRow row, global::System.Data.DataRowAction action)
 {
     this.eventRow    = row;
     this.eventAction = action;
 }
 public Order_DetailsRow AddOrder_DetailsRow(OrdersRow parentOrdersRowByOrdersOrder_Details, ProductsRow parentProductsRowByProductsOrder_Details, decimal UnitPrice, short Quantity, float Discount) {
     Order_DetailsRow rowOrder_DetailsRow = ((Order_DetailsRow)(this.NewRow()));
     rowOrder_DetailsRow.ItemArray = new object[] {
             parentOrdersRowByOrdersOrder_Details[0],
             parentProductsRowByProductsOrder_Details[0],
             UnitPrice,
             Quantity,
             Discount};
     this.Rows.Add(rowOrder_DetailsRow);
     return rowOrder_DetailsRow;
 }
Пример #14
0
 internal void SetOrderInRealization(OrdersRow o)
 {
     Worker.EnqueueTask(new WorkerTask((args) =>
     {
         try
         {
             using (var proxy = new WorkChannel())
             {
                 OrderDTO order = o.Order.Clone();
                 order.State.StateValue = State.IN_REALISATION;
                 return proxy.SetOrderState(new UpdateRequest<OrderDTO>
                 {
                     Data = order,
                     Login = ClientConfig.CurrentUser.Email,
                     Password = ClientConfig.CurrentUser.Password
                 });
             }
         }
         catch (Exception e)
         {
             return e;
         }
     }, (a, s) =>
     {
         if (s.Result is Exception)
         {
             Utils.HandleException(s.Result as Exception);
             return;
         }
         var res = s.Result as SingleItemResponse<OrderDTO>;
         if (res == null)
         {
             Utils.showError(Utils.Messages.UNKNOWN_ERROR_FORMAT);
             return;
         }
         o.Order.State = res.Data.State;
         o.Update();
     }));
 }
Пример #15
0
 public OrderDetailsRow AddOrderDetailsRow(OrdersRow parentOrdersRowByFK_OrderDetails_Orders, int ItemID, string ItemCode, string ItemName, string MeasureCode, string MeasureName, double Quantity, double UnitPrice, double TaxPct, string Remarks) {
     OrderDetailsRow rowOrderDetailsRow = ((OrderDetailsRow)(this.NewRow()));
     object[] columnValuesArray = new object[] {
             null,
             null,
             ItemID,
             ItemCode,
             ItemName,
             MeasureCode,
             MeasureName,
             Quantity,
             UnitPrice,
             TaxPct,
             Remarks};
     if ((parentOrdersRowByFK_OrderDetails_Orders != null)) {
         columnValuesArray[1] = parentOrdersRowByFK_OrderDetails_Orders[0];
     }
     rowOrderDetailsRow.ItemArray = columnValuesArray;
     this.Rows.Add(rowOrderDetailsRow);
     return rowOrderDetailsRow;
 }
 public OrderDetailsRow AddOrderDetailsRow(OrdersRow parentOrdersRowByFK_OrderDetails_Orders, string SKU, decimal UnitPrice, short Quantity, float Discount) {
     OrderDetailsRow rowOrderDetailsRow = ((OrderDetailsRow)(this.NewRow()));
     object[] columnValuesArray = new object[] {
             null,
             SKU,
             UnitPrice,
             Quantity,
             Discount};
     if ((parentOrdersRowByFK_OrderDetails_Orders != null)) {
         columnValuesArray[0] = parentOrdersRowByFK_OrderDetails_Orders[0];
     }
     rowOrderDetailsRow.ItemArray = columnValuesArray;
     this.Rows.Add(rowOrderDetailsRow);
     return rowOrderDetailsRow;
 }
Пример #17
0
 public void RemoveOrdersRow(OrdersRow row)
 {
     this.Rows.Remove(row);
 }
Пример #18
0
				public OrdersRowChangeEvent(OrdersRow row, DataRowAction action) 
				{
					this.eventRow = row;
					this.eventAction = action;
				}
Пример #19
0
 public OrdersRowChangeEvent(OrdersRow row, DataRowAction action)
 {
     this.eventRow    = row;
     this.eventAction = action;
 }
Пример #20
0
 public Order_DetailsRow AddOrder_DetailsRow(OrdersRow parentOrdersRowByOrdersOrder_Details, int ProductID, decimal UnitPrice, short Quantity, float Discount, int CreateID, string CreateUser, int ModifyID, string ModifyUser) {
     Order_DetailsRow rowOrder_DetailsRow = ((Order_DetailsRow)(this.NewRow()));
     rowOrder_DetailsRow.ItemArray = new object[] {
             parentOrdersRowByOrdersOrder_Details[0],
             ProductID,
             UnitPrice,
             Quantity,
             Discount,
             CreateID,
             CreateUser,
             ModifyID,
             ModifyUser};
     this.Rows.Add(rowOrder_DetailsRow);
     return rowOrder_DetailsRow;
 }
Пример #21
0
				public void RemoveOrdersRow(OrdersRow row) 
				{
					this.Rows.Remove(row);
				}
 public Order_DetailsRow AddOrder_DetailsRow(OrdersRow parentOrdersRowByOrdersOrder_x0020_Details, int ProductID, decimal UnitPrice, short Quantity, float Discount) {
     Order_DetailsRow rowOrder_DetailsRow = ((Order_DetailsRow)(this.NewRow()));
     object[] columnValuesArray = new object[] {
             null,
             ProductID,
             UnitPrice,
             Quantity,
             Discount};
     if ((parentOrdersRowByOrdersOrder_x0020_Details != null)) {
         columnValuesArray[0] = parentOrdersRowByOrdersOrder_x0020_Details[0];
     }
     rowOrder_DetailsRow.ItemArray = columnValuesArray;
     this.Rows.Add(rowOrder_DetailsRow);
     return rowOrder_DetailsRow;
 }
Пример #23
0
				public Order_DetailsRow AddOrder_DetailsRow(OrdersRow parentOrdersRowByOrdersOrder_x0020_Details, int ProductID, Decimal UnitPrice, short Quantity, string Discount) 
				{
					Order_DetailsRow rowOrder_DetailsRow = ((Order_DetailsRow)(this.NewRow()));
					rowOrder_DetailsRow.ItemArray = new object[] {
																	 parentOrdersRowByOrdersOrder_x0020_Details[0],
																	 ProductID,
																	 UnitPrice,
																	 Quantity,
																	 Discount};
					this.Rows.Add(rowOrder_DetailsRow);
					return rowOrder_DetailsRow;
				}
Пример #24
0
 public OrdersRowChangedEventArgs(OrdersRow r, System.Data.DataRowAction a) {
     this.eventRow = r;
     this.eventAction = a;
 }