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