public ActionResult AjaxMethod_PatName(string patnm)
        {
            KeystoneProject.Buisness_Logic.Pharmacy.BL_PatientMedicalBill BL_obj = new BL_PatientMedicalBill();
            KeystoneProject.Models.Pharmacy.PatientMedicalBill            obj    = new PatientMedicalBill();
            List <PatientMedicalBill> searchList = new List <PatientMedicalBill>();

            DataSet   ds = BL_obj.BindRegno(patnm);
            DataTable dt = new DataTable();

            dt = BL_obj.Bind_patDetail(Convert.ToInt32(ds.Tables[0].Rows[0]["PatientRegNO"]));

            foreach (DataRow dr in dt.Rows)
            {
                searchList.Add(
                    new PatientMedicalBill
                {
                    PatientName     = Convert.ToString(dr["PatientName"]),
                    PatientRegNO    = Convert.ToString(dr["PatientRegNO"]),
                    CustomerName    = Convert.ToString(dr["PatientName"]),
                    PatientType     = Convert.ToString(dr["PatientType"]),
                    Address         = Convert.ToString(dr["Address"]),
                    DoctorPrintName = Convert.ToString(dr["DoctorPrintName"]),
                });
            }
            return(new JsonResult
            {
                Data = searchList,
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }
        public JsonResult Bind_oldPrint(string patnm)
        {
            DataSet ds = BL_obj.BindRegno(patnm);

            return(new JsonResult {
                Data = BL_obj.Bind_oldPrint(Convert.ToInt16(ds.Tables[0].Rows[0]["PatientRegNO"].ToString())), JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }
        public ActionResult AjaxMethod_OldBill(string patnm)
        {
            KeystoneProject.Buisness_Logic.Pharmacy.BL_PatientMedicalBill BL_obj = new BL_PatientMedicalBill();
            KeystoneProject.Models.Pharmacy.PatientMedicalBill            obj    = new PatientMedicalBill();
            List <PatientMedicalBill> searchList = new List <PatientMedicalBill>();

            DataTable dt = new DataTable();
            DataSet   ds = BL_obj.BindRegno(patnm);

            dt = BL_obj.GetOldBill(Convert.ToInt16(ds.Tables[0].Rows[0]["PatientRegNO"].ToString()));

            foreach (DataRow dr in dt.Rows)
            {
                searchList.Add(
                    new PatientMedicalBill
                {
                    BillNo = Convert.ToString(dr["BillNo&Date"]),
                });
            }

            return(new JsonResult {
                Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }