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);
}
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);
}
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);
}
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);
}
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;
}
public OrdersRowChangeEventArgs(OrdersRow row, DataRowAction action)
{
_eventRow = row;
_eventAction = action;
}
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 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;
}
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();
}));
}
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;
}
public void RemoveOrdersRow(OrdersRow row)
{
this.Rows.Remove(row);
}
public OrdersRowChangeEvent(OrdersRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public OrdersRowChangeEvent(OrdersRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
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;
}
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;
}
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;
}
public OrdersRowChangedEventArgs(OrdersRow r, System.Data.DataRowAction a) {
this.eventRow = r;
this.eventAction = a;
}