public override object GetField(zHFT.Main.Common.Enums.Fields field)
{
OrderFields oField = (OrderFields)field;
if (oField == OrderFields.ClOrdID)
{
return(ClOrderId);
}
if (oField == OrderFields.OrigClOrdID)
{
return(OrigClOrderId);
}
else if (oField == OrderFields.OrderId)
{
return(OrderFields.NULL);
}
else if (oField == OrderFields.Symbol)
{
return(Symbol);
}
else
{
return(OrderFields.NULL);
}
}
protected override void OnSorting(GridViewSortEventArgs e)
{
if (string.IsNullOrEmpty(PanelCode))
{
base.OnSorting(e);
}
else
{
if (OrderFields.StartsWith(e.SortExpression))
{
if (OrderFields.EndsWith("ASC"))
{
OrderFields = e.SortExpression + " DESC";
}
else
{
OrderFields = e.SortExpression + " ASC";
}
}
else
{
OrderFields = e.SortExpression + " ASC";
}
BindGrid();
}
}
public static object GetField(this OrderFields field, object item)
{
Order order = (Order)item;
if (order != null)
{
switch (field)
{
case OrderFields.Date: return(order.Date);
case OrderFields.Product: return(order.Product);
case OrderFields.Quantity: return(order.Quantity);
case OrderFields.Net: return(order.Net);
case OrderFields.Promotion: return(order.Promotion);
case OrderFields.Advertisement: return(order.Advertisement);
case OrderFields.Order: return(order);
}
}
throw new Exception(String.Format("Field {0} not found on order {1}.", field, order));
}
protected override void VisitOrder(OrderExpression expression)
{
OrderFields.Add(new OrderField()
{
FieldName = ModelExtensions.GetCaseInsensitiveFieldName(expression.FieldName), Descending = expression.Descending
});
}
public byte[] Serialize()
{
var ms = new MemoryStream(1 + Name.Length + 1 + 1 + Data.Length + 1 + 4);
var bw = new BinaryWriter(ms);
OrderFields fields = 0;
if (Data != null)
{
fields |= OrderFields.TargetString;
}
if (ExtraData != 0)
{
fields |= OrderFields.ExtraData;
}
bw.Write((byte)0xfe);
bw.Write(Name);
bw.Write((byte)fields);
if (fields.HasField(OrderFields.TargetString))
{
bw.Write(Data);
}
if (fields.HasField(OrderFields.ExtraData))
{
bw.Write(ExtraData);
}
return(ms.ToArray());
}
protected override void VisitOrder(Query.Expressions.OrderExpression expression)
{
OrderFields.Add(new OrderField()
{
FieldName = expression.FieldName, Descending = expression.Descending
});
//ThrowNotSupported();
}
public override object GetField(zHFT.Main.Common.Enums.Fields field)
{
OrderFields oField = (OrderFields)field;
if (oField == OrderFields.Symbol)
{
return(Symbol);
}
return(OrderFields.NULL);
}
public OrderFields Post([FromBody] OrderFields order)
{
String text = System.IO.File.ReadAllText(@"C:\MandiDB\mandidbpath.txt");
// Display the file contents to the console. Variable text is a string.
string connectString = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=" + text;
var orderData = new OrderFields();
var itemLength = order.items.Length;
OleDbConnection cn = new OleDbConnection(connectString);
cn.Open();
string selectString = "insert into TrnHdrSLP(SLPNO,Prefix,PrintSLPNO,SLPDate,Cancelled,Ammendment,AmmDetails,AmmNo,AmmDate,Authorised,AuthDate,AuthorisedBy,InsertDocID,InsertDocNo,TOTQTY,TOTAMT,COMMPER,COMMAMT,GRANDTOT,FARMERID,Misc,RECORDADDEDBY)" +
" values('-','','-',Format (#" + order.SLPDate + "#, 'mm/dd/yyyy') ,'N','N','','0',Format (#" + order.SLPDate + "#, 'mm/dd/yyyy') ,'Y',Format (#" + order.SLPDate + "#, 'mm/dd/yyyy') ,1,0,''," + order.TOTQTY + "," + order.TOTAMT + ",0,0," + order.GRANDTOT + "," + order.FarmerId + ",'','" + order.RecordAddedBy + "') ";
string query2 = "Select @@Identity";
OleDbCommand cmd = new OleDbCommand(selectString, cn);
try
{
cmd.ExecuteNonQuery();
cmd.CommandText = query2;
orderData.SLPID = cmd.ExecuteScalar().ToString();
}
catch (Exception ex)
{
}
finally
{
cn.Close();
}
for (int i = 0; i < itemLength; i++)
{
cn.Open();
string selectString2 = "insert into TrnDtlSLP values(" + orderData.SLPID + ",'-'," + order.items[i].SlNo + "," + order.items[i].ItemSlNo + "," + order.items[i].QTY + "," + order.items[i].CustID + "," + order.items[i].ItemRate + "," + order.items[i].ItemAmt + "," + order.items[i].BQTY + ",0,0," + order.items[i].CustInAmt + "," + order.items[i].ItemID + "," + order.items[i].ItemRate + "," + order.items[i].FarmerID + ")";
OleDbCommand cmd2 = new OleDbCommand(selectString2, cn);
try
{
cmd2.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
cn.Close();
}
}
return(orderData);
}
public byte[] Serialize()
{
if (IsImmediate) /* chat, whatever */
{
var ret = new MemoryStream();
var w = new BinaryWriter(ret);
w.Write((byte)0xfe);
w.Write(OrderString);
w.Write(TargetString);
return ret.ToArray();
}
switch (OrderString)
{
// Format:
// u8 : orderID.
// 0xFF: Full serialized order.
// varies: rest of order.
default:
// TODO: specific serializers for specific orders.
{
var ret = new MemoryStream();
var w = new BinaryWriter(ret);
w.Write( (byte)0xFF );
w.Write(OrderString);
w.Write(UIntFromActor(Subject));
OrderFields fields = 0;
if (TargetActor != null) fields |= OrderFields.TargetActor;
if (TargetLocation != CPos.Zero) fields |= OrderFields.TargetLocation;
if (TargetString != null) fields |= OrderFields.TargetString;
if (Queued) fields |= OrderFields.Queued;
if (ExtraLocation != CPos.Zero) fields |= OrderFields.ExtraLocation;
if (ExtraData != 0) fields |= OrderFields.ExtraData;
w.Write((byte)fields);
if (TargetActor != null)
w.Write(UIntFromActor(TargetActor));
if (TargetLocation != CPos.Zero)
w.Write(TargetLocation);
if (TargetString != null)
w.Write(TargetString);
if (ExtraLocation != CPos.Zero)
w.Write(ExtraLocation);
if (ExtraData != 0)
w.Write(ExtraData);
return ret.ToArray();
}
}
}
public override object GetField(Fields field)
{
OrderFields xrField = (OrderFields)field;
if (xrField == OrderFields.ClOrdID)
{
return(ClOrdId);
}
else if (xrField == OrderFields.OrderId)
{
return(OrderId);
}
else
{
return(OrderFields.NULL);
}
}
public IHttpActionResult Put([FromBody] OrderFields order)
{
String text = System.IO.File.ReadAllText(@"C:\MandiDB\mandidbpath.txt");
// Display the file contents to the console. Variable text is a string.
string connectString = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=" + text;
Boolean valid = false;
var itemLength = order.items.Length;
OleDbConnection cn = new OleDbConnection(connectString);
cn.Open();
string selectString = "update TrnHdrSLP set TOTQTY=" + order.TOTQTY + ", TOTAMT= " + order.TOTAMT + ", GRANDTOT=" + order.GRANDTOT + " where SLPID=" + order.SLPID + " ";
string query2 = "delete from TrnDtlSLP where SLPID =" + order.SLPID + " ";
OleDbCommand cmd = new OleDbCommand(selectString, cn);
try
{
cmd.ExecuteNonQuery();
cmd.CommandText = query2;
cmd.ExecuteNonQuery();
valid = true;
}
catch (Exception ex)
{
valid = false;
}
finally
{
cn.Close();
}
for (int i = 0; i < itemLength; i++)
{
cn.Open();
string selectString2 = "insert into TrnDtlSLP values(" + order.SLPID + ",'-'," + order.items[i].SlNo + "," + order.items[i].ItemSlNo + "," + order.items[i].QTY + "," + order.items[i].CustID + "," + order.items[i].ItemRate + "," + order.items[i].ItemAmt + "," + order.items[i].BQTY + ",0,0," + order.items[i].CustInAmt + "," + order.items[i].ItemID + "," + order.items[i].ItemRate + "," + order.items[i].FarmerID + ")";
OleDbCommand cmd2 = new OleDbCommand(selectString2, cn);
try
{
cmd2.ExecuteNonQuery();
valid = true;
}
catch (Exception ex)
{
valid = false;
}
finally
{
cn.Close();
}
}
if (valid)
{
return(Ok("Saved Items sucessfully"));
}
else
{
return(Content(HttpStatusCode.NotFound, "Error Updating Item, Try Again"));
}
}
public override object GetField(Fields field)
{
if (field is OrderFields)
{
OrderFields oField = (OrderFields)field;
if (Order == null)
{
return(OrderFields.NULL);
}
if (oField == OrderFields.ClOrdID)
{
return(Order.ClOrdId);
}
if (oField == OrderFields.OrigClOrdID)
{
return(Order.OrigClOrdId);
}
else if (oField == OrderFields.SettlType)
{
return(Order.SettlType);
}
else if (oField == OrderFields.SettlDate)
{
return(Order.SettlDate);
}
else if (oField == OrderFields.Symbol)
{
return(Order.Security.Symbol);
}
else if (oField == OrderFields.SecurityType)
{
return(Order.Security.SecType);
}
else if (oField == OrderFields.Currency)
{
return(Order.Currency);
}
else if (oField == OrderFields.Exchange)
{
return(Order.Exchange);
}
else if (oField == OrderFields.OrdType)
{
return(Order.OrdType);
}
else if (oField == OrderFields.PriceType)
{
return(Order.PriceType);
}
else if (oField == OrderFields.Price)
{
return(Order.Price);
}
else if (oField == OrderFields.StopPx)
{
return(Order.StopPx);
}
else if (oField == OrderFields.ExpireDate)
{
return(Order.ExpireTime.HasValue ? (DateTime?)new DateTime(
Order.ExpireTime.Value.Year,
Order.ExpireTime.Value.Month,
Order.ExpireTime.Value.Day) : null);
}
else if (oField == OrderFields.ExpireTime)
{
return(Order.ExpireTime.HasValue ? (DateTime?)new DateTime(
Order.ExpireTime.Value.Year,
Order.ExpireTime.Value.Month,
Order.ExpireTime.Value.Day,
Order.ExpireTime.Value.Hour,
Order.ExpireTime.Value.Minute,
Order.ExpireTime.Value.Second) : null);
}
else if (oField == OrderFields.Side)
{
return(Order.Side);
}
else if (oField == OrderFields.OrderQty)
{
return(Order.OrderQty);
}
else if (oField == OrderFields.CashOrderQty)
{
return(Order.CashOrderQty);
}
else if (oField == OrderFields.OrderPercent)
{
return(Order.OrderPercent);
}
else if (oField == OrderFields.TimeInForce)
{
return(Order.TimeInForce);
}
else if (oField == OrderFields.MinQty)
{
return(Order.MinQty);
}
else if (oField == OrderFields.Account)
{
return(Order.Account);
}
else if (oField == OrderFields.DecimalPrecission)
{
return(Order.DecimalPrecission);
}
else
{
return(base.GetField(field));
}
}
else
{
return(base.GetField(field));
}
}
public byte[] Serialize()
{
var minLength = OrderString.Length + 1 + (IsImmediate ? 1 + TargetString.Length + 1 : 6);
var ret = new MemoryStream(minLength);
var w = new BinaryWriter(ret);
if (IsImmediate)
{
w.Write((byte)0xFE);
w.Write(OrderString);
w.Write(TargetString);
return(ret.ToArray());
}
w.Write((byte)0xFF);
w.Write(OrderString);
w.Write(UIntFromActor(Subject));
OrderFields fields = 0;
if (Target.SerializableType != TargetType.Invalid)
{
fields |= OrderFields.Target;
}
if (TargetString != null)
{
fields |= OrderFields.TargetString;
}
if (Queued)
{
fields |= OrderFields.Queued;
}
if (ExtraLocation != CPos.Zero)
{
fields |= OrderFields.ExtraLocation;
}
if (ExtraData != 0)
{
fields |= OrderFields.ExtraData;
}
if (Target.SerializableCell != null)
{
fields |= OrderFields.TargetIsCell;
}
w.Write((byte)fields);
if (fields.HasField(OrderFields.Target))
{
w.Write((byte)Target.SerializableType);
switch (Target.SerializableType)
{
case TargetType.Actor:
w.Write(UIntFromActor(Target.SerializableActor));
break;
case TargetType.FrozenActor:
w.Write(Target.FrozenActor.Viewer.PlayerActor.ActorID);
w.Write(Target.FrozenActor.ID);
break;
case TargetType.Terrain:
if (fields.HasField(OrderFields.TargetIsCell))
{
w.Write(Target.SerializableCell.Value);
w.Write((int)Target.SerializableSubCell);
}
else
{
w.Write(Target.SerializablePos);
}
break;
}
}
if (fields.HasField(OrderFields.TargetString))
{
w.Write(TargetString);
}
if (fields.HasField(OrderFields.ExtraLocation))
{
w.Write(ExtraLocation);
}
if (fields.HasField(OrderFields.ExtraData))
{
w.Write(ExtraData);
}
return(ret.ToArray());
}
public override object GetField(Main.Common.Enums.Fields field)
{
OrderFields oField = (OrderFields)field;
if (Order == null)
{
return(OrderFields.NULL);
}
if (oField == OrderFields.ClOrdID)
{
return(Order.ClOrdId);
}
else if (oField == OrderFields.SettlType)
{
return(Order.SettlType);
}
else if (oField == OrderFields.SettlDate)
{
return(Order.SettlDate);
}
else if (oField == OrderFields.Symbol)
{
return(Order.Security.Symbol);
}
else if (oField == OrderFields.SecurityType)
{
return(Order.Security.SecType);
}
else if (oField == OrderFields.Currency)
{
return(Order.Currency);
}
else if (oField == OrderFields.Exchange)
{
return(Order.Exchange);
}
else if (oField == OrderFields.OrdType)
{
return(Order.OrdType);
}
else if (oField == OrderFields.PriceType)
{
return(Order.PriceType);
}
else if (oField == OrderFields.Price)
{
return(Order.Price);
}
else if (oField == OrderFields.StopPx)
{
return(Order.StopPx);
}
else if (oField == OrderFields.ExpireDate)
{
return(Order.ExpireTime.HasValue ? (DateTime?)new DateTime(
Order.ExpireTime.Value.Year,
Order.ExpireTime.Value.Month,
Order.ExpireTime.Value.Day) : null);
}
else if (oField == OrderFields.ExpireTime)
{
return(Order.ExpireTime.HasValue ? (DateTime?)new DateTime(
Order.ExpireTime.Value.Year,
Order.ExpireTime.Value.Month,
Order.ExpireTime.Value.Day,
Order.ExpireTime.Value.Hour,
Order.ExpireTime.Value.Minute,
Order.ExpireTime.Value.Second) : null);
}
else if (oField == OrderFields.Side)
{
return(Order.Side);
}
else if (oField == OrderFields.OrderQty)
{
return(Order.OrderQty);
}
else if (oField == OrderFields.CashOrderQty)
{
return(Order.CashOrderQty);
}
else if (oField == OrderFields.OrderPercent)
{
return(Order.OrderPercent);
}
else if (oField == OrderFields.TimeInForce)
{
return(Order.TimeInForce);
}
else if (oField == OrderFields.MinQty)
{
return(Order.MinQty);
}
return(OrderFields.NULL);
}
public override object GetField(zHFT.Main.Common.Enums.Fields field)
{
OrderFields oField = (OrderFields)field;
if (LegacyOrderReq == null)
{
return(OrderFields.NULL);
}
if (oField == OrderFields.ClOrdID)
{
return(LegacyOrderReq.ClOrderId);
}
if (oField == OrderFields.OrigClOrdID)
{
return(LegacyOrderReq);
}
else if (oField == OrderFields.SettlType)
{
return(LegacyOrderReq);
}
else if (oField == OrderFields.SettlDate)
{
return(LegacyOrderReq);
}
else if (oField == OrderFields.Symbol)
{
return(OutgoingSymbol);
}
else if (oField == OrderFields.SecurityType)
{
return(SecurityType.CC);
}
else if (oField == OrderFields.Currency)
{
return(Currency.USD);
}
else if (oField == OrderFields.Exchange)
{
return("Test");
}
else if (oField == OrderFields.OrdType)
{
return(OrdType.Limit);
}
else if (oField == OrderFields.PriceType)
{
return(PriceType.FixedAmount);
}
else if (oField == OrderFields.Price)
{
return(LegacyOrderReq.Price.HasValue ? (decimal?)LegacyOrderReq.Price.Value : null);
}
else if (oField == OrderFields.StopPx)
{
return(OrderFields.NULL);
}
else if (oField == OrderFields.ExpireDate)
{
return(OrderFields.NULL);
}
else if (oField == OrderFields.ExpireTime)
{
return(OrderFields.NULL);
}
else if (oField == OrderFields.Side)
{
return(GetSide());
}
else if (oField == OrderFields.OrderQty)
{
return(LegacyOrderReq.Quantity);
}
else if (oField == OrderFields.CashOrderQty)
{
return(OrderFields.NULL);
}
else if (oField == OrderFields.OrderPercent)
{
return(OrderFields.NULL);
}
else if (oField == OrderFields.TimeInForce)
{
return(TimeInForce.Day);//Always Day for the moment
}
else if (oField == OrderFields.MinQty)
{
return(OrderFields.NULL);
}
else if (oField == OrderFields.Account)
{
return(LegacyOrderReq.AccountId);
}
else if (oField == OrderFields.DecimalPrecission)
{
return(OrderFields.NULL);
}
return(OrderFields.NULL);
}
public byte[] Serialize()
{
if (IsImmediate)
{
var ret = new MemoryStream();
var w = new BinaryWriter(ret);
w.Write((byte)0xfe);
w.Write(OrderString);
w.Write(TargetString);
return(ret.ToArray());
}
switch (OrderString)
{
/*
* Format:
* u8: orderID.
* 0xFF: Full serialized order.
* varies: rest of order.
*/
default:
// TODO: specific serializers for specific orders.
{
var ret = new MemoryStream();
var w = new BinaryWriter(ret);
w.Write((byte)0xFF);
w.Write(OrderString);
w.Write(UIntFromActor(Subject));
OrderFields fields = 0;
if (TargetActor != null)
{
fields |= OrderFields.TargetActor;
}
if (TargetLocation != CPos.Zero)
{
fields |= OrderFields.TargetLocation;
}
if (TargetString != null)
{
fields |= OrderFields.TargetString;
}
if (Queued)
{
fields |= OrderFields.Queued;
}
if (ExtraLocation != CPos.Zero)
{
fields |= OrderFields.ExtraLocation;
}
if (ExtraData != 0)
{
fields |= OrderFields.ExtraData;
}
w.Write((byte)fields);
if (TargetActor != null)
{
w.Write(UIntFromActor(TargetActor));
}
if (TargetLocation != CPos.Zero)
{
w.Write(TargetLocation);
}
if (TargetString != null)
{
w.Write(TargetString);
}
if (ExtraLocation != CPos.Zero)
{
w.Write(ExtraLocation);
}
if (ExtraData != 0)
{
w.Write(ExtraData);
}
return(ret.ToArray());
}
}
}
public static bool HasField(this OrderFields of, OrderFields f)
{
return((of & f) != 0);
}
public static bool HasField(this OrderFields of, OrderFields f)
{
return (of & f) != 0;
}
