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