//constructor
        public ManageSalesOrderList()
        {
            //loading sale list
            SaleManager saleManager = new SaleManager();

            for (Iterator i = saleManager.getAllSaleOrders().iterator(); i.hasNext();)
            {
                SaleInfo   saleInfo   = (SaleInfo)i.next();
                SaleInfoNJ saleInfoNJ = new SaleInfoNJ();
                saleInfoNJ.OrderNo  = saleInfo.getOrderNo();
                saleInfoNJ.StatusId = saleInfo.getStatusId();
                saleInfoNJ.Remarks  = saleInfo.getRemarks();
                for (Iterator j = saleInfo.getProductList().iterator(); j.hasNext();)
                {
                    ProductInfo   productInfo   = (ProductInfo)j.next();
                    ProductInfoNJ productInfoNJ = new ProductInfoNJ();
                    productInfoNJ.Id        = productInfo.getId();
                    productInfoNJ.Name      = productInfo.getName();
                    productInfoNJ.Code      = productInfo.getCode();
                    productInfoNJ.UnitPrice = productInfo.getUnitPrice();
                    productInfoNJ.Quantity  = productInfo.getQuantity();
                    saleInfoNJ.ProductList.Add(productInfoNJ);
                }
                CustomerInfo   customerInfo   = new CustomerInfo();
                CustomerInfoNJ customerInfoNJ = new CustomerInfoNJ();
                customerInfoNJ.ProfileInfoNJ.Id        = saleInfo.getCustomerInfo().getProfileInfo().getId();
                customerInfoNJ.ProfileInfoNJ.FirstName = saleInfo.getCustomerInfo().getProfileInfo().getFirstName();
                customerInfoNJ.ProfileInfoNJ.LastName  = saleInfo.getCustomerInfo().getProfileInfo().getLastName();
                saleInfoNJ.CustomerInfoNJ = customerInfoNJ;
                SaleOrderList.Add(saleInfoNJ);
            }
        }
        public SaleOrderDetail GetSaleOrder(string fromdate, string todate, string Mode, string DistrictId, int UserID, int stateId)
        {
            DataSet ds = _rsdal.GetSaleOrder(fromdate, todate, Mode, DistrictId, UserID, stateId);

            SaleOrderDetail SaleOD = new SaleOrderDetail();

            if (ds != null && ds.Tables[0] != null)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    List <SaleOrderList> _Sale = new List <SaleOrderList>();
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        if (!string.IsNullOrEmpty(ds.Tables[0].Rows[i]["SALECOUNT"].ToString()))
                        {
                            SaleOrderList SaleO = new SaleOrderList();
                            if (Mode.ToUpper().Trim() == "USERWISE")
                            {
                                SaleO.UserId = Convert.ToInt32(ds.Tables[0].Rows[i]["UserID"].ToString());
                            }

                            SaleO.CategoryName = ds.Tables[0].Rows[i]["CategoryName"].ToString();
                            SaleO.SaleCount    = ds.Tables[0].Rows[i]["SALECOUNT"].ToString();
                            SaleO.SaleValue    = Convert.ToDecimal(ds.Tables[0].Rows[i]["SALEVALUE"].ToString());
                            _Sale.Add(SaleO);
                        }
                    }
                    SaleOD.SaleList = _Sale;
                }
            }
            return(SaleOD);
        }
        private void OnSearch()
        {
            SaleManager saleManager = new SaleManager();

            SaleOrderList.Clear();
            for (Iterator i = saleManager.searchAllSaleOrders(SearchSaleByOderNo).iterator(); i.hasNext();)
            {
                SaleInfo   saleInfo   = (SaleInfo)i.next();
                SaleInfoNJ saleInfoNJ = new SaleInfoNJ();

                saleInfoNJ.OrderNo        = saleInfo.getOrderNo();
                saleInfoNJ.CustomerUserId = saleInfo.getCustomerUserId();
                saleInfoNJ.StatusId       = saleInfo.getStatusId();
                saleInfoNJ.SaleDate       = saleInfo.getSaleDate();
                saleInfoNJ.Discount       = saleInfo.getDiscount();
                saleInfoNJ.Remarks        = saleInfo.getRemarks();
                SaleOrderList.Add(saleInfoNJ);
            }
        }