protected void CampaignDataSource_OnSelecting(object sender, LinqServerModeDataSourceSelectEventArgs e)
{
e.KeyExpression = "OrderDetailsID";
var db = ConnectionFactory.GetDBCMDataContext();
e.QueryableSource = db.List_FilteredOrderDetails(long.Parse(Request.QueryString["id"]),
bool.Parse(Request.QueryString["it"])).Select(
c => new
{
OrderDetailsID = c.OrderDetailsID,
OrderID = c.OrderID,
TypeID = c.TypeID,
TypeName = c.GoodsID == null ? "ბილეთი" : "პროდუქტი",
Price = c.Price,
TotalPrice = c.TotalPrice,
NetTotalPrice = c.NetTotalPrice,
PriceAlteration = c.PriceAlterationAmount,
Quantity = c.Quantity,
ItemDescription = c.ItemDescription,
Campaigns = c.Campaigns,
//TicketID = c.TicketID,
GoodsID = c.GoodsID,
IsGoods = c.GoodsID != null,
CRTime = c.CRTime,
IsCampaignUse = c.PriceAlterationAmount != 0
});
}
protected void OrdersDataSource_OnSelecting(object sender, LinqServerModeDataSourceSelectEventArgs e)
{
bool isTicket;
bool.TryParse((string)FilterCombo.Value, out isTicket);
e.KeyExpression = "OrderID";
var db = ConnectionFactory.GetDBCMDataContext();
e.QueryableSource = db.List_FilteredOrders(FromDate.Date.Date, ToDate.Date.Date.AddDays(1).AddMilliseconds(-1), isTicket).Select(c => new
{
ID = c.OrderID,
OrderID = c.OrderID,
OperatorFullName = c.OperatorFullName,
UserFullName = c.UserFullName,
OrderPrice = c.OrderPrice,
OrderNetPrice = c.OrderNetPrice,
OrderDate = c.OrderDate,
OrderCount = c.OrderCount,
OrderDiscount = c.OrderDiscount,
IsDeleteAllowed = c.IsDeleteAllowed ?? false,
OperatorStockID = c.OperatorStockID,
IsCanceled = c.IsCanceled,
StockName = c.StockName,
Campaigns = c.Campaigns
});
}
protected void OrderDetailsDataSource_OnSelecting(object sender, LinqServerModeDataSourceSelectEventArgs e)
{
e.KeyExpression = "OrderID";
var db = ConnectionFactory.GetDBReportingDataContext();
e.QueryableSource = db.rpt_List_SalesByGoods((int?)GoodsComboBox.Value, DateFromEdit.Date.Date, DateToEdit.Date.Date.AddDays(1).AddMilliseconds(-1));
}
protected void OrdersSummaryDataSource_OnSelecting(object sender, LinqServerModeDataSourceSelectEventArgs e)
{
e.KeyExpression = "OrderID";
var db = ConnectionFactory.GetDBReportingDataContext();
e.QueryableSource = db.rpt_List_OrdersInCampains((int?)TheatersComboBox.Value, (int?)HallComboBox.Value, (int?)OperatorComboBox.Value, (int?)MovieComboBox.Value, (int?)GoodsComboBox.Value, DateFromEdit.Date.Date, DateToEdit.Date.Date.AddDays(1).AddMilliseconds(-1));
}
protected void EntityServerModeDataSource1_Selecting(object sender,
LinqServerModeDataSourceSelectEventArgs e)
{
e.KeyExpression = "OrderID";
e.QueryableSource = new ASPxPivotGridCustomServerModeSort.NWindEntities().SalesPersons;
}
protected void lnsource_Selecting(object sender, LinqServerModeDataSourceSelectEventArgs e)
{
e.KeyExpression = compaundkey;
}
