GetHashCode()
{
return(NameFirst.GetHashCode()
^ NameLast.GetHashCode()
^ Dob.GetHashCode()
^ IsMarried.GetHashCode());
}
}//public String Feedback
/// <summary>ButtonSubmit_Click().</summary>
public void ButtonSubmit_Click
(
Object sender,
EventArgs e
)
{
StringBuilder sb = null;
OleDbCommand oleDbCommand = null;
OleDbConnection oleDbConnection = null;
OleDbDataReader oleDbDataReader = null;
string sbFormat = null;
string medicalRecordPatientNo = null;
string accountNo = null;
string altMRN = null;
string nameLast = null;
string nameFirst = null;
bool databaseSelect = false;
try
{
medicalRecordPatientNo = MedicalRecordPatientNo.Trim();
accountNo = AccountNo.Trim();
altMRN = AltMRN.Trim();
nameLast = NameLast.Trim();
nameFirst = NameFirst.Trim();
if
(
medicalRecordPatientNo == string.Empty || medicalRecordPatientNo == null ||
accountNo == string.Empty || accountNo == null
)
{
Feedback = "Required columns Medical record patient No and Account No";
return;
}
sb = new StringBuilder();
sb.AppendFormat
(
SelectRecord,
"CoreData",
medicalRecordPatientNo,
accountNo
);
oleDbConnection = new OleDbConnection
(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
serverMapPath + @"\" + AccessDatabaseFileName +
";Persist Security Info=False"
);
oleDbConnection.Open();
oleDbCommand = new OleDbCommand( sb.ToString(), oleDbConnection);
oleDbDataReader = oleDbCommand.ExecuteReader();
databaseSelect = false;
while(oleDbDataReader.Read())
{
medicalRecordPatientNo = oleDbDataReader.GetString(0);
accountNo = oleDbDataReader.GetString(1);
/*
UtilityDebug.Write(string.Format("medicalRecordPatientNo: {0}", medicalRecordPatientNo));
UtilityDebug.Write(string.Format("account: {0}", accountNo));
*/
databaseSelect = true;
}
//close the reader
oleDbDataReader.Close();
sb = new StringBuilder();
if ( databaseSelect == false )
{
sbFormat = CoreDataRecordInsert;
}
else
{
sbFormat = CoreDataRecordUpdate;
}
sb.AppendFormat
(
sbFormat,
medicalRecordPatientNo,
accountNo,
altMRN,
nameLast,
nameFirst
);
//UtilityDebug.Write(string.Format("sb: {0}", sb.ToString()));
oleDbCommand = new OleDbCommand( sb.ToString(), oleDbConnection);
oleDbCommand = new OleDbCommand();
oleDbCommand.Connection = oleDbConnection;
oleDbCommand.CommandText = sb.ToString();
oleDbCommand.ExecuteNonQuery();
}
catch ( Exception exception )
{
UtilityDebug.Write(string.Format("Exception: {0}", exception.Message));
}//catch
finally
{
if (oleDbConnection.State == System.Data.ConnectionState.Open)
{
oleDbConnection.Close();
}//if (oleDbConnection.State == System.Data.ConnectionState.Open)
}//finally
}//public void ButtonSubmit_Click
