public int Create(EntityOrder entityOrder)
{
using (var context = new InternalOrderContext(_dbContextOptions))
{
context.Orders.Add(entityOrder);
context.SaveChanges();
}
return(entityOrder.OrderId);
}
public async Task <IActionResult> Get([FromQuery] ProductFilter filter, [FromQuery] EntityOrder order, [FromQuery] PagingParams pagination)
{
var list = await repository.Browse()
.AplyFilter(filter)
.AplyOrder(order)
.ToEntityPaginated(pagination);
return(Ok(list));
}
public async Task <EntityOrder> Create(EntityOrder entityOrder, CancellationToken cancellationToken)
{
//ToDo: Cross Cutting Concern
_httpClient.DefaultRequestHeaders.Accept.Clear();
_httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = await _httpClient.PutAsJsonAsync("api/v1/orders", entityOrder, cancellationToken);
return(await response.Content.ReadAsAsync <EntityOrder>());
}
public static void Helper_RotatePointsAccordingToAngleFromCoreUnit(ArcenPoint MoveOrderPoint, bool isQueuedCommand, ArcenSparseLookup <GameEntity, ArcenPoint> entitiesToPlace, GameEntity coreUnit)
{
// rotate points according to angle from first unit to target
Vector2 originPoint = coreUnit.WorldLocation.ToVector2();
if (isQueuedCommand)
{
for (int i = 0; i < coreUnit.EntitySpecificOrders.QueuedOrders.Count; i++)
{
EntityOrder order = coreUnit.EntitySpecificOrders.QueuedOrders[i];
if (order.TypeData.Type != EntityOrderType.Move)
{
continue;
}
originPoint = order.RelatedPoint.ToVector2();
}
}
Vector2 moveOrderVectorPoint = MoveOrderPoint.ToVector2();
NonSimAngleDegrees angle = originPoint.GetAngleToDegrees(moveOrderVectorPoint);
NonSimAngleDegrees baseAngle = NonSimAngleDegrees.Create(0);
NonSimAngleDegrees rotationAngle = angle.Add(baseAngle);
for (int i = 0; i < entitiesToPlace.GetPairCount(); i++)
{
ArcenSparseLookupPair <GameEntity, ArcenPoint> pair = entitiesToPlace.GetPairByIndex(i);
Vector2 destinationPoint = pair.Value.ToVector2();
NonSimAngleDegrees subAngle = moveOrderVectorPoint.GetAngleToDegrees(destinationPoint);
Vector2 movementVector = destinationPoint - moveOrderVectorPoint;
float distance = movementVector.magnitude;//involves sqrt, is awful, but in interface code of this kind it's probably fine
NonSimAngleDegrees finalAngle = rotationAngle.Add(subAngle);
Vector2 rotatedPoint = moveOrderVectorPoint;
rotatedPoint.x += (float)(distance * finalAngle.Cos());
rotatedPoint.y += (float)(distance * finalAngle.Sin());
entitiesToPlace[pair.Key] = rotatedPoint.ToArcenPoint();
}
}
public async Task <IActionResult> Suggestions(int id, [FromQuery] ProductFilter filter, [FromQuery] EntityOrder order, [FromQuery] PagingParams pagination)
{
var list = await(await productRepository.SuggestionsTo(id))
.AplyFilter(filter)
.AplyOrder(order)
.ToEntityPaginated(pagination);
return(Ok(list));
}
internal static bool ShippingCommit(EntityOrder shipOrder)
{
bool bInsert = false;
int iInsert = -1;
string connectionString = Common.CommonDa.GetDbConnection();
SQLiteTransaction transaction = null;
using (SQLiteConnection conn = new SQLiteConnection(connectionString))
{
conn.Open();
transaction = conn.BeginTransaction();
try
{
iInsert = 0;
//string strSql2 = "update main.im_item set void=1 where void=0 and product_no=@product_no ";
//SQLiteCommand cmd = new SQLiteCommand(strSql2, conn, transaction);
//cmd.Parameters.AddWithValue("@product_no", paraItem.ProductNo);
//iInsert = cmd.ExecuteNonQuery();
//strSql2 = "update main.im_item_barcode set void=1 where void=0 and product_no=@product_no ";
//cmd = new SQLiteCommand(strSql2, conn, transaction);
//cmd.Parameters.AddWithValue("@product_no", paraItem.ProductNo);
//iInsert += cmd.ExecuteNonQuery();
string strSql = @"insert into wh_order_head (order_id,order_no,order_type_id,customer_id,void,update_uid,update_time)
values (@order_id,@order_no,@order_type_id,@customer_id,0,@update_uid,datetime('now','localtime'))";
SQLiteCommand cmd = new SQLiteCommand(strSql, conn, transaction);
cmd.Parameters.AddWithValue("@order_id", shipOrder.OrderId);
cmd.Parameters.AddWithValue("@order_no", shipOrder.OrderNo);
cmd.Parameters.AddWithValue("@order_type_id", shipOrder.OrderTypeId);
cmd.Parameters.AddWithValue("@customer_id", shipOrder.CustomerId);
cmd.Parameters.AddWithValue("@update_uid", shipOrder.UserId);
iInsert += cmd.ExecuteNonQuery();
foreach (EntityIoLogs iolog in shipOrder.IoLogsList)
{
string strSql1 = @"insert into wh_io_logs (io_type_id,order_id,customer_id,product_no,qty,uom_id,lot_no,serial_no,cntr_id,void,update_uid,update_time) values
(@io_type_id,@order_id,@customer_id,@product_no,@qty,@uom_id,@lot_no,@serial_no,@cntr_id,0,@update_uid,datetime('now','localtime'))";
cmd = new SQLiteCommand(strSql1, conn, transaction);
cmd.Parameters.AddWithValue("@io_type_id", iolog.IoTypeId);
cmd.Parameters.AddWithValue("@order_id", iolog.OrderId);
cmd.Parameters.AddWithValue("@customer_id", shipOrder.CustomerId);
cmd.Parameters.AddWithValue("@product_no", iolog.Item.ProductNo); //product_no
cmd.Parameters.AddWithValue("@qty", iolog.Qty); //qty
cmd.Parameters.AddWithValue("@uom_id", iolog.UomId); //uom_id
cmd.Parameters.AddWithValue("@lot_no", iolog.LotNo); //lot_no
cmd.Parameters.AddWithValue("@serial_no", iolog.SerialNo); //serial_no
cmd.Parameters.AddWithValue("@cntr_id", iolog.ContainerId); //cntr_id
cmd.Parameters.AddWithValue("@update_uid", shipOrder.UserId);
iInsert += cmd.ExecuteNonQuery();
}
if (iInsert > 0)
{
bInsert = true;
}
transaction.Commit();
}
catch (System.Data.SQLite.SQLiteException ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
finally
{
//cmd.Dispose();
conn.Close();
}
}
return(bInsert);
}
public static EntityOrder Update(entities.Entity.Interface.ODS model, EntityOrder ord)
{
return(new BusinessOrder().Update(model, ord));
}
