public string[] GetItems(string query, int ClientId)
{
/*string query = "";
query = Context.Request.Form["query"].ToString();*/
Clients client = new Clients();
client.LoadByPrimaryKey(ClientId);
int clientTypeID = 0 ;
if(client.RowCount > 0)
clientTypeID= client.ClientTypeID;
Items items = new Items();
List<string> listString = new List<string>();
if (clientTypeID != 0)
{
items.SearchItemsAjax(query, clientTypeID);
if (items.RowCount > 0)
{
for (int i = 0; i < items.RowCount; i++)
{
listString.Add(items.ItemID + "##" + items.Name + "##" + items.GetColumn("Price").ToString());
//ItemsJSON += "{'Name': '" + items.ItemCode + " - " + items.Name + "' , 'ItemID': '" + items.ItemID + "'}";
items.MoveNext();
}
}
}
else
{
items.SearchItems(query);
if (items.RowCount > 0)
{
for (int i = 0; i < items.RowCount; i++)
{
listString.Add(items.ItemID + "##" + items.Name);
//ItemsJSON += "{'Name': '" + items.ItemCode + " - " + items.Name + "' , 'ItemID': '" + items.ItemID + "'}";
items.MoveNext();
}
}
}
string[] str = listString.ToArray();
//Context.Response.Output.Write(ItemsJSON);
//Context.Response.End();
return str;
}
private void LoadReport()
{
uiReportViewerMain.LocalReport.ReportPath = BaseReportPath + CurrentReport + ".rdlc";
switch (CurrentReport)
{
case "Report_GetItemsBalances":
if (Session["Report_ItemIDForBalance"] != null)
{
IStock.BLL.Items items = new IStock.BLL.Items();
items.Report_GetItemsBalances(Convert.ToInt32(Session["Report_ItemIDForBalance"].ToString()));
uiReportViewerMain.LocalReport.DataSources.Clear();
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource(CurrentReport + "DataSet", items.DefaultView));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("ItemID", Session["Report_ItemIDForBalance"].ToString()));
uiReportViewerMain.LocalReport.Refresh();
}
break;
case "Report_GetClientCredit":
if (Session["Report_ClientIDForCredit"] != null)
{
IStock.BLL.Clients clients = new IStock.BLL.Clients();
clients.Report_GetClientCredit(Convert.ToInt32(Session["Report_ClientIDForCredit"].ToString()));
uiReportViewerMain.LocalReport.DataSources.Clear();
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource(CurrentReport + "DataSet", clients.DefaultView));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("ClientID", Session["Report_ClientIDForCredit"].ToString()));
uiReportViewerMain.LocalReport.Refresh();
}
break;
case "Report_DeliveryOrder":
if (Session["Report_DeliveryOrderID"] != null)
{
IStock.BLL.DeliveryOrder order = new IStock.BLL.DeliveryOrder();
order.Report_DeliveryOrder(Convert.ToInt32(Session["Report_DeliveryOrderID"].ToString()));
IStock.BLL.DeliveryOrder orderT = new IStock.BLL.DeliveryOrder();
orderT.Report_DeliveryOrder(Convert.ToInt32(Session["Report_DeliveryOrderID"].ToString()));
orderT.GetDeliveryOrderTotalsForReport(orderT.DeliveryOrderID);
IStock.BLL.DeliveryOrderDetails details = new DeliveryOrderDetails();
details.GetDeliveryOrderDetails(order.DeliveryOrderID);
IStock.BLL.ClientReturns cr = new IStock.BLL.ClientReturns();
cr.GetClientReturnByDeliveryOrderID(order.DeliveryOrderID);
uiReportViewerMain.LocalReport.DataSources.Clear();
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource(CurrentReport + "DataSet", order.DefaultView));
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource(CurrentReport + "DetailsDataSet", details.DefaultView));
if (cr.RowCount > 0)
{
cr.GetClientReturnTotalsForReport(cr.ClientReturnID);
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource("GetClientReturnTotalDataSet", cr.DefaultView));
}
else
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource("GetClientReturnTotalDataSet", new DataView()));
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource("DeliveryOrderTotalDataSet", orderT.DefaultView));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("DeliveryOrderID", Session["Report_DeliveryOrderID"].ToString()));
uiReportViewerMain.LocalReport.Refresh();
}
break;
case "Report_ClientReturn":
if (Session["Report_ClientReturnID"] != null)
{
IStock.BLL.ClientReturns cr = new IStock.BLL.ClientReturns();
cr.Report_ClientReturn(Convert.ToInt32(Session["Report_ClientReturnID"].ToString()));
IStock.BLL.ClientReturnDetails details = new ClientReturnDetails();
details.GetClientReturnDetails(cr.ClientReturnID);
uiReportViewerMain.LocalReport.DataSources.Clear();
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource(CurrentReport + "DataSet", cr.DefaultView));
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource(CurrentReport + "DetailsDataSet", details.DefaultView));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("ClientReturn", Session["Report_ClientReturnID"].ToString()));
uiReportViewerMain.LocalReport.Refresh();
}
break;
case "Report_PurchaseOrder":
if (Session["Report_PuchaseOrderID"] != null)
{
IStock.BLL.PurchaseOrders pr = new IStock.BLL.PurchaseOrders();
pr.Report_PurchaseOrder(Convert.ToInt32(Session["Report_PuchaseOrderID"].ToString()));
IStock.BLL.PurchaseOrderDetails details = new PurchaseOrderDetails();
details.GetPurchaseOrderDetails(pr.PurchaseOrderID);
uiReportViewerMain.LocalReport.DataSources.Clear();
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource(CurrentReport + "DataSet", pr.DefaultView));
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource(CurrentReport + "DetailsDataSet", details.DefaultView));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("PurchaseOrderID", Session["Report_PuchaseOrderID"].ToString()));
uiReportViewerMain.LocalReport.Refresh();
}
break;
case "Report_Payment":
if (Session["Report_PaymentID"] != null)
{
IStock.BLL.Payments payment = new IStock.BLL.Payments();
payment.Report_Payments(Convert.ToInt32(Session["Report_PaymentID"].ToString()));
uiReportViewerMain.LocalReport.DataSources.Clear();
uiReportViewerMain.LocalReport.DataSources.Add(new ReportDataSource(CurrentReport + "DataSet", payment.DefaultView));
uiReportViewerMain.LocalReport.SetParameters(new ReportParameter("PaymentID", Session["Report_PaymentID"].ToString()));
uiReportViewerMain.LocalReport.Refresh();
}
break;
default:
break;
}
}