public object GetValue(string fieldName)
{
IEnumerator <DatabaseRowObject.DatabaseColumnObject> iter = databaseRowObj.GetEnumerator();
DatabaseRowObject.DatabaseColumnObject col = null;
while (iter.MoveNext())
{
if (iter.Current.DataBaseTableColumnName == fieldName)
{
break;
}
}
col = iter.Current;
object retValue = null;
object columnValue = null;
switch (col.DataType)
{
case MyDataTypes.INTEGER:
columnValue = Utilities.ParseInt32(sqlReader, col.Column);
break;
case MyDataTypes.STRING:
columnValue = Utilities.ParseStr(sqlReader, col.Column);
break;
case MyDataTypes.DATETIME:
columnValue = Utilities.ParseDateTime(sqlReader, col.Column);
break;
case MyDataTypes.GUID:
columnValue = Utilities.ParseGuid(sqlReader, col.Column);
break;
}
if (col.Encrypted)
{
retValue = dataEncryptionAlgorithm.DecryptObj(columnValue);
if (col.DisplayType == MyDisplayTypes.DATE)
{
DateTime dt = DateTime.Parse(retValue.ToString());
retValue = (object)String.Format("{0}/{1}/{2}", dt.Month.ToString(), dt.Day.ToString(), dt.Year.ToString());;
}
return(retValue);
}
else
{
return(columnValue);
}
}
public void AddColumn(string databaseColumnName, string dataGridColumnName, MyDataTypes dataType, bool orderByColumn, int gridWidth, bool includeInGrid = true)
{
DatabaseRowObject.DatabaseColumnObject column = new DatabaseRowObject.DatabaseColumnObject();
column.DataBaseTableColumnName = databaseColumnName;
column.DataGridColumnName = dataGridColumnName;
column.OrderByColumn = orderByColumn;
column.DataType = dataType;
column.IncludeInDataGrid = includeInGrid;
columnDictionary.Add(columnDictionary.Count + 1, column);
gridIndexByColumnName.Add(databaseColumnName, gridIndexByColumnName.Count);
}
public void LoadGrid()
{
DatabaseRowObject.DatabaseColumnObject databaseColumnObj = null;
dataGridObject = new DataGridObject(WebConfigurationManager.ConnectionStrings["MyTherapistDatabaseConnectionString"].ConnectionString, "PatientInformation");
databaseRowObject = new DatabaseRowObject();
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "Id";
databaseColumnObj.DataGridColumnName = "Id";
databaseColumnObj.DataType = MyDataTypes.INTEGER;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = true;
databaseColumnObj.Encrypted = false;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "FirstName";
databaseColumnObj.DataGridColumnName = "First Name";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = false;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "LastName";
databaseColumnObj.DataGridColumnName = "Last Name";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = false;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "BirthDate";
databaseColumnObj.DataGridColumnName = "BirthDate";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.DisplayType = MyDisplayTypes.DATE;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = true;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "EmailAddress";
databaseColumnObj.DataGridColumnName = "Email Address";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = true;
databaseRowObject.AddColumn(databaseColumnObj);
databaseColumnObj = new DatabaseRowObject.DatabaseColumnObject();
databaseColumnObj.DataBaseTableColumnName = "TelephoneNumber";
databaseColumnObj.DataGridColumnName = "Telephone Number";
databaseColumnObj.DataType = MyDataTypes.STRING;
databaseColumnObj.IncludeInDataGrid = true;
databaseColumnObj.OrderByColumn = false;
databaseColumnObj.Encrypted = true;
databaseRowObject.AddColumn(databaseColumnObj);
dataGridObject.DatabaseRowObject = databaseRowObject;
dataGridObject.FillToCompletePage = true;
dataGridObject.PageNumber = 1;
dataGridObject.NumberRowsToDisplay = 15;
pager = new MyDataGridPager();
pager.AddColumn("Id", 15);
pager.AddColumn("First Name", 25);
pager.AddColumn("Last Name", 250);
pager.AddColumn("Email Address", 250);
pager.AddColumn("Telephone Number", 100);
if (txtBoxPatientFirstName.Text.Length > 0)
{
dataGridObject.AddWhereClauseArgument("FirstName", txtBoxPatientFirstName.Text);
}
if (txtBoxPatientLastName.Text.Length > 0)
{
dataGridObject.AddWhereClauseArgument("LastName", txtBoxPatientLastName.Text);
}
if (IsPostBack == false)
{
dataGridObject.PageNumber = 1;
Session["PatientList_PageNumber"] = "1";
}
else
{
dataGridObject.PageNumber = Int32.Parse(Session["PatientList_PageNumber"].ToString());
}
patientlistgridview.DataSource = dataGridObject.BuildTable();
patientlistgridview.RowDataBound += Patientlistgridview_RowDataBound;
patientlistgridview.SelectedIndexChanged += Patientlistgridview_SelectedIndexChanged;
patientlistgridview.DataBind();
if (dataGridObject.NumberOfCompletedPages == 0)
{
btnNextPAge.Enabled = false;
}
else
{
btnNextPAge.Enabled = true;
}
}