public ActionResult GetAllClickData(int LabNo) { BL_PatientXRay BL_obj = new BL_PatientXRay(); DataSet ds = new DataSet(); List <PatientXRay> searclist = new List <Models.Laboratory.PatientXRay>(); ds = BL_obj.GetPatientWiseResultForPatientSearch(LabNo); foreach (DataRow dr in ds.Tables[1].Rows) { PatientXRay obj = new PatientXRay(); obj.LabNo = ds.Tables[0].Rows[0]["LabNo"].ToString(); obj.PatientRegNo = ds.Tables[0].Rows[0]["PatientRegNo"].ToString(); obj.PatientName = ds.Tables[0].Rows[0]["PatientName"].ToString(); obj.DoctorName = ds.Tables[0].Rows[0]["DoctorPrintName"].ToString(); obj.TestID = dr["TestID"].ToString(); obj.Testname = dr["TestName"].ToString(); searclist.Add(obj); } return(Json(searclist, JsonRequestBehavior.AllowGet)); }
public ActionResult GetPatientWiseValue(int LabNo, int TestID) { BL_PatientXRay BL_obj = new BL_PatientXRay(); DataSet ds = new DataSet(); List <PatientXRay> searclist = new List <Models.Laboratory.PatientXRay>(); ds = BL_obj.GetPatientWiseXrayResult(LabNo, TestID); foreach (DataRow dr in ds.Tables[0].Rows) { PatientXRay obj = new PatientXRay(); obj.Footer = ds.Tables[0].Rows[0]["Footer"].ToString(); obj.TestID = ds.Tables[0].Rows[0]["TestID"].ToString(); obj.LabNo = ds.Tables[0].Rows[0]["LabNo"].ToString(); searclist.Add(obj); } return(Json(searclist, JsonRequestBehavior.AllowGet)); }
public ActionResult PatientXRay(PatientXRay obj, FormCollection fc) { try { BL_PatientXRay _PatientXRay = new BL_PatientXRay(); if (Request.Form["LabNo"] != null) { obj.LabNo = Request.Form["LabNo"].ToString(); } else { obj.LabNo = ""; } if (obj.TestID != null) { obj.TestID = fc["TestID"].ToString(); } else { obj.TestID = ""; } if (_PatientXRay.SaveXRay(obj)) { { ModelState.Clear(); TempData["msg"] = "PatientXray Saved Successfully"; return(RedirectToAction("PatientXRay", "PatientXRay")); } } } catch (Exception exe) { throw; } return(View()); }
public ActionResult PatientBind(string FromDate, string Todate) { BL_PatientXRay BL_obj = new BL_PatientXRay(); DataSet ds = new DataSet(); List <PatientXRay> searclist = new List <Models.Laboratory.PatientXRay>(); ds = BL_obj.SearchPatientLabResultEntryByNameID("%", Convert.ToDateTime(FromDate), Convert.ToDateTime(Todate)); foreach (DataRow dr in ds.Tables[0].Rows) { PatientXRay obj = new PatientXRay(); obj.PatientName = dr["PatientName"].ToString(); obj.PatientType = dr["PatientType"].ToString(); obj.LabNo = dr["LabNo"].ToString(); obj.LabDate = dr["LAB DATE"].ToString(); searclist.Add(obj); } return(Json(searclist, JsonRequestBehavior.AllowGet)); }
public ActionResult GetPatientName(string prefix) { BL_PatientXRay objPatient = new BL_PatientXRay(); List <PatientXRay> searchList = new List <PatientXRay>(); DataSet ds1 = objPatient.GetPatient(prefix); { foreach (DataRow dr in ds1.Tables[0].Rows) { PatientXRay Patient = new PatientXRay(); Patient.PatientRegNo = dr["PatientRegNo"].ToString(); Patient.PatientName = dr["PatientName"].ToString(); searchList.Add(Patient); } } return(new JsonResult { Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public bool SaveXRay(PatientXRay obj) { Connect(); SqlCommand cmd = new SqlCommand("IUPatientLabWithParameter", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (obj.PatientLabParameterID == 0) { cmd.Parameters.AddWithValue("@PatientLabParameterID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@PatientLabParameterID", obj.PatientLabParameterID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@LabNo", obj.LabNo); cmd.Parameters.AddWithValue("@PatientLabDetailID", 0); cmd.Parameters.AddWithValue("@TestID", obj.TestID); cmd.Parameters.AddWithValue("@ParameterID", 0); cmd.Parameters.AddWithValue("@NormalRangeID", 0); cmd.Parameters.AddWithValue("@ResultValue", ""); cmd.Parameters.AddWithValue("@Status", ""); cmd.Parameters.AddWithValue("@NLH", ""); cmd.Parameters.AddWithValue("@ConvLow", ""); cmd.Parameters.AddWithValue("@ConvHigh", ""); cmd.Parameters.AddWithValue("@Remark", ""); if (obj.Description == null) { cmd.Parameters.AddWithValue("@Footer", ""); } else { if (obj.Description == "<p><br></p>" || obj.Description == "<h1><br></h1>" || obj.Description == "<h2><br></h2>" || obj.Description == "<h3><br></h3>") { cmd.Parameters.AddWithValue("@Footer", ""); } else { cmd.Parameters.AddWithValue("@Footer", (obj.Description)); } } cmd.Parameters.AddWithValue("@CompleteBy", ""); cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } }