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; }