public ActionResult BindPatient(string Name)
        {
            DataSet ds = BL_obj.BindPatient(Name);
            List <PatientMedicalBill> obj = new List <Models.Pharmacy.PatientMedicalBill>();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                obj.Add(new Models.Pharmacy.PatientMedicalBill
                {
                    PatientRegNO = dr["PatientRegNO"].ToString(),
                    PatientName  = dr["PatientName"].ToString()
                });
            }
            return(new JsonResult {
                Data = obj, JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }