/// <summary> /// Gets the lab. /// </summary> /// <param name="prefixText">The prefix text.</param> /// <param name="count">The count.</param> /// <returns></returns> public static List <string> GetLab(string prefixText, int count) { List <Labs> items = new List <Labs>(); ILabFunctions LabTestsMgrDate; List <string> ar = new List <string>(); string custItem = string.Empty; LabTestsMgrDate = (ILabFunctions)ObjectFactory.CreateInstance("BusinessProcess.Laboratory.BLabFunctions, BusinessProcess.Laboratory"); string query = "Exec dbo.Laboratory_GetLabTestID @LabName='" + prefixText + "', @IncludeLabDepartment=8"; //filling data from database // dtLabResult = LabTestsMgrDate.ReturnLabQuery(sqlQuery); DataTable dt = new DataTable(); dt = LabTestsMgrDate.ReturnLabQuery(query); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { try { custItem = AutoCompleteExtender.CreateAutoCompleteItem(row["LabName"].ToString(), String.Format("{0};{1};{2}", row["LabTestID"], row["LabName"], row["labdepartmentname"])); ar.Add(custItem); } catch { } } } return(ar); //return items; }
private void GetLaborderdate() { int PatientID = Convert.ToInt32(Session["PatientId"]); int LocationID = Convert.ToInt32(Session["AppLocationId"]); ILabFunctions LabTestsMgrDate; if (ViewState["LabID"] != null) { LabTestsMgrDate = (ILabFunctions)ObjectFactory.CreateInstance("BusinessProcess.Laboratory.BLabFunctions, BusinessProcess.Laboratory"); DTtestDate = (DataTable)LabTestsMgrDate.GetLaborderdate(PatientID, LocationID, Convert.ToInt32(ViewState["LabID"])); ViewState["TestDate"] = DTtestDate; } }
/// <summary> /// Gets the stat result. /// </summary> /// <param name="statement">The statement.</param> /// <returns></returns> public int GetStatResult(string statement) { int result = 0; ILabFunctions LabTestsMgrDate; LabTestsMgrDate = (ILabFunctions)ObjectFactory.CreateInstance("BusinessProcess.Laboratory.BLabFunctions, BusinessProcess.Laboratory"); DataTable dtLabResult = LabTestsMgrDate.ReturnLabQuery(statement); if (dtLabResult != null && dtLabResult.Rows.Count > 0) { result = Convert.ToInt32(dtLabResult.Rows[0][0]); } return(result); }
public static List <Labs> GetLab(string prefixText, int count) { List <Labs> items = new List <Labs>(); ILabFunctions LabTestsMgrDate; LabTestsMgrDate = (ILabFunctions)ObjectFactory.CreateInstance("BusinessProcess.Laboratory.BLabFunctions, BusinessProcess.Laboratory"); string sqlQuery; //creating Sql Query //sqlQuery = "select l.LabTestID,l.LabName,l.LabDepartmentID,d.labdepartmentname from mst_labtest l"; //sqlQuery += " inner join mst_labdepartment d on l.LabDepartmentID=d.LabDepartmentID where labname like '%" + prefixText + "%' group by l.labtestid,l.labname,l.LabDepartmentID,d.labdepartmentname"; sqlQuery = "select a.SubTestId[LabTestID], a.SubTestName[LabName], b.LabDepartmentID, c.labdepartmentname"; sqlQuery += " from lnk_testparameter a inner join mst_labtest b on a.TestId=b.LabTestId"; sqlQuery += " inner join mst_labdepartment c on c.LabDepartmentId=b.LabDepartmentID"; sqlQuery += " where a.SubTestName like '%" + prefixText + "%' group by a.SubTestId, a.SubTestName, b.LabDepartmentID, c.labdepartmentname"; //filling data from database dtLabResult = (DataTable)LabTestsMgrDate.ReturnLabQuery(sqlQuery); if (dtLabResult.Rows.Count > 0) { foreach (DataRow row in dtLabResult.Rows) { try { Labs item = new Labs(); item.SubTestId = (int)row["LabTestID"]; item.SubTestName = (string)row["LabName"]; item.LabDepartmentId = (int)row["LabDepartmentID"]; item.LabDepartmentName = (string)row["labdepartmentname"]; items.Add(item); } catch (Exception ex) { } } } return(items); }
public static List <string> Searchlab(string prefixText, int count) { List <string> Labdetail = new List <string>(); ILabFunctions LabTestsMgrDate; LabTestsMgrDate = (ILabFunctions)ObjectFactory.CreateInstance("BusinessProcess.Laboratory.BLabFunctions, BusinessProcess.Laboratory"); //List<string> lstDrugsDetail = GetLab(prefixText, count); DataTable dt = new DataTable(); dt = LabTestsMgrDate.FindLabByName(prefixText, 8, null); List <string> ar = new List <string>(); string custItem = string.Empty; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { try { custItem = AutoCompleteExtender.CreateAutoCompleteItem( row["LabName"].ToString(), String.Format("{0};{1};{2};{3}", row["LabTestID"], row["LabName"], row["labdepartmentname"], row["DataType"] ) ); ar.Add(custItem); } catch { } } } return(ar); }
/// <summary> /// Gets the lab. /// </summary> /// <param name="prefixText">The prefix text.</param> /// <param name="count">The count.</param> /// <returns></returns> public static List <Labs> GetLab(string prefixText, int count) { List <Labs> items = new List <Labs>(); ILabFunctions LabTestsMgrDate; LabTestsMgrDate = (ILabFunctions)ObjectFactory.CreateInstance("BusinessProcess.Laboratory.BLabFunctions, BusinessProcess.Laboratory"); //string query; //query = "Exec dbo.Laboratory_GetLabTestID @LabName='" + prefixText + "' ,@ExcludeLabDepartment=8"; // DataTable dt = LabTestsMgrDate.ReturnLabQuery(query); DataTable dt = new DataTable(); dt = LabTestsMgrDate.FindLabByName(prefixText, null, 8); HttpContext.Current.Session["DTLABRESULT"] = dt; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { try { Labs item = new Labs(); item.SubTestId = (int)row["LabTestID"]; item.SubTestName = (string)row["LabName"]; item.LabDepartmentId = (int)row["LabDepartmentID"]; item.LabDepartmentName = (string)row["labdepartmentname"]; item.DataType = row["DataType"].ToString(); items.Add(item); } catch { } } } return(items); }
void PopulateData() { DataSet dsData = new DataSet("Statitics"); //Home.ID, // Home.Name, // Home.FeatureID, // dtl.Id QueryID, // dtl.HomePageId, // dtl.IndicatorName, // dtl.Query string xsd = @"<?xml version=""1.0"" standalone=""yes""?> <xs:schema id=""Statitics"" xmlns="""" xmlns:xs=""http://www.w3.org/2001/XMLSchema"" xmlns:msdata=""urn:schemas-microsoft-com:xml-msdata""> <xs:element name=""Statitics"" msdata:IsDataSet=""true"" msdata:UseCurrentLocale=""true""> <xs:complexType> <xs:choice minOccurs=""0"" maxOccurs=""unbounded""> <xs:element name=""master"" maxOccurs=""1"" minOccurs=""0""> <xs:complexType> <xs:sequence> <xs:element name=""ID"" type=""xs:int"" /> <xs:element name=""Name"" type=""xs:string"" /> <xs:element name=""FeatureID"" type=""xs:int""/> </xs:sequence> </xs:complexType> </xs:element> <xs:element name=""detail"" maxOccurs=""1"" minOccurs=""0""> <xs:complexType> <xs:sequence> <xs:element name=""FeatureID"" type=""xs:int""/> <xs:element name=""QueryID"" type=""xs:int""/> <xs:element name=""ID"" type=""xs:int""/> <xs:element name=""IndicatorName"" type=""xs:string"" /> <xs:element name=""Query"" type=""xs:string"" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema>"; using (System.IO.TextReader txR = new System.IO.StringReader(xsd)) { //.txR.TextReader txR = new StringReader(this.DataXSDSchema); dsData.ReadXmlSchema(txR); txR.Close(); } ILabFunctions LabTestsMgrDate; string statement = @"Select ID, Name, FeatureId From dbo.Mst_HomePage Where DeleteFlag = 0; "; LabTestsMgrDate = (ILabFunctions)ObjectFactory.CreateInstance("BusinessProcess.Laboratory.BLabFunctions, BusinessProcess.Laboratory"); DataTable master = LabTestsMgrDate.ReturnLabQuery(statement); master.TableName = "master"; string statement2 = @"Select Home.FeatureID,dtl.Id QueryID, Convert(int,dtl.HomePageId) HomePageId, dtl.IndicatorName, dtl.Query From dbo.mst_Feature Feature Inner Join dbo.Mst_HomePage Home On Home.FeatureID = Feature.FeatureID Inner Join dbo.Dtl_HomePage dtl On Home.Id = dtl.HomePageId Where dtl.DeleteFlag = 0 Order By dtl.Seq;" ; LabTestsMgrDate = (ILabFunctions)ObjectFactory.CreateInstance("BusinessProcess.Laboratory.BLabFunctions, BusinessProcess.Laboratory"); DataTable details = LabTestsMgrDate.ReturnLabQuery(statement2); details.TableName = "detail"; dsData.Tables.Clear(); dsData.Tables.Add(master.Copy()); dsData.Tables.Add(details.Copy()); DataRelation relation = new DataRelation("myRelation", dsData.Tables["master"].Columns["ID"], dsData.Tables["detail"].Columns["HomePageId"], true); // relation.Nested = true; dsData.Relations.Add(relation); rptServiceArea.DataSource = dsData.Tables["master"]; rptServiceArea.DataBind(); }