public List <LabOrder> GetLabOrders(int locationId, int?patientPk)
{
ClsObject obj = new ClsObject();
ClsUtility.Init_Hashtable();
if (patientPk.HasValue)
{
ClsUtility.AddExtendedParameters("@PatientPk", SqlDbType.Int, patientPk.Value);
}
ClsUtility.AddExtendedParameters("@LocationId", SqlDbType.Int, locationId);
DateTime? nullDate = null;
DataTable dt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "Laboratory_GetLabOrder", ClsUtility.ObjectEnum.DataTable);
ClsUtility.Init_Hashtable();
obj = null;
IPatientService service = new PatientCore.PatientCoreServices();
// (IPatientService)ObjectFactory.CreateInstance("BusinessProcess.SCM.BBilling, BusinessProcess.SCM");
var result = (from rowView in dt.AsEnumerable()
select new LabOrder()
{
Id = Convert.ToInt32(rowView["LabOrderId"]),
ClinicalNotes = rowView["ClinicalNotes"].ToString(),
CreateDate = Convert.ToDateTime(rowView["CreateDate"]),
DeleteFlag = Convert.ToBoolean(rowView["DeleteFlag"]),
LocationId = Convert.ToInt32(rowView["LocationId"]),
ModuleId = Convert.ToInt32(rowView["ModuleId"]),
OrderDate = Convert.ToDateTime(rowView["OrderDate"]),
OrderedBy = Convert.ToInt32(rowView["OrderedBy"]),
OrderNumber = rowView["OrderNumber"].ToString(),
PreClinicDate = rowView["PreClinicLabDate"] == DBNull.Value ? nullDate : Convert.ToDateTime(rowView["PreClinicLabDate"]),
Client = service.GetPatient(Convert.ToInt32(rowView["PatientPk"])),
PatientPk = Convert.ToInt32(rowView["PatientPk"]),
UserId = Convert.ToInt32(rowView["UserId"]),
VisitId = Convert.ToInt32(rowView["VisitId"]),
OrderStatus = rowView["OrderStatus"].ToString(),
OrderedTest = this.GetOrderedTests(Convert.ToInt32(rowView["LabOrderId"]))
}).ToList <LabOrder>();
return(result);
}
public LabOrder GetLabOrder(int locationId, int LabOrderId)
{
ClsObject obj = new ClsObject();
ClsUtility.Init_Hashtable();
PatientCore.PatientCoreServices pt = new PatientCore.PatientCoreServices();
ClsUtility.AddExtendedParameters("@LabOrderId", SqlDbType.Int, LabOrderId);
DataTable dt = (DataTable)obj.ReturnObject(ClsUtility.theParams, "Laboratory_GetLabOrder", ClsUtility.ObjectEnum.DataTable);
DateTime?nullDate = null;
LabOrder order = null;
if (null != dt && dt.Rows.Count > 0)
{
DataRow rowView = dt.Rows[0];
order = new LabOrder()
{
Id = Convert.ToInt32(rowView["LabOrderId"]),
ClinicalNotes = rowView["ClinicalNotes"].ToString(),
CreateDate = Convert.ToDateTime(rowView["CreateDate"]),
DeleteFlag = Convert.ToBoolean(rowView["DeleteFlag"]),
LocationId = Convert.ToInt32(rowView["LocationId"]),
ModuleId = Convert.ToInt32(rowView["ModuleId"]),
OrderDate = Convert.ToDateTime(rowView["OrderDate"]),
OrderedBy = Convert.ToInt32(rowView["OrderedBy"]),
OrderNumber = rowView["OrderNumber"].ToString(),
PreClinicDate = rowView["PreClinicLabDate"] == DBNull.Value ? nullDate : Convert.ToDateTime(rowView["PreClinicLabDate"]),
PatientPk = Convert.ToInt32(rowView["PatientPk"]),
Client = pt.GetPatient(Convert.ToInt32(rowView["PatientPk"])),
UserId = Convert.ToInt32(rowView["UserId"]),
VisitId = Convert.ToInt32(rowView["VisitId"]),
OrderStatus = rowView["OrderStatus"].ToString(),
OrderedTest = this.GetOrderedTests(Convert.ToInt32(rowView["LabOrderId"]))
};
}
return(order);
}
