private void BindData()
{
//_orders = _orderRepo.GetAll();
_orders = _orderRepo.GetAllByCustomerId(_customerId);
OrderGrid.DataSource = _orders;
OrderGrid.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
_DigitalGoodId = AlwaysConvert.ToInt(Request.QueryString["DigitalGoodId"]);
_DigitalGood = DigitalGoodDataSource.Load(_DigitalGoodId);
if (_DigitalGood == null)
{
Response.Redirect("Default.aspx");
}
Caption.Text = string.Format(Caption.Text, _DigitalGood.Name);
//GET ALL ORDER ITEMS ASSOCIATED WITH DIGITAL GOOD
IList <OrderItemDigitalGood> oidgs = OrderItemDigitalGoodDataSource.LoadForDigitalGood(_DigitalGoodId);
//BUILD DISTINCT LIST OF ORDERS
List <Order> orders = new List <Order>();
foreach (OrderItemDigitalGood oidg in oidgs)
{
Order order = oidg.OrderItem.Order;
if (orders.IndexOf(order) < 0)
{
orders.Add(order);
}
}
//BIND TO GRID
OrderGrid.DataSource = orders;
OrderGrid.DataBind();
}
protected void OrderGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label Oid = OrderGrid.Rows[e.RowIndex].FindControl("lblOrderId") as Label;
DropDownList OStatus = OrderGrid.Rows[e.RowIndex].FindControl("StatusDrop") as DropDownList;
SqlCommand cmd = new SqlCommand("Update Orders set OrderStatus=@status where OrderId=@oid", con);
//String updatedata = "Update Orders set OrderStatus=@status where OrderId=@oid";
//SqlCommand cmd = new SqlCommand();
//cmd.CommandText = updatedata;
//cmd.Connection = con;
cmd.Parameters.AddWithValue("@oid", Oid.Text);
cmd.Parameters.AddWithValue("@status", OStatus.SelectedValue);
con.Open();
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
OrderGrid.EditIndex = -1;
OrderGrid.DataSource = dt;
OrderGrid.DataBind();
con.Close();
FillGridView();
}
private void PopulateOrderGrid()
{
using (
var connection =
new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
var spname = "";
switch (_type)
{
case OrderDrillDownType.Firm:
spname = "GetFirmOrdersForGivenWeekForPieces";
break;
case OrderDrillDownType.Reservations:
spname = "GetReservationsForGivenWeekForPieces";
break;
case OrderDrillDownType.Hold:
spname = "GetHoldItemsForGivenWeekForPieces";
break;
}
var data= connection.Query<OrderDrillDownMedel>(string.Format("EXEC [dbo].[SPC_{0}] '{1}'",
spname, _weekEndDate.ToString("yyyyMMdd"))).ToList();
if (data.Count < 1)
{
dvEmptyContent.Visible = true;
return;
}
OrderGrid.DataSource = data;
OrderGrid.DataBind();
dvDataContent.Visible = true;
}
}
protected void OrderGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Capture") || e.CommandName.Equals("Ship"))
{
int orderId = (int)OrderGrid.DataKeys[AlwaysConvert.ToInt(e.CommandArgument)].Value;
Order order = OrderDataSource.Load(orderId);
if (order != null)
{
if (e.CommandName.Equals("Capture"))
{
if ((order.Payments.Count == 1) && (order.Payments[0].PaymentStatus == PaymentStatus.Authorized))
{
Response.Redirect("Payments/CapturePayment.aspx?PaymentId=" + order.Payments[0].Id.ToString());
}
}
else
{
foreach (OrderShipment shipment in order.Shipments)
{
if (shipment.ShipDate == System.DateTime.MinValue)
{
Response.Redirect("Shipments/ShipOrder.aspx?OrderShipmentId=" + shipment.Id.ToString());
}
}
}
}
OrderGrid.DataBind();
}
}
protected void SyncButton_Click(object sender, EventArgs e)
{
_shipStationExportManager.SyncStatuses();
Timer1.Enabled = true;
SyncButton.Visible = false;
ProgressPanel.Visible = true;
OrderGrid.DataBind();
}
void GetAll()
{
string sqlstr;
sqlstr = "SELECT OrderID, CustomerID, ProductID, Qty , Amount FROM myOrder";
OrderGrid.DataSource = mydb.BuildDataTable(sqlstr);
OrderGrid.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
IList <Order> orders = AbleContext.Current.User.Orders;
orders.Sort("OrderDate", CommerceBuilder.Common.SortDirection.DESC);
OrderGrid.DataSource = orders;
OrderGrid.DataBind();
}
protected void btnEditOrders_Click(object sender, EventArgs e)
{
var customerId = ((GridViewDataItemTemplateContainer)(sender as ASPxButton).Parent).KeyValue;
CustomerIdHiddenField.Value = customerId.ToString();
OrderPopup.ShowOnPageLoad = true;
OrderGrid.DataBind();
}
private void btnReportsFormShow_Click(object sender, EventArgs e)
{
this.Hide();
OrderGrid orderGrid = new OrderGrid(user);
orderGrid.ShowDialog();
}
private bool TryOpenMoreDeals(double bottomAsk, double topBid, double spreadToOpen)
{
int zoneIndex = OrderGrid.GetZoneIndex(spreadToOpen);
if (zoneIndex == -1)
{
return(false);
}
double baseAmount = GetRemainAmountForZoneInBaseCurrency(zoneIndex);
if (baseAmount == 0)
{
return(false);
}
double buyAmount = CalculateLongBuyAmountByBaseAmount(baseAmount);
double actualBuyAmount = GetActualBottomAskAmount(bottomAsk);
double finalBuyAmount = Math.Min(buyAmount, actualBuyAmount);
double requiredShortSellAmount = CalculateRequiredShortAmount(finalBuyAmount, spreadToOpen);
double availableShortSellAmount = GetActualShortBidAmount(topBid);
double finalSellAmount = Math.Min(requiredShortSellAmount, availableShortSellAmount);
if (finalSellAmount < requiredShortSellAmount)
{
finalSellAmount = availableShortSellAmount;
finalBuyAmount = CalculateRequiredLongAmount(finalSellAmount, spreadToOpen);
}
MarketBuy(Long, bottomAsk, finalBuyAmount);
MarketSell(Short, topBid, finalSellAmount);
var order = new StatisticalArbitrageOrderInfo()
{
LongAmount = finalBuyAmount,
LongValue = bottomAsk,
ShortAmount = finalSellAmount,
ShortTotalAmount = finalSellAmount,
ShortValue = topBid,
ZoneIndex = zoneIndex,
SpentDeposit = Long.HighestBidInBaseCurrency() * finalBuyAmount,
Spread = spreadToOpen
};
LastItem = new StatisticalArbitrageHistoryItem();
LastItem.Time = DateTime.UtcNow;
LastItem.Earned = Earned;
LastItem.LongPrice = bottomAsk;
LastItem.ShortPrice = topBid;
LastItem.LongAmount = finalBuyAmount;
LastItem.ShortAmount = finalSellAmount;
LastItem.Open = true;
StrategyData.Add(LastItem);
//OpenedOrders.Add(order);
OnOrderOpened(LastItem);
return(true);
}
private void ReBindGrid()
{
if (Session["DrilldownView"] == null)
{
return;
}
OrderGrid.DataSource = (List <DrillDownModel>)Session["DrilldownView"];
OrderGrid.DataBind();
}
public override void Assign(StrategyBase from)
{
base.Assign(from);
StatisticalArbitrageStrategy s = from as StatisticalArbitrageStrategy;
if (s == null)
{
return;
}
this.CloseSpread = s.CloseSpread;
OrderGrid.Assign(s.OrderGrid);
}
public ViewOrders()
{
InitializeComponent();
OrderManager om = new OrderManager(new UnitOfWork());
Orders = new OrderGrid(OrdersGrid, om.GetAll());
Orders.SetDeleteButton(Button_DeleteOrders);
Orders.SetEditButton(Button_EditOrder);
new OrderAddForm(Input_OrderFirstname, Input_OrderLasttname, Input_OrderEmail, Input_OrderPhone, Input_OrderItem, Input_OrderItemQuantity, Input_OrderItems, Button_AddOrderItem, Button_CreateOrder);
}
protected void Page_Load(object sender, EventArgs e)
{
IList <int> selectedOrders = AbleContext.Current.Session.SelectedOrderIds;
if ((selectedOrders == null) || (selectedOrders.Count == 0))
{
Response.Redirect("~/Admin/Orders/Default.aspx");
}
LoadOrders(selectedOrders.ToArray());
OrderGrid.DataSource = _Orders;
OrderGrid.DataBind();
OrderList.Text = _OrderNumbers;
}
private void UpdateOrderGrid()
{
OrderGrid.ClearChildren();
Model.Order.Value.OrderItems.Do(oi => OrderGrid.Add(new OrderCardItem
{
OrderItem = oi,
ShowProductDetail = p => Model.ShowProductDetail(p).RunInParallel()
}.Set(x => x.ModelHolder = Model)));
if (Model.Order.Value.OrderItems.Count % 2 == 1)
{
OrderGrid.Add(new Canvas().Set(c => c.Margin(8)));
}
}
public override void Assign(StrategyBase from)
{
base.Assign(from);
StatisticalArbitrageStrategy s = from as StatisticalArbitrageStrategy;
if (s == null)
{
return;
}
SpreadClosePosition = s.SpreadClosePosition;
SpreadOpenPosition = s.SpreadOpenPosition;
OrderGrid.Assign(s.OrderGrid);
}
private double GetRemainAmountForZoneInBaseCurrency(int zoneIndex)
{
double percent = OrderGrid.GetAmountInPc(zoneIndex);
double maxAmount = MaxAllowedDeposit * percent / 100;
//foreach(var order in OpenedOrders) {
// if(order.ZoneIndex != zoneIndex)
// continue;
// maxAmount -= order.SpentDeposit;
// if(maxAmount <= 0)
// return 0;
//}
return(maxAmount);
}
protected void Page_Init(object sender, System.EventArgs e)
{
_DigitalGoodId = AlwaysConvert.ToInt(Request.QueryString["DigitalGoodId"]);
_DigitalGood = DigitalGoodDataSource.Load(_DigitalGoodId);
if (_DigitalGood == null)
{
Response.Redirect("Default.aspx");
}
Caption.Text = string.Format(Caption.Text, _DigitalGood.Name);
InstructionText.Text = string.Format(InstructionText.Text, _DigitalGood.Name);
ProductsGrid.DataSource = _DigitalGood.ProductDigitalGoods;
ProductsGrid.DataBind();
//GET ALL ORDER ITEMS ASSOCIATED WITH DIGITAL GOOD
IList <OrderItemDigitalGood> oidgs = OrderItemDigitalGoodDataSource.LoadForDigitalGood(_DigitalGoodId);
//BUILD DISTINCT LIST OF ORDERS
List <CommerceBuilder.Orders.Order> orders = new List <CommerceBuilder.Orders.Order>();
foreach (OrderItemDigitalGood oidg in oidgs)
{
CommerceBuilder.Orders.Order order = oidg.OrderItem.Order;
if (orders.IndexOf(order) < 0)
{
orders.Add(order);
}
}
//BIND TO GRID
OrderGrid.DataSource = orders;
OrderGrid.DataBind();
if (!String.IsNullOrEmpty(_DigitalGood.FileName))
{
ICriteria criteria = NHibernateHelper.CreateCriteria <DigitalGood>();
criteria.Add(Restrictions.Eq("FileName", StringHelper.SafeSqlString(_DigitalGood.FileName)));
IList <DigitalGood> dgc = DigitalGoodDataSource.LoadForCriteria(criteria);
if (dgc != null && dgc.Count > 1)
{
DeleteAllowedPanel.Visible = false;
DeletePreventedPanel.Visible = true;
NoDeleteFileText.Text = string.Format(NoDeleteFileText.Text, _DigitalGood.FileName);
}
else
{
DeleteAllowedPanel.Visible = true;
DeletePreventedPanel.Visible = false;
DeleteFile.Text = string.Format(DeleteFile.Text, _DigitalGood.FileName);
}
}
}
protected void GetOrdersButton_Click(object sender, EventArgs e)
{
string debugHtml;
Orders = CoreLogic.GetOrders("ewexler", "40mil", out debugHtml);
int count = PenatnaDB.Instance.InsertOrders(Orders);
Response.Write("Inserted " + count + " orders into the database.");
if (!String.IsNullOrWhiteSpace(debugHtml))
{
debugHtml = Server.HtmlEncode(debugHtml);
debugHtml = debugHtml.Replace("\r\n", "<br />");
Response.Write(debugHtml);
}
OrderGrid.DataSource = Orders;
OrderGrid.DataBind();
}
public void FillGridView()
{
SqlCommand cmd = new SqlCommand("SELECT OrderId, CustomerName, MobileNo, Address, Vendor, OrderStatus, PickupPerson, PickupDate, DeliveryPerson, DeliveryDate FROM Orders WHERE OrderStatus= @OrderStatus", con);
con.Open();
cmd.Parameters.AddWithValue("@OrderStatus", drpordstatus.SelectedValue);
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
OrderGrid.DataSource = dt;
OrderGrid.DataBind();
con.Close();
}
protected void ShipStationWizard_NextButtonClick(object sender, WizardNavigationEventArgs e)
{
switch (e.NextStepIndex)
{
case 1:
OrderGrid.DataBind();
if (OrderGrid.Rows.Count == 0)
{
ShipStationWizard.FinishCompleteButtonStyle.CssClass = "hideExportButton";
ExportOptionsPanel.Visible = false;
OrdersTitleLabel.Visible = false;
}
else
{
ShipStationWizard.FinishCompleteButtonStyle.CssClass = "button";
ExportOptionsPanel.Visible = true;
OrdersTitleLabel.Visible = true;
}
break;
}
}
private void fillORDList()
{
string connectionString = ConfigurationManager.ConnectionStrings["CN"].ConnectionString;
string sql = "SELECT ORDMAN.UNIT,DCOD,ORDMAN.DBCD,PCOD,ORDMAN.BRCD,ORDMAN.TXCD,ORDT,ORDN,PORD,TRCD,QNTY,DISPATCHQTY,CANCELQTY,(QNTY-DISPATCHQTY-CANCELQTY) AS BALQTY,ICOD,ORDMAN.RATE AS RATE,ARAT,ACCMST.NAME AS PARTY,REFMST.NAME AS AGENT,FINITMMST.NAME AS ITEM,GRDMST.GRAD AS GRADE FROM ORDMAN LEFT JOIN ACCMST ON ORDMAN.PCOD = ACCMST.CODE LEFT JOIN REFMST ON ORDMAN.BRCD = REFMST.CODE LEFT JOIN FINITMMST ON ORDMAN.COMP = FINITMMST.COMP AND ORDMAN.UNIT = FINITMMST.UNIT AND ORDMAN.DCOD = FINITMMST.DVCD AND ORDMAN.ICOD = FINITMMST.CODE LEFT JOIN GRDMST ON ORDMAN.TRCD = GRDMST.CODE WHERE ORDMAN.COMP = '0001' AND ORDMAN.UNIT ='000001' AND (QNTY-DISPATCHQTY-CANCELQTY) >.001";
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(sql))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = sqlConnection;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
OrderGrid.DataSource = dt;
OrderGrid.DataBind();
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
IList <Order> orders = AbleContext.Current.User.Orders;
orders.Sort("OrderDate", CommerceBuilder.Common.SortDirection.DESC);
OrderGrid.DataSource = orders;
OrderGrid.DataBind();
if (AbleContext.Current.Store.EmailLists.Count > 0)
{
EmailPreferences.Visible = true;
}
UpdateEmailLink.NavigateUrl = NavigationHelper.GetMobileStoreUrl("~/Members/MyCredentials.aspx");
EmailPreferencesLink.NavigateUrl = NavigationHelper.GetMobileStoreUrl("~/Members/EmailPreferences.aspx");
ChangePassLink.NavigateUrl = NavigationHelper.GetMobileStoreUrl("~/Members/ChangePassword.aspx");
AddressBookLink.NavigateUrl = NavigationHelper.GetMobileStoreUrl("~/Members/MyAddressBook.aspx");
PaymentTypesLink.NavigateUrl = NavigationHelper.GetMobileStoreUrl("~/Members/PaymentTypes.aspx");
MyReviewsLink.NavigateUrl = NavigationHelper.GetMobileStoreUrl("~/Members/MyProductReviews.aspx");
WishlistLink.NavigateUrl = NavigationHelper.GetMobileStoreUrl("~/Members/MyWishlist.aspx");
PhPaymentTypes.Visible = AbleContext.Current.Store.Settings.EnablePaymentProfilesStorage && !AbleContext.Current.User.IsAnonymousOrGuest;
PhMyReviews.Visible = AbleContext.Current.Store.Settings.ProductReviewEnabled != CommerceBuilder.Users.UserAuthFilter.None;
}
protected void OrderGrid_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
OrderGrid.PageIndex = e.NewPageIndex;
OrderGrid.DataBind();
}
protected void btnNewOrder_Click(object sender, EventArgs e)
{
OrderGrid.AddNewRow();
}
private void OnStrategyOrderRegisterFailed(OrderFail fail)
{
OrderGrid.AddRegistrationFail(fail);
}
public override void Save(SettingsStorage settings)
{
settings.SetValue("OrderGrid", OrderGrid.Save());
}
/// <summary>
/// Создать <see cref="OrdersPanel"/>.
/// </summary>
public OrdersPanel()
{
InitializeComponent();
Security prevSecurity = null;
Portfolio prevPortfolio = null;
var prevType = OrderTypes.Limit;
Func <OrderTypes, Order> createOrder = type => new Order
{
Type = type,
Security = prevSecurity,
Portfolio = prevPortfolio,
};
OrderGrid.OrderRegistering += () =>
{
var wnd = new OrderWindow
{
SecurityProvider = ConfigManager.GetService <ISecurityProvider>(),
MarketDataProvider = ConfigManager.GetService <IMarketDataProvider>(),
Order = createOrder(prevType),
Portfolios = ConfigManager.GetService <PortfolioDataSource>()
};
if (!wnd.ShowModal(this))
{
return;
}
var order = wnd.Order;
prevType = order.Type;
prevSecurity = order.Security;
prevPortfolio = order.Portfolio;
new RegisterOrderCommand(order).Process(this);
};
OrderGrid.OrderReRegistering += order =>
{
var window = new OrderWindow
{
Title = LocalizedStrings.Str2976Params.Put(order.TransactionId),
Order = order.ReRegisterClone(newVolume: order.Balance),
};
if (window.ShowModal(this))
{
new ReRegisterOrderCommand(order, window.Order).Process(this);
}
};
OrderGrid.OrderCanceling += orders => new CancelOrderCommand(orders).Process(this);
OrderGrid.SelectionChanged += (s, e) => new SelectCommand <Order>(OrderGrid.SelectedOrder, false).Process(this);
OrderGrid.PropertyChanged += (s, e) => new ControlChangedCommand(this).Process(this);
GotFocus += (s, e) => new SelectCommand <Order>(OrderGrid.SelectedOrder, false).Process(this);
var cmdSvc = ConfigManager.GetService <IStudioCommandService>();
cmdSvc.Register <ResetedCommand>(this, false, cmd => OrderGrid.Orders.Clear());
cmdSvc.Register <OrderCommand>(this, false, cmd =>
{
if (cmd.Action == OrderActions.Registering && cmd.Order.Type != OrderTypes.Conditional)
{
OrderGrid.Orders.Add(cmd.Order);
}
});
cmdSvc.Register <ReRegisterOrderCommand>(this, false, cmd => OrderGrid.Orders.Add(cmd.NewOrder));
cmdSvc.Register <OrderFailCommand>(this, false, cmd =>
{
if (cmd.Action == OrderActions.Registering)
{
OrderGrid.AddRegistrationFail(cmd.Fail);
}
});
cmdSvc.Register <BindStrategyCommand>(this, false, cmd =>
{
prevSecurity = cmd.Source.Security;
prevPortfolio = cmd.Source.Portfolio;
});
WhenLoaded(() => new RequestBindSource(this).SyncProcess(this));
}
public override void Load(SettingsStorage settings)
{
OrderGrid.Load(settings.GetValue <SettingsStorage>("OrderGrid"));
}
