public JsonResult GetAllBirthCert(string prefix)
        {
            BL_BirthCertificate db = new BL_BirthCertificate();

            return(new JsonResult {
                Data = db.SelectAllData(), JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }
        public JsonResult GetAllFinancialYear()
        {
            BL_BirthCertificate bl_death   = new BL_BirthCertificate();
            DataSet             ds         = bl_death.GetAllFinancialYear();
            List <OPDBill>      searchList = new List <OPDBill>();
            DataView            dvTest     = new DataView(ds.Tables[0], "FinancialYearID = " + ds.Tables[1].Rows[0]["FinancialYearID"].ToString() + " ", "", DataViewRowState.CurrentRows);

            dvTest.ToTable().Rows[0]["FinancialYear"].ToString();
            foreach (DataRow dr in dvTest.ToTable().Rows)
            {
                searchList.Add(new OPDBill
                {
                    FinancialYear   = dr["FinancialYear"].ToString(),
                    FinancialYearID = Convert.ToInt32(dr["FinancialYearID"])
                });
            }
            return(new JsonResult {
                Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }