コード例 #1
0
ファイル: Items.aspx.cs プロジェクト: menasbeshay/ivalley-svn
        protected void uiGridViewItems_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "EditItem")
            {
                IStock.BLL.Items objData = new IStock.BLL.Items();
                objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
                uiTextBoxName.Text = objData.Name;
                uiTextBoxCode.Text = objData.ItemCode;
                uiTextBoxDesc.Text = objData.Description;
                if (!objData.IsColumnNull("Quantity"))
                    uiTextBoxQty.Text = objData.Quantity.ToString();
                if(!objData.IsColumnNull("ReOrderLevel"))
                    uiTextBoxReOrderLevel.Text = objData.ReOrderLevel.ToString();

                IStock.BLL.ItemGroups group = new IStock.BLL.ItemGroups();
                group.LoadByPrimaryKey(Convert.ToInt32(objData.GroupID));
                uiLabelGroup.Text = group.Name;

                IStock.BLL.ItemCategories cat = new ItemCategories();
                if (!string.IsNullOrEmpty(uiDropDownListCats.SelectedValue))
                {
                    cat.LoadByPrimaryKey(Convert.ToInt32(uiDropDownListCats.SelectedValue));
                }
                else
                    cat.LoadByPrimaryKey(group.ItemCategoryID);
                uiLabelCat.Text = cat.Name;

                uiPanelAllItems.Visible = false;
                uiPanelEditItems.Visible = true;
                CurrentItem = objData;
                BindPrices();
                uiPanelActions.Visible = true;
            }
            else if (e.CommandName == "DeleteItem")
            {
                try
                {
                    IStock.BLL.Items objData = new IStock.BLL.Items();
                    objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
                    objData.MarkAsDeleted();
                    objData.Save();
                    CurrentItem = null;
                    BindData();
                }
                catch (Exception ex)
                {
                    uipanelError.Visible = true;
                }
            }
            else if (e.CommandName == "GetItemBalance")
            {
                Session["Report_ItemIDForBalance"] = e.CommandArgument.ToString();
                Session["CurrentReport"] = "Report_GetItemsBalances";
                Response.Redirect("Reports.aspx");
            }
        }
コード例 #2
0
        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;
        }
コード例 #3
0
        public string GetItems(string term)
        {
            string ItemsJSON = "";
            Items items = new Items();
            items.SearchItems(term);
            if (items.RowCount > 0)
            {
                ItemsJSON = "[";
                for (int i = 0; i < items.RowCount; i++)
                {
                    ItemsJSON += "'" + items.Name + "'";
                    //ItemsJSON += "{'Name': '" + items.ItemCode + " - " + items.Name + "' , 'ItemID': '" + items.ItemID + "'}";
                    if (items.MoveNext())
                        ItemsJSON += ",";
                }
                ItemsJSON += "]";
            }

            Context.Response.Output.Write(ItemsJSON);
            Context.Response.End();

            return string.Empty;
        }
コード例 #4
0
ファイル: Items.aspx.cs プロジェクト: menasbeshay/ivalley-svn
 private void BindData()
 {
     IStock.BLL.Items objData = new IStock.BLL.Items();
     if (!string.IsNullOrEmpty(uiDropDownListGroup.SelectedValue))
         objData.SearchItems(uiTextBoxSearch.Text, Convert.ToInt32(uiDropDownListGroup.SelectedValue));
     else
         objData.SearchItems(uiTextBoxSearch.Text);
     uiGridViewItems.DataSource = objData.DefaultView;
     uiGridViewItems.DataBind();
 }
コード例 #5
0
ファイル: Items.aspx.cs プロジェクト: menasbeshay/ivalley-svn
        protected void uiLinkButtonOK_Click(object sender, EventArgs e)
        {
            IStock.BLL.Items item = new IStock.BLL.Items();
            if (CurrentItem == null)
                item.AddNew();
            else
                item = CurrentItem;

            item.Name = uiTextBoxName.Text;
            item.Description = uiTextBoxDesc.Text;
            if(!string.IsNullOrEmpty(uiTextBoxQty.Text))
                item.Quantity = Convert.ToInt32(uiTextBoxQty.Text);
            item.ItemCode = uiTextBoxCode.Text;
            item.GroupID = Convert.ToInt32(uiDropDownListGroup.SelectedValue);
            if (!string.IsNullOrEmpty(uiTextBoxReOrderLevel.Text))
                item.ReOrderLevel = Convert.ToInt32(uiTextBoxReOrderLevel.Text);
            item.Save();
            //ClearFields();
            CurrentItem = item;
            uiPanelEditItems.Visible = true;
            uiPanelAllItems.Visible = false;
            BindData();
            BindPrices();
            uiPanelActions.Visible = true;
        }
コード例 #6
0
ファイル: Items.aspx.cs プロジェクト: menasbeshay/ivalley-svn
 protected void uiLinkButtonCancel_Click(object sender, EventArgs e)
 {
     ClearFields();
     CurrentItem = null;
     uiGridViewPrices.DataSource = null;
     uiGridViewPrices.DataBind();
     uiPanelEditItems.Visible = false;
     uiPanelAllItems.Visible = true;
     uiPanelActions.Visible = false;
 }
コード例 #7
0
ファイル: Items.aspx.cs プロジェクト: menasbeshay/ivalley-svn
 protected void uiLinkButtonBack_Click(object sender, EventArgs e)
 {
     ClearFields();
     CurrentItem = null;
     uiPanelEditItems.Visible = false;
     uiPanelAllItems.Visible = true;
     uiPanelActions.Visible = false;
 }
コード例 #8
0
ファイル: Items.aspx.cs プロジェクト: menasbeshay/ivalley-svn
        protected void uiLinkButtonAdd_Click(object sender, EventArgs e)
        {
            ClearFields();
            CurrentItem = null;
            uiGridViewPrices.DataSource = null;
            uiGridViewPrices.DataBind();
            IStock.BLL.Items item = new IStock.BLL.Items();
            uiTextBoxCode.Text = item.GenerateItemCode(Convert.ToInt32(uiDropDownListGroup.SelectedValue)).ToString();
            uiPanelEditItems.Visible = true;
            uiPanelAllItems.Visible = false;
            uiPanelActions.Visible = false;

            IStock.BLL.ItemCategories cat = new ItemCategories();
            cat.LoadByPrimaryKey(Convert.ToInt32(uiDropDownListCats.SelectedValue));
            uiLabelCat.Text = cat.Name;

            IStock.BLL.ItemGroups group = new IStock.BLL.ItemGroups();
            group.LoadByPrimaryKey(Convert.ToInt32(uiDropDownListGroup.SelectedValue));
            uiLabelGroup.Text = group.Name;
        }
コード例 #9
0
        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;
            }
        }