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);
}
}
