} // Done... Tested... private void LoadData(int intPatientID, bool Complete) { DataTable tblResults; if (AppMode) { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]); } else { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]); } string strProc; strProc = "wsGetPatientByID"; InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection(); parameters.Add(new SqlParameter("@PatientID", intPatientID)); tblResults = clsUtility.ExecuteSP_DataTable(strProc, parameters); if (Complete == true) { LoadControls(tblResults); } else { LoadControlsIncomplete(tblResults); } } // Obsolete...
} // Done...Tested #endregion #endregion #region Datagrid Events #region initGrid(DataGrid dgGrid, string strSQL, string pKey) private void initGrid(DataGrid dgGrid, string strSQL, string pKey) { if (AppMode) { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]); } else { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]); } SqlDataReader rData = clsUtility.GetDataReader(strSQL); // set the grid's visible property to false to initialize the control dgGrid.Visible = false; int i; if (rData.HasRows) { dgGrid.Visible = true; for (i = 0; i < rData.FieldCount; i++) { BoundColumn objBC = new BoundColumn(); objBC.DataField = rData.GetName(i).ToString(); objBC.HeaderText = rData.GetName(i).ToString(); // use this function to make the primary key of the table hidden if (rData.GetName(i).ToString() == pKey) { objBC.Visible = false; } dgGrid.Columns.Add(objBC); } dgGrid.DataSource = rData; dgGrid.DataBind(); rData.Close(); } else { if (pKey == "MedicationID") { MedHdr.Visible = false; } if (pKey == "VitalSignID") { VitalHdr.Visible = false; } } // if in view mode then remove the Action column if (Session["mode"] != null && Session["mode"].ToString() == "view") { dgGrid.Columns[0].Visible = false;; } // cleanup rData.Close(); }
public DataUtility() { if (Convert.ToBoolean(Convert.ToInt16(ConfigurationManager.AppSettings["appmode"]))) { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]); } else { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]); } }
private string getConnectionString() { InfiniEdge.Encryption enc = new InfiniEdge.Encryption(); if (AppMode) { return(enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"])); } else { return(enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"])); } }
public LogVisit() { // initialize the utility class with the encrypted connection string switch (Environment.MachineName) { case "InfiniEdge-Corp": case "HTX5Y21": case "GRQG441": case "917GY61": case "INFINIEDGE-DEV": clsUtility = new InfiniEdge.SQL(enc.SimpleCrypt(Config["infiniConn"])); break; default: clsUtility = new InfiniEdge.SQL(enc.SimpleCrypt(Config["remoteConn"])); break; } }
// need a method that will get the names of the textboxes, radio buttons, and drop down lists private void getFields(Control c, string strSQL) { if (AppMode) { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]); } else { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]); } SqlDataReader rEncounter = clsUtility.GetDataReader(strSQL); while (rEncounter.Read()) { for (int i = 0; i < rEncounter.FieldCount; i++) { Control ctrl = getControl(c, rEncounter.GetName(i).ToString()); if (ctrl != null) { switch (ctrl.GetType().ToString()) { case "System.Web.UI.WebControls.TextBox": TextBox txtCtrl = new TextBox(); txtCtrl.Text = rEncounter.GetString(i); break; case "System.Web.UI.WebControls.DropDownList": DropDownList cboCtrl = new DropDownList(); cboCtrl.SelectedIndex = rEncounter.GetInt16(i); break; case "System.Web.UI.WebControls.RadioButtonList": RadioButtonList rdoCtrl = new RadioButtonList(); rdoCtrl.SelectedValue = rEncounter.GetString(i); break; } } } } rEncounter.Close(); }
//Determines AppMode #region getConnectionString() public string getConnectionString() { InfiniEdge.Encryption enc = new InfiniEdge.Encryption(); return(enc.SimpleCrypt(ConfigurationManager.AppSettings[ConfigurationManager.AppSettings["DBConnectionToUse"]])); }