public ActionResult DgvClickGetPatientWiseResultForPatientSearch(int LabNo)
{
BL_Patient_Wise_Result_Entry BL_obj = new BL_Patient_Wise_Result_Entry();
DataSet ds = new DataSet();
List <Patient_Wise_Result_Entry> searclist = new List <Models.Laboratory.Patient_Wise_Result_Entry>();
ds = BL_obj.GetPatientWiseResultForPatientSearch(LabNo);
// test.Models.Master.MasterLaboratory.Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
// searclist.Add(obj);
foreach (DataRow dr in ds.Tables[1].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
obj.LabNo = ds.Tables[0].Rows[0]["LabNo"].ToString();
obj.RegNo = ds.Tables[0].Rows[0]["PatientRegNo"].ToString();
obj.Patientname = ds.Tables[0].Rows[0]["PatientName"].ToString();
obj.ConsDr = 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 IUPatientLabAuthorization(string AuthorzerID, string AuthorzeName, string stauts, string Remark, string LabNo, string TestID, string TestName, string Mode)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
List <Patient_Wise_Result_Entry> listAdd = new List <Patient_Wise_Result_Entry>();
BL_Patient_Wise_Result_Entry OBJ_bl = new BL_Patient_Wise_Result_Entry();
if (Mode == "Save")
{
Mode = "Add";
}
else
{
Mode = "Edit";
}
bool chk = OBJ_bl.IUPatientLabAuthorization(AuthorzerID, AuthorzeName, stauts, Remark, LabNo, TestID, TestName, Mode);
if (chk)
{
obj.Message = "You are Save Authoriser .";
}
else
{
obj.Message = "You are not Save Authoriser .";
}
listAdd.Add(obj);
return(Json(listAdd, JsonRequestBehavior.AllowGet));
}
//public ActionResult GetParamater(string footer)
// {
// return Json(searclist, JsonRequestBehavior.AllowGet);
// }
public ActionResult GetParamaterHelpValue(string ParameterID)
{
BL_Patient_Wise_Result_Entry BL_obj = new BL_Patient_Wise_Result_Entry();
DataSet ds = new DataSet();
List <Patient_Wise_Result_Entry> searclist = new List <Models.Laboratory.Patient_Wise_Result_Entry>();
DataSet dsDetail = new DataSet();
dsDetail = BL_obj.GetParamaterHelpValue(Convert.ToInt32(ParameterID));
foreach (DataRow dr in dsDetail.Tables[0].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
// dr["Formula"] = "5";
obj.ParamiterID = dr["ParameterID1"].ToString();
obj.HelpValueID = dr["HelpValueID"].ToString();
obj.HelpValue = dr["HelpValue"].ToString();
searclist.Add(obj);
}
return(Json(searclist, JsonRequestBehavior.AllowGet));
}
public ActionResult RechkCompletebtn(int LabNo, string ParamiterID, string TestID2, string Formula, string newValue, string NLH1, string col)
{
Connect();
string Message = "";
if (newValue.ToString().Trim().Length > 0)
{
string[] NLH = NLH1.Split(',');
BL_Patient_Wise_Result_Entry BL_obj = new BL_Patient_Wise_Result_Entry();
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
Calculation(LabNo, ParamiterID, TestID2, Formula, newValue, NLH1);
if (TestID2 == "")
{
TestID2 = "0";
}
dsCompare = BL_obj.GetPatientWiseResultforParameterValue(Convert.ToInt32(LabNo), Convert.ToInt32(dsPatientEntry.Tables[0].Rows[0]["TestID"]));
if (dsPatientEntry.Tables.Count > 0)
{
int i = 0;
foreach (DataRow dr in dsPatientEntry.Tables[0].Rows)
{
if (dsCompare.Tables[0].Rows[i]["ResultValue"].ToString().Trim() != dr["ResultValue"].ToString().Trim())
{
dr["CreationID"] = CreationID;
}
else
{
dr["CreationID"] = dsCompare.Tables[0].Rows[i]["CreationID"].ToString().Trim();
}
if (NLH[i] == "Blank")
{
dr["NLH"] = "";
}
else
{
dr["NLH"] = NLH[i];
}
dr["CompleteBy"] = CreationID;
dr["Mode"] = "Edit";
i++;
}
if (BL_obj.SaveRechk(dsPatientEntry, col))
{
Message = "Record Saved successfully";
//PatientWiseResultEntry();
}
}
}
return(Json(Message, JsonRequestBehavior.AllowGet));
}
// Aurthorise
public ActionResult ValidateUser(string users, string password, string LabNo, string TestID)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
List <Patient_Wise_Result_Entry> listAdd = new List <Patient_Wise_Result_Entry>();
int AuthorzerID = 0;
BL_Patient_Wise_Result_Entry OBJ_bl = new BL_Patient_Wise_Result_Entry();
DataSet dsUser = OBJ_bl.ValidateUser(users, password);
if (dsUser.Tables[0].Rows[0]["UserValid"].ToString() == "3")
{
obj.Message = "Invalid Username. Please try again";
}
else if (dsUser.Tables[0].Rows[0]["UserValid"].ToString() == "0")
{
obj.Message = "Invalid Password. Please try again";
}
else
{
obj.AuthorzerID = dsUser.Tables[0].Rows[0]["UserID"].ToString();
DataSet dsAuthorzer = OBJ_bl.GetPatientLabForAuthorizer(Convert.ToInt32(obj.AuthorzerID), Convert.ToInt32(LabNo), Convert.ToInt32(TestID));
if (dsAuthorzer.Tables[0].Rows.Count > 0)
{
obj.AuthorzeName = dsAuthorzer.Tables[0].Rows[0]["AuthoriserName"].ToString();
if (dsAuthorzer.Tables[1].Rows.Count > 0)
{
obj.cmbStatus = dsAuthorzer.Tables[1].Rows[0]["Status"].ToString();
obj.txtRemark = dsAuthorzer.Tables[1].Rows[0]["Remark"].ToString();
obj.btnsaveEdit = "Edit";
}
else
{
obj.btnsaveEdit = "Save";
}
}
else
{
obj.Message = "You are not Authoriser.";
}
}
listAdd.Add(obj);
return(Json(listAdd, JsonRequestBehavior.AllowGet));
}
public ActionResult PatientBind(DateTime FromDate, DateTime Todate)
{
BL_Patient_Wise_Result_Entry BL_obj = new BL_Patient_Wise_Result_Entry();
DataSet ds = new DataSet();
List <Patient_Wise_Result_Entry> searclist = new List <Models.Laboratory.Patient_Wise_Result_Entry>();
ds = BL_obj.SearchPatientLabResultEntryByNameID("%", FromDate, Todate);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
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 GetPatientLabWithParameterRecheck(int LabNo, int TestID)
{
List <Patient_Wise_Result_Entry> searclist = new List <Models.Laboratory.Patient_Wise_Result_Entry>();
if (TestID > 0)
{
BL_Patient_Wise_Result_Entry BL_obj = new BL_Patient_Wise_Result_Entry();
DataSet ds = new DataSet();
DataSet dsPatientEntry = new DataSet();
DataSet dsCompare = new DataSet();
dsPatientEntry = BL_obj.GetPatientLabWithParameterRecheck(LabNo, TestID);
dsCompare = BL_obj.GetPatientWiseResultforParameterValue(Convert.ToInt32(LabNo), Convert.ToInt32(TestID));
foreach (DataRow dr in dsPatientEntry.Tables[0].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
// dr["Formula"] = "5";
//obj.Formula = dr["Formula"].ToString();
obj.LabNo = dr["LabNo"].ToString();
// obj.FullName = dr["FullName"].ToString();
obj.NLH = dr["NLH"].ToString();
// obj.ParamiterName = dr["ParameterName"].ToString();
obj.Low = dr["ConvLow"].ToString();
obj.Hiegh = dr["ConvHigh"].ToString();
obj.ParamiterID = dr["ParameterID"].ToString();
obj.status = dr["Status"].ToString();
obj.TestID = dr["TestID"].ToString();
obj.ResultValue = dr["ResultValue"].ToString();
obj.Value1 = dr["Value1"].ToString();
obj.Value2 = dr["Value2"].ToString();
obj.Value3 = dr["Value3"].ToString();
searclist.Add(obj);
}
}
return(Json(searclist, JsonRequestBehavior.AllowGet));
}
public ActionResult Calculation(int LabNo, string ParamiterID, string TestID2, string Formula, string newValue, string NLH1)
{
MathParser();
string FullFormula;
try
{
BL_Patient_Wise_Result_Entry BL_obj = new BL_Patient_Wise_Result_Entry();
string[] ParamiteID1 = ParamiterID.Split(',');
string[] TestID1 = TestID2.Split(',');
string[] Formula1 = Formula.Split(',');
string[] newValue1 = newValue.Split(',');
// string[] footersplit = Footer.Split(',');
// string[] NLH = NLH1.Split(',');
dsPatientEntry = BL_obj.GetPatientWiseResultforParameterValue(LabNo, Convert.ToInt32(TestID1[0]));
var a = dsPatientEntry.Tables[0].Rows.Count;
int row = 0;
foreach (DataRow dr in dsPatientEntry.Tables[0].Rows)
{
if (ParamiteID1[row] != "")
{
dr["ParameterID"] = ParamiteID1[row];
dr["TestID"] = TestID1[0];
if (Formula1[row].ToString() == "Blank")
{
dr["Formula"] = "";
}
else
{
dr["Formula"] = Formula1[row];
}
if (newValue1[row] == "Blank")
{
dr["ResultValue"] = "";
}
else
{
dr["ResultValue"] = newValue1[row];
}
//if (footersplit[row] == "Blank")
//{
// dr["Footer"] = "";
//}
//else
//{
// dr["Footer"] = footersplit[row];
//}
row++;
}
}
foreach (DataRow dr in dsPatientEntry.Tables[0].Rows)
{
FullFormula = dr["Formula"].ToString().Trim();
int ParameterID = Convert.ToInt32(dr["ParameterID"].ToString().Trim());
int TestID = Convert.ToInt32(dr["TestID"].ToString().Trim());
if (FullFormula.Trim().Length > 0)
{
// dr["ResultValue"] = Math.Round(Convert.ToDecimal(Calculate(FormulaFullName(ParameterID, FullFormula, TestID)).ToString()), 2);
dr["ResultValue"] = Math.Round(Convert.ToDecimal(Calculate(FormulaFullName(ParameterID, FullFormula, TestID).ToString())), 2);
// dr["ResultValue"] = Math.Round(Convert.ToDecimal(Evaluate(FormulaFullName(ParameterID, FullFormula, TestID)).ToString()), 2);
}
}
}
catch (Exception ex)
{
//ExceptionManager.Publish(ex);
// ShowMessage(ex.Message, MessageTypes.ErrorMessage);
}
foreach (DataRow dr in dsPatientEntry.Tables[0].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
// dr["Formula"] = "5";
obj.Formula = dr["Formula"].ToString();
obj.LabNo = dr["LabNo"].ToString();
obj.FullName = dr["FullName"].ToString();
obj.NLH = dr["NLH"].ToString();
obj.ParamiterName = dr["ParameterName"].ToString();
obj.Low = dr["ConvLow"].ToString();
obj.Hiegh = dr["ConvHigh"].ToString();
obj.ParamiterID = dr["ParameterID"].ToString();
obj.status = dr["Status"].ToString();
obj.TestID = dr["TestID"].ToString();
obj.ResultValue = dr["ResultValue"].ToString();
searclist.Add(obj);
}
return(Json(searclist, JsonRequestBehavior.AllowGet));
}
public ActionResult GetPatientWiseResultforParameterValue(int LabNo, int TestID)
{
List <Patient_Wise_Result_Entry> searclist = new List <Models.Laboratory.Patient_Wise_Result_Entry>();
if (TestID > 0)
{
BL_Patient_Wise_Result_Entry BL_obj = new BL_Patient_Wise_Result_Entry();
DataSet ds = new DataSet();
DataSet dsPatientEntry = new DataSet();
DataSet dsCompare = new DataSet();
dsPatientEntry = BL_obj.GetPatientWiseResultforParameterValue(LabNo, TestID);
dsCompare = BL_obj.GetPatientWiseResultforParameterValue(Convert.ToInt32(LabNo), Convert.ToInt32(TestID));
if (dsPatientEntry.Tables[0].Rows.Count > 0)
{
if (dsPatientEntry.Tables[1].Rows[0]["TestStatus"].ToString().Trim() == "COMPLETED")
{
Patient_Wise_Result_Entry objc = new Patient_Wise_Result_Entry();
// ucPatientWiseResultEntry1.gbDetail.Enabled = true;
//ucPatientWiseResultEntry1.dgvDetails.DataSource = dsPatientEntry.Tables[2];
// ucPatientWiseResultEntry1.btnComplete.BackColor = Color.Green;
objc.Color = "Green";
searclist.Add(objc);
foreach (DataRow dr in dsPatientEntry.Tables[2].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
// dr["Formula"] = "5";
obj.UserID = dr["UserID"].ToString();
obj.AuthoriserName = dr["AuthoriserName"].ToString();
obj.status = dr["Status"].ToString();
obj.Remark = dr["Remark"].ToString();
obj.LabNo = dr["LabNo"].ToString();
obj.TestID = dr["TestID"].ToString();
obj.TestName1 = dr["TestName"].ToString();
searclist.Add(obj);
}
foreach (DataRow dr in dsPatientEntry.Tables[0].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
// dr["Formula"] = "5";
obj.Formula = dr["Formula"].ToString();
obj.LabNo = dr["LabNo"].ToString();
obj.FullName = dr["FullName"].ToString();
obj.NLH = dr["NLH"].ToString();
obj.ParamiterName = dr["ParameterName"].ToString();
obj.Low = dr["ConvLow"].ToString();
obj.Hiegh = dr["ConvHigh"].ToString();
obj.ParamiterID = dr["ParameterID"].ToString();
obj.status = dr["Status"].ToString();
obj.TestID = dr["TestID"].ToString();
obj.ResultValue = dr["ResultValue"].ToString();
obj.Value1 = dr["Value1"].ToString();
obj.Value2 = dr["Value2"].ToString();
obj.Value3 = dr["Value3"].ToString();
obj.footer = dr["Footer"].ToString();
// obj.fo
searclist.Add(obj);
}
}
else
{
// ucPatientWiseResultEntry1.gbDetail.Enabled = false;
// ucPatientWiseResultEntry1.btnComplete.BackColor = Color.Coral;
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
obj.Color = "Coral";
searclist.Add(obj);
}
// ucPatientWiseResultEntry1.dgvResultEntry.DataSource = dsPatientEntry.Tables[0];
//ucPatientWiseResultEntry1.dgvDetails.DataSource = dsPatientEntry.Tables[2];
if (dsPatientEntry.Tables[1].Rows[0]["TestStatus"].ToString().Trim() != "COMPLETED")
{
foreach (DataRow dr in dsPatientEntry.Tables[2].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
// dr["Formula"] = "5";
obj.UserID = dr["UserID"].ToString();
obj.AuthoriserName = dr["AuthoriserName"].ToString();
obj.status = dr["Status"].ToString();
obj.Remark = dr["Remark"].ToString();
obj.LabNo = dr["LabNo"].ToString();
obj.TestID = dr["TestID"].ToString();
obj.TestName1 = dr["TestName"].ToString();
// obj.Color = "Green";
searclist.Add(obj);
}
foreach (DataRow dr in dsPatientEntry.Tables[0].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
// dr["Formula"] = "5";
obj.Formula = dr["Formula"].ToString();
obj.LabNo = dr["LabNo"].ToString();
obj.FullName = dr["FullName"].ToString();
obj.NLH = dr["NLH"].ToString();
obj.ParamiterName = dr["ParameterName"].ToString();
obj.Low = dr["ConvLow"].ToString();
obj.Hiegh = dr["ConvHigh"].ToString();
obj.ParamiterID = dr["ParameterID"].ToString();
obj.status = dr["Status"].ToString();
obj.TestID = dr["TestID"].ToString();
obj.ResultValue = dr["ResultValue"].ToString();
obj.Value1 = dr["Value1"].ToString();
obj.Value2 = dr["Value2"].ToString();
obj.Value3 = dr["Value3"].ToString();
obj.footer = dr["FooterParameter"].ToString();
// obj.fo
searclist.Add(obj);
}
}
}
}
else
{
BL_Patient_Wise_Result_Entry BL_obj = new BL_Patient_Wise_Result_Entry();
DataSet ds = new DataSet();
DataSet dsCompare = new DataSet();
DataSet dsPatientEntry = new DataSet();
dsPatientEntry = BL_obj.GetPatientWiseResultforParameterValue(LabNo, TestID);
dsCompare = BL_obj.GetPatientWiseResultforParameterValue(Convert.ToInt32(LabNo), Convert.ToInt32(TestID));
foreach (DataRow dr in dsPatientEntry.Tables[0].Rows)
{
Patient_Wise_Result_Entry obj = new Patient_Wise_Result_Entry();
// dr["Formula"] = "5";
obj.Formula = dr["Formula"].ToString();
obj.LabNo = dr["LabNo"].ToString();
obj.FullName = dr["FullName"].ToString();
obj.NLH = dr["NLH"].ToString();
obj.ParamiterName = dr["ParameterName"].ToString();
obj.Low = dr["ConvLow"].ToString();
obj.Hiegh = dr["ConvHigh"].ToString();
obj.ParamiterID = dr["ParameterID"].ToString();
obj.status = dr["Status"].ToString();
obj.TestID = dr["TestID"].ToString();
obj.ResultValue = "";
searclist.Add(obj);
}
}
return(Json(searclist, JsonRequestBehavior.AllowGet));
}