public JsonResult FillData(string prefix)
{
BL_PatientPrescriptionNew BL_obj = new BL_PatientPrescriptionNew();
List <PatientPrescriptionNew> lists = new List <PatientPrescriptionNew>();
HospitlLocationID();
try
{
DataSet dsDetails = BL_obj.GetPatientData(HospitalID, LocationID, Convert.ToInt32(prefix));
if (dsDetails.Tables[0].Rows.Count > 0)
{
PatientPrescriptionNew obj = new PatientPrescriptionNew();
obj.Message = "";
obj.PatientRegNO = Convert.ToInt32(dsDetails.Tables[0].Rows[0]["PatientRegNO"].ToString());
obj.PatientName = dsDetails.Tables[0].Rows[0]["PatientName"].ToString();
obj.OPDIPDID = Convert.ToInt32(dsDetails.Tables[0].Rows[0]["OPDIPDID"].ToString());
obj.GuardianName = dsDetails.Tables[0].Rows[0]["GuardianName"].ToString();
obj.Age = dsDetails.Tables[0].Rows[0]["Age"].ToString();
obj.AgeType = dsDetails.Tables[0].Rows[0]["AgeType"].ToString();
obj.Gender = dsDetails.Tables[0].Rows[0]["Gender"].ToString();
lists.Add(obj);
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(lists, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTabSection2(string tabsection2)
{
PatientPrescriptionNew obj = new PatientPrescriptionNew();
Session["tabsection2"] = tabsection2;
Session["tabsection1"] = "false";
return(Json("", JsonRequestBehavior.AllowGet));
}
public JsonResult BindName(string prefix)
{
HospitlLocationID();
BL_PatientPrescriptionNew BL_obj = new BL_PatientPrescriptionNew();
DataSet ds = BL_obj.SearchPatientOPDByNameID(HospitalID, LocationID, prefix);
List <PatientPrescriptionNew> lists = new List <PatientPrescriptionNew>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
PatientPrescriptionNew obj = new PatientPrescriptionNew();
obj.PatientRegNO = Convert.ToInt32(dr["PatientRegNO"].ToString());
obj.PatientName = dr["Name"].ToString();
lists.Add(obj);
}
return(Json(lists, JsonRequestBehavior.AllowGet));
}
public ActionResult FillRegDetails(int PatientRegNO)
{
BL_PatientPrescriptionNew BL_obj = new BL_PatientPrescriptionNew();
DataSet ds = new DataSet();
List <PatientPrescriptionNew> searclist = new List <Models.Patient.PatientPrescriptionNew>();
ds = BL_obj.GetConsentMaster(PatientRegNO);
foreach (DataRow dr in ds.Tables[0].Rows)
{
PatientPrescriptionNew obj = new PatientPrescriptionNew();
obj.PatientRegNO = Convert.ToInt32(ds.Tables[0].Rows[0]["PatientRegNO"]);
obj.PrintRegNO = Convert.ToInt32(ds.Tables[0].Rows[0]["PrintRegNO"]);
obj.PatientName = ds.Tables[0].Rows[0]["PatientName"].ToString();
obj.GuardianName = ds.Tables[0].Rows[0]["GuardianName"].ToString();
obj.OPDIPDID = Convert.ToInt32(ds.Tables[0].Rows[0]["OPDIPDID"]);
obj.Age = ds.Tables[0].Rows[0]["Age"].ToString();
obj.AgeType = ds.Tables[0].Rows[0]["AgeType"].ToString();
obj.Gender = ds.Tables[0].Rows[0]["Gender"].ToString();
searclist.Add(obj);
}
return(Json(searclist, JsonRequestBehavior.AllowGet));
}
public bool Save1(PatientPrescriptionNew objmodel)
{
Connect();
try
{
// string[] Investigation = objmodel.Investigations.Split(',');
string Newid = objmodel.PatientPrescriptionNewID;
SqlCommand cmd1 = new SqlCommand("IUPatientPrescriptionNew", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd1.Parameters.AddWithValue("@LocationID", LocationID);
if (objmodel.PatientPrescriptionNewID != "" && objmodel.PatientPrescriptionNewID != null)
{
cmd1.Parameters.AddWithValue("@PatientPrescriptionNewID", objmodel.PatientPrescriptionNewID);
}
else
{
cmd1.Parameters.AddWithValue("@PatientPrescriptionNewID", 0);
cmd1.Parameters["@PatientPrescriptionNewID"].Direction = ParameterDirection.Output;
}
cmd1.Parameters.AddWithValue("@PatientRegNo", objmodel.PatientRegNO1);
cmd1.Parameters.AddWithValue("@OPDIPDID", objmodel.OPDIPDID1);
cmd1.Parameters.AddWithValue("@Date", objmodel.Date1);
cmd1.Parameters.AddWithValue("@Height", objmodel.Height1);
cmd1.Parameters.AddWithValue("@Weight", objmodel.Weight1);
cmd1.Parameters.AddWithValue("@Pulse", objmodel.Pulse1);
cmd1.Parameters.AddWithValue("@BP", objmodel.BP1);
cmd1.Parameters.AddWithValue("@BMI", objmodel.BMI1);
cmd1.Parameters.AddWithValue("@Temp", objmodel.Temp1);
if (objmodel.ChiefComplaint1 != null)
{
cmd1.Parameters.AddWithValue("@ChiefComplaint", WebUtility.HtmlEncode(objmodel.ChiefComplaint1).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@ChiefComplaint", "");
}
if (objmodel.Allergies1 != null)
{
cmd1.Parameters.AddWithValue("@Allergies", WebUtility.HtmlEncode(objmodel.Allergies1).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@Allergies", "");
}
if (objmodel.ClinicalFinding1 != null)
{
cmd1.Parameters.AddWithValue("@ClinicalFindings", WebUtility.HtmlEncode(objmodel.ClinicalFinding1).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@ClinicalFindings", "");
}
if (objmodel.ProvitionalDiagnosis1 != null)
{
cmd1.Parameters.AddWithValue("@ProvisionalDiagonosis", WebUtility.HtmlEncode(objmodel.ProvitionalDiagnosis1).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@ProvisionalDiagonosis", "");
}
if (objmodel.Investigation1 != null)
{
cmd1.Parameters.AddWithValue("@Investigations", WebUtility.HtmlEncode(objmodel.Investigation1).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@Investigations", "");
}
if (objmodel.TreatmentAdvice1 != null)
{
cmd1.Parameters.AddWithValue("@TreatmentAdvice", WebUtility.HtmlEncode(objmodel.TreatmentAdvice1).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@TreatmentAdvice", "");
}
cmd1.Parameters.AddWithValue("@Remark", objmodel.Remark1);
cmd1.Parameters.AddWithValue("@FollowUpDate", objmodel.FollowUpDate1);
cmd1.Parameters.AddWithValue("@FollowUpTime", Convert.ToDateTime(objmodel.FollowUpTime1).ToString("hh:mm:ss tt"));
string date = Convert.ToDateTime(objmodel.FollowUpTime1).ToString("hh:mm:ss tt");
cmd1.Parameters.AddWithValue("@CreationID", UserID);
if (objmodel.PatientPrescriptionNewID != "" && objmodel.PatientPrescriptionNewID != null)
{
cmd1.Parameters.AddWithValue("@Mode", "Edit");
}
else
{
cmd1.Parameters.AddWithValue("@Mode", "Add");
}
con.Open();
int i = cmd1.ExecuteNonQuery();
con.Close();
objmodel.PatientPrescriptionNewID = Convert.ToString(cmd1.Parameters["@PatientPrescriptionNewID"].Value);
string[] Medicines1 = objmodel.Medicines1.Split(',');
Medicines1 = Medicines1.Where(x => !string.IsNullOrEmpty(x)).ToArray();
string[] Strength1 = objmodel.Strength1.Split(',');
string[] Frequency1 = objmodel.Frequency1.Split(',');
string[] Days1 = objmodel.Days1.Split(',');
string[] Instruction1 = objmodel.Instruction1.Split(',');
string[] MedicinesID1 = objmodel.MedicineLibraryID1.Split(',');
for (int k = 0; k < Medicines1.Length; k++)
{
if (Medicines1[k].ToString() != "")
{
#region IUPatientPrescriptionNewMedicine
SqlCommand cmd = new SqlCommand("IUPatientPrescriptionNewMedicine", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PatientPrescriptionNewID", objmodel.PatientPrescriptionNewID);
cmd.Parameters.AddWithValue("@PatientPrescriptionNewMedicineID", 0);
cmd.Parameters["@PatientPrescriptionNewMedicineID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@PatientRegNo", objmodel.PatientRegNO1);
cmd.Parameters.AddWithValue("@OPDIPDID", objmodel.OPDIPDID1);
cmd.Parameters.AddWithValue("@MedicineLibraryID", MedicinesID1[k]);
cmd.Parameters.AddWithValue("@Medicines", Medicines1[k]);
cmd.Parameters.AddWithValue("@Strength", Strength1[k]);
cmd.Parameters.AddWithValue("@Frequency", Frequency1[k]);
cmd.Parameters.AddWithValue("@Instruction", Instruction1[k]);
cmd.Parameters.AddWithValue("@Days", Days1[k]);
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", "Add");
con.Open();
int j = cmd.ExecuteNonQuery();
con.Close();
#endregion
}
}
}
catch (Exception ex)
{
}
return(true);
}
public bool Save(PatientPrescriptionNew objmodel)
{
Connect();
try
{
// string[] Investigation = objmodel.Investigations.Split(',');
string Newid = objmodel.PatientPrescriptionNewID;
SqlCommand cmd1 = new SqlCommand("IUPatientPrescriptionNew", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd1.Parameters.AddWithValue("@LocationID", LocationID);
if (objmodel.PatientPrescriptionNewID != "" && objmodel.PatientPrescriptionNewID != null)
{
cmd1.Parameters.AddWithValue("@PatientPrescriptionNewID", objmodel.PatientPrescriptionNewID);
}
else
{
cmd1.Parameters.AddWithValue("@PatientPrescriptionNewID", 0);
cmd1.Parameters["@PatientPrescriptionNewID"].Direction = ParameterDirection.Output;
}
cmd1.Parameters.AddWithValue("@PatientRegNo", objmodel.PatientRegNO);
cmd1.Parameters.AddWithValue("@OPDIPDID", objmodel.OPDIPDID);
cmd1.Parameters.AddWithValue("@Date", DateTime.Now);
cmd1.Parameters.AddWithValue("@Height", objmodel.Height);
cmd1.Parameters.AddWithValue("@Weight", objmodel.Weight);
cmd1.Parameters.AddWithValue("@Pulse", objmodel.Pulse);
cmd1.Parameters.AddWithValue("@BP", objmodel.BP);
cmd1.Parameters.AddWithValue("@BMI", objmodel.BMI);
cmd1.Parameters.AddWithValue("@Temp", objmodel.Temp);
if (objmodel.txtChiefComplaintName != null)
{
cmd1.Parameters.AddWithValue("@ChiefComplaint", WebUtility.HtmlEncode(objmodel.txtChiefComplaintName).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@ChiefComplaint", "");
}
if (objmodel.txtAllergiesName != null)
{
cmd1.Parameters.AddWithValue("@Allergies", WebUtility.HtmlEncode(objmodel.txtAllergiesName).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@Allergies", "");
}
if (objmodel.txtClinicalFindingName != null)
{
cmd1.Parameters.AddWithValue("@ClinicalFindings", WebUtility.HtmlEncode(objmodel.txtClinicalFindingName).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@ClinicalFindings", "");
}
if (objmodel.txtProvitionalDiagnosisName != null)
{
cmd1.Parameters.AddWithValue("@ProvisionalDiagonosis", WebUtility.HtmlEncode(objmodel.txtProvitionalDiagnosisName).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@ProvisionalDiagonosis", "");
}
if (objmodel.txtInvestigationsName != null)
{
cmd1.Parameters.AddWithValue("@Investigations", WebUtility.HtmlEncode(objmodel.txtInvestigationsName).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@Investigations", "");
}
if (objmodel.txtTreatmentAdviceName != null)
{
cmd1.Parameters.AddWithValue("@TreatmentAdvice", WebUtility.HtmlEncode(objmodel.txtTreatmentAdviceName).Replace("\r\n", "<br>"));
}
else
{
cmd1.Parameters.AddWithValue("@TreatmentAdvice", "");
}
cmd1.Parameters.AddWithValue("@Remark", objmodel.Remark);
cmd1.Parameters.AddWithValue("@FollowUpDate", objmodel.FollowUpDate);
cmd1.Parameters.AddWithValue("@FollowUpTime", Convert.ToDateTime(objmodel.FollowUpTime).ToString("hh:mm:ss tt"));
string date = Convert.ToDateTime(objmodel.FollowUpTime).ToString("hh:mm:ss tt");
cmd1.Parameters.AddWithValue("@CreationID", UserID);
if (objmodel.PatientPrescriptionNewID != "" && objmodel.PatientPrescriptionNewID != null)
{
cmd1.Parameters.AddWithValue("@Mode", "Edit");
}
else
{
cmd1.Parameters.AddWithValue("@Mode", "Add");
}
con.Open();
int i = cmd1.ExecuteNonQuery();
con.Close();
objmodel.PatientPrescriptionNewID = Convert.ToString(cmd1.Parameters["@PatientPrescriptionNewID"].Value);
string[] Medicines = objmodel.Medicines.Split(',');
Medicines = Medicines.Where(x => !string.IsNullOrEmpty(x)).ToArray();
string[] Strength = objmodel.Strength.Split(',');
string[] Frequency = objmodel.Frequency.Split(',');
string[] Days = objmodel.Days.Split(',');
string[] Instruction = objmodel.Instruction.Split(',');
string[] MedicinesID = objmodel.MedicineLibraryID.Split(',');
#region Patient prescription Med
for (int k = 0; k < Medicines.Length; k++)
{
if (Medicines[k].ToString() != "")
{
#region IUPatientPrescriptionNewMedicine
SqlCommand cmd = new SqlCommand("IUPatientPrescriptionNewMedicine", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PatientPrescriptionNewID", objmodel.PatientPrescriptionNewID);
cmd.Parameters.AddWithValue("@PatientPrescriptionNewMedicineID", 0);
cmd.Parameters["@PatientPrescriptionNewMedicineID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@PatientRegNo", objmodel.PatientRegNO);
cmd.Parameters.AddWithValue("@OPDIPDID", objmodel.OPDIPDID);
cmd.Parameters.AddWithValue("@MedicineLibraryID", MedicinesID[k]);
cmd.Parameters.AddWithValue("@Medicines", Medicines[k]);
cmd.Parameters.AddWithValue("@Strength", Strength[k]);
cmd.Parameters.AddWithValue("@Frequency", Frequency[k]);
cmd.Parameters.AddWithValue("@Instruction", Instruction[k]);
cmd.Parameters.AddWithValue("@Days", Days[k]);
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", "Add");
con.Open();
int j = cmd.ExecuteNonQuery();
con.Close();
#endregion
}
}
#endregion
if (objmodel.ICDCodeID != null)
{
#region ICDCodes
string[] ICDCodeID = objmodel.ICDCodeID.Split(',');
string[] ICDName = objmodel.ICDName.Split(',');
string[] ICDCode = objmodel.ICDCode.Split(',');
for (int m = 0; m < ICDCodeID.Length; m++)
{
if (ICDCodeID[m].ToString() != "")
{
#region IUPatientPrescriptionNewICDCodes
SqlCommand cmd = new SqlCommand("IUPatientPrescriptionNewICDCodes", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PatientPrescriptionNewID", objmodel.PatientPrescriptionNewID);
cmd.Parameters.AddWithValue("@PatientPrescriptionNewICDCodesID", 0);
cmd.Parameters["@PatientPrescriptionNewICDCodesID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@PatientRegNo", objmodel.PatientRegNO);
cmd.Parameters.AddWithValue("@OPDIPDID", objmodel.OPDIPDID);
cmd.Parameters.AddWithValue("@ICDCodeID", ICDCodeID[m]);
cmd.Parameters.AddWithValue("@ICDName", ICDName[m]);
cmd.Parameters.AddWithValue("@ICDCode", ICDCode[m]);
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", "Add");
con.Open();
int j = cmd.ExecuteNonQuery();
con.Close();
#endregion
}
}
}
#endregion
}
catch (Exception ex)
{
}
return(true);
}
public ActionResult PatientPrescriptionNew(PatientPrescriptionNew objPatientPrescriptionNew)
{
try
{
objPatientPrescriptionNew.PatientPrescriptionNewID = Request.Form["OldPrescriptionID"].ToString();
objPatientPrescriptionNew.Tabsection1 = Session["tabsection1"].ToString();
objPatientPrescriptionNew.Tabsection2 = Session["tabsection2"].ToString();
if (objPatientPrescriptionNew.Tabsection1 == "true")
{
//objPatientPrescriptionNew.txtChiefComplaint = WebUtility.HtmlEncode(Request.Form["txtChiefComplaintName"]).Replace("\r\n", "<br>");
//objPatientPrescriptionNew.txtAllergies = Request.Form["txtAllergiesName"].ToString();
//objPatientPrescriptionNew.txtClinicalFinding = Request.Form["txtClinicalFindingName"].ToString();
//objPatientPrescriptionNew.txtProvitionalDiagnosis = Request.Form["txtProvitionalDiagnosisName"].ToString();
//objPatientPrescriptionNew.txtInvestigations = Request.Form["txtInvestigationsName"].ToString();
//objPatientPrescriptionNew.txtTreatmentAdvice = Request.Form["txtTreatmentAdviceName"].ToString();
objPatientPrescriptionNew.MedicineLibraryID = Request.Form["MedicineLibraryID"].ToString();
objPatientPrescriptionNew.Medicines = Request.Form["Medicines"].ToString();
objPatientPrescriptionNew.Strength = Request.Form["Strength"].ToString();
objPatientPrescriptionNew.Frequency = Request.Form["Frequency"].ToString();
objPatientPrescriptionNew.Days = Request.Form["Days"].ToString();
objPatientPrescriptionNew.Instruction = Request.Form["Instruction"].ToString();
if (objPatientPrescriptionNew.ICDCodeIDhidden != "" && objPatientPrescriptionNew.ICDCodeIDhidden != null)
{
objPatientPrescriptionNew.ICDCodeID = Request.Form["ICDCodeID"].ToString();
objPatientPrescriptionNew.ICDCode = Request.Form["ICDCode"].ToString();
objPatientPrescriptionNew.ICDName = Request.Form["ICDName"].ToString();
}
if (blobj.Save(objPatientPrescriptionNew))
{
ModelState.Clear();
ViewData["flag"] = "Done";
}
Session["HospitalIDReport"] = HospitalID;
Session["LocationIDReport"] = LocationID;
Session["PatientRegNoReport"] = objPatientPrescriptionNew.PatientRegNO.ToString();
Session["PatientPrescriptionNewIDReport"] = objPatientPrescriptionNew.PatientPrescriptionNewID.ToString();
Session["PatientOPDIPDReport"] = objPatientPrescriptionNew.OPDIPDID.ToString();
}
else
if (objPatientPrescriptionNew.Tabsection2 == "true")
{
objPatientPrescriptionNew.MedicineLibraryID1 = Request.Form["MedicineLibraryID1"].ToString();
objPatientPrescriptionNew.Medicines1 = Request.Form["Medicines1"].ToString();
objPatientPrescriptionNew.Strength1 = Request.Form["Strength1"].ToString();
objPatientPrescriptionNew.Frequency1 = Request.Form["Frequency1"].ToString();
objPatientPrescriptionNew.Days1 = Request.Form["Days1"].ToString();
objPatientPrescriptionNew.Instruction1 = Request.Form["Instruction1"].ToString();
if (blobj.Save1(objPatientPrescriptionNew))
{
ModelState.Clear();
ViewData["flag"] = "Done";
}
Session["HospitalIDReport"] = HospitalID;
Session["LocationIDReport"] = LocationID;
Session["PatientRegNoReport"] = objPatientPrescriptionNew.PatientRegNO1.ToString();
Session["PatientPrescriptionNewIDReport"] = objPatientPrescriptionNew.PatientPrescriptionNewID.ToString();
Session["PatientOPDIPDReport"] = objPatientPrescriptionNew.OPDIPDID1.ToString();
}
return(RedirectToAction("RptPatientPrescriptionNew", "PatientReport"));
}
catch (Exception Ex)
{
return(RedirectToAction("PatientPrescriptionNew", "PatientPrescriptionNew"));
}
}
public JsonResult GetPatientPrescriptionOld(string OldPrescriptionID)
{
HospitlLocationID();
DataSet ds1 = blobj.GetOLDPatientPrescriptionNew(OldPrescriptionID, HospitalID, LocationID);
DataSet ds = blobj.GetPatientPrescriptionNewMedicine(OldPrescriptionID, HospitalID, LocationID);
DataSet ds2 = blobj.GetPatientPrescriptionICDCodes(OldPrescriptionID, HospitalID, LocationID);
List <PatientPrescriptionNew> searchlistMed = new List <PatientPrescriptionNew>();
List <PatientPrescriptionNew> SearchlistOld = new List <PatientPrescriptionNew>();
List <PatientPrescriptionNew> searchlistICD = new List <PatientPrescriptionNew>();
PatientPrescriptionNew obj = new PatientPrescriptionNew();
obj.Tabsection2 = Session["tabsection2"].ToString();
obj.Tabsection1 = Session["tabsection1"].ToString();
if (obj.Tabsection1 == "true")
{
foreach (DataRow dr in ds1.Tables[0].Rows)
{
// PatientPrescriptionNewMedicineID = ds.Tables[0].Rows[0]["PatientPrescriptionNewMedicineID"].ToString(),
obj.PatientPrescriptionNewID = ds1.Tables[0].Rows[0]["PatientPrescriptionNewID"].ToString();
obj.Date = Convert.ToDateTime(ds1.Tables[0].Rows[0]["DATE"]).ToString("yyyy-MM-dd");
obj.OPDIPDID = Convert.ToInt32(ds1.Tables[0].Rows[0]["OPDIPDID"].ToString());
obj.ChiefComplaint = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["ChiefComplaint"].ToString());
obj.Allergies = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["Allergies"].ToString());
obj.Height = ds1.Tables[0].Rows[0]["Height"].ToString();
obj.Weight = ds1.Tables[0].Rows[0]["Weight"].ToString();
obj.Pulse = ds1.Tables[0].Rows[0]["Pulse"].ToString();
obj.BP = ds1.Tables[0].Rows[0]["BP"].ToString();
obj.BMI = ds1.Tables[0].Rows[0]["BMI"].ToString();
obj.Temp = ds1.Tables[0].Rows[0]["Temp"].ToString();
obj.ClinicalFindings = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["ClinicalFindings"].ToString());
obj.ProvisionalDiagonosis = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["ProvisionalDiagonosis"].ToString());
obj.Investigations = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["Investigations"].ToString());
obj.TreatmentAdvice = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["TreatmentAdvice"].ToString());
obj.Remark = ds1.Tables[0].Rows[0]["Remark"].ToString();
if (ds1.Tables[0].Rows[0]["FollowUpDate"].ToString() == "")
{
obj.FollowUpDate = ds1.Tables[0].Rows[0]["FollowUpDate"].ToString();
}
else
{
obj.FollowUpDate = Convert.ToDateTime(ds1.Tables[0].Rows[0]["FollowUpDate"]).ToString("yyyy-MM-dd");
}
if (ds1.Tables[0].Rows[0]["FollowUpDate"].ToString() == "")
{
obj.FollowUpDate = ds1.Tables[0].Rows[0]["FollowUpTime"].ToString();
}
else
{
obj.FollowUpTime = Convert.ToDateTime(ds1.Tables[0].Rows[0]["FollowUpTime"]).ToString("hh:mm:ss");
}
SearchlistOld.Add(obj);
}
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
searchlistMed.Add(new PatientPrescriptionNew
{
// PatientPrescriptionNewMedicineID = ds.Tables[0].Rows[0]["PatientPrescriptionNewMedicineID"].ToString(),
MedicineLibraryID = dr1["MedicineLibraryID"].ToString(),
Medicines = dr1["Medicines"].ToString(),
Frequency = dr1["Frequency"].ToString(),
Days = dr1["Days"].ToString(),
Instruction = dr1["Instruction"].ToString(),
Strength = dr1["Strength"].ToString()
});
}
if (ds2.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr1 in ds2.Tables[0].Rows)
{
searchlistICD.Add(new PatientPrescriptionNew
{
// PatientPrescriptionNewMedicineID = ds.Tables[0].Rows[0]["PatientPrescriptionNewMedicineID"].ToString(),
ICDCode = dr1["ICDCode"].ToString(),
ICDName = dr1["ICDName"].ToString(),
ICDCodeID = dr1["ICDCodeID"].ToString(),
});
}
}
}
else if (obj.Tabsection2 == "true")
{
foreach (DataRow dr in ds1.Tables[0].Rows)
{
// PatientPrescriptionNewMedicineID = ds.Tables[0].Rows[0]["PatientPrescriptionNewMedicineID"].ToString(),
obj.PatientPrescriptionNewID1 = ds1.Tables[0].Rows[0]["PatientPrescriptionNewID"].ToString();
obj.Date1 = Convert.ToDateTime(ds1.Tables[0].Rows[0]["DATE"]).ToString("yyyy-MM-dd");
obj.OPDIPDID1 = Convert.ToInt32(ds1.Tables[0].Rows[0]["OPDIPDID"].ToString());
obj.ChiefComplaint1 = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["ChiefComplaint"].ToString());
obj.Allergies1 = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["Allergies"].ToString());
obj.Height1 = ds1.Tables[0].Rows[0]["Height"].ToString();
obj.Weight1 = ds1.Tables[0].Rows[0]["Weight"].ToString();
obj.Pulse1 = ds1.Tables[0].Rows[0]["Pulse"].ToString();
obj.BP1 = ds1.Tables[0].Rows[0]["BP"].ToString();
obj.BMI1 = ds1.Tables[0].Rows[0]["BMI"].ToString();
obj.Temp1 = ds1.Tables[0].Rows[0]["Temp"].ToString();
obj.ClinicalFinding1 = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["ClinicalFindings"].ToString());
obj.ProvitionalDiagnosis1 = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["ProvisionalDiagonosis"].ToString());
obj.Investigation1 = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["Investigations"].ToString());
obj.TreatmentAdvice1 = WebUtility.HtmlDecode(ds1.Tables[0].Rows[0]["TreatmentAdvice"].ToString());
obj.Remark1 = ds1.Tables[0].Rows[0]["Remark"].ToString();
if (ds1.Tables[0].Rows[0]["FollowUpDate"].ToString() == "")
{
obj.FollowUpDate1 = ds1.Tables[0].Rows[0]["FollowUpDate"].ToString();
}
else
{
obj.FollowUpDate1 = Convert.ToDateTime(ds1.Tables[0].Rows[0]["FollowUpDate"]).ToString("yyyy-MM-dd");
}
if (ds1.Tables[0].Rows[0]["FollowUpDate"].ToString() == "")
{
obj.FollowUpDate1 = ds1.Tables[0].Rows[0]["FollowUpTime"].ToString();
}
else
{
obj.FollowUpTime1 = Convert.ToDateTime(ds1.Tables[0].Rows[0]["FollowUpTime"]).ToString("hh:mm:ss");
}
SearchlistOld.Add(obj);
}
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
searchlistMed.Add(new PatientPrescriptionNew
{
// PatientPrescriptionNewMedicineID = ds.Tables[0].Rows[0]["PatientPrescriptionNewMedicineID"].ToString(),
MedicineLibraryID1 = dr1["MedicineLibraryID"].ToString(),
Medicines1 = dr1["Medicines"].ToString(),
Frequency1 = dr1["Frequency"].ToString(),
Days1 = dr1["Days"].ToString(),
Instruction1 = dr1["Instruction"].ToString(),
Strength1 = dr1["Strength"].ToString()
});
}
}
return(Json(new { SearchlistOld = SearchlistOld, searchlistMed = searchlistMed, searchlistICD = searchlistICD }, JsonRequestBehavior.AllowGet));
}
