コード例 #1
0
        public ActionResult Code()
        {
            List <CodeModel> CategoryList = new List <CodeModel>();
            Property         p            = new Property();
            DataSet          ds           = new DataSet();

            p.OnTable = "FetchCode";

            ds = dl.FetchCode_sp(p);

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

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


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

                    m.CodeId             = item["CodeId"].ToString();
                    m.Code               = item["Code"].ToString();
                    m.StandardCharge     = item["StandardCharge"].ToString();
                    m.ChargeCategoryId   = item["ChargeCategoryId"].ToString();
                    m.ChargeCategoryName = item["ChargeCategoryName"].ToString();
                    m.HospitalId         = item["HospitalId"].ToString();
                    m.IsActive           = item["IsActive"].ToString();
                    CategoryList.Add(m);
                }
                ViewBag.CategoryList = CategoryList;
            }
            catch (Exception e)
            {
            }
            return(View());
        }