} // 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"]]));
}
