Example #1
0
        public ActionResult IncomeList()
        {
            List <IncomeList> CategoryList = new List <IncomeList>();
            Property          p            = new Property();
            DataSet           ds           = new DataSet();

            p.OnTable = "FetchIncomeList";

            ds = dl.FetchIncomeList_sp(p);

            List <SelectListItem> Categoryinventory = new List <SelectListItem>();

            Categoryinventory.Add(new SelectListItem {
                Text = "Select", Value = ""
            });
            foreach (DataRow dr in ds.Tables[1].Rows)
            {
                Categoryinventory.Add(new SelectListItem {
                    Text = dr["HeadName"].ToString(), Value = dr["HeadId"].ToString()
                });
            }
            ViewBag.Categoryinventory = new SelectList(Categoryinventory, "Value", "Text");


            try
            {
                foreach (DataRow item in ds.Tables[0].Rows)
                {
                    IncomeList m = new IncomeList();

                    m.Id          = item["Id"].ToString();
                    m.HeadId      = item["HeadId"].ToString();
                    m.HeadName    = item["HeadName"].ToString();
                    m.Name        = item["Name"].ToString();
                    m.InvoiceNo   = item["InvoiceNo"].ToString();
                    m.Date        = item["Date"].ToString();
                    m.Amount      = item["Amount"].ToString();
                    m.Attachment  = item["Attachment"].ToString();
                    m.Description = item["Description"].ToString();
                    m.IsActive    = item["IsActive"].ToString();
                    CategoryList.Add(m);
                }
                ViewBag.CategoryList = CategoryList;
            }
            catch (Exception e)
            {
            }
            return(View());
        }