/// <summary>
/// Fills the {0} from a OleIDataReader.
/// </summary>
public static void FillFromReader(DojoSeminar dojoSeminar, IDataReader r, int idOffset, int dataOffset)
{
dojoSeminar.iD = r.GetInt32(idOffset);
dojoSeminar.isSynced = true;
dojoSeminar.isPlaceHolder = false;
dojoSeminar.name = r.GetString(0 + dataOffset);
dojoSeminar.startDate = r.GetDateTime(1 + dataOffset);
dojoSeminar.endDate = r.GetDateTime(2 + dataOffset);
dojoSeminar.description = r.GetString(3 + dataOffset);
dojoSeminar.isLocal = r.GetBoolean(4 + dataOffset);
if (!r.IsDBNull(5 + dataOffset) && r.GetInt32(5 + dataOffset) > 0)
{
dojoSeminar.location = GreyFoxContact.NewPlaceHolder("kitTessen_Locations", r.GetInt32(5 + dataOffset));
}
dojoSeminar.classUnitFee = r.GetDecimal(6 + dataOffset);
dojoSeminar.classUnitType = (DojoSeminarClassUnitType)r.GetByte(7 + dataOffset);
dojoSeminar.baseRegistrationFee = r.GetDecimal(8 + dataOffset);
dojoSeminar.registrationEnabled = r.GetBoolean(9 + dataOffset);
dojoSeminar.registrationStart = r.GetDateTime(10 + dataOffset);
dojoSeminar.fullEarlyRegistrationFee = r.GetDecimal(11 + dataOffset);
dojoSeminar.earlyEndDate = r.GetDateTime(12 + dataOffset);
dojoSeminar.fullRegistrationFee = r.GetDecimal(13 + dataOffset);
dojoSeminar.lateStartDate = r.GetDateTime(14 + dataOffset);
dojoSeminar.fullLateRegistrationFee = r.GetDecimal(15 + dataOffset);
dojoSeminar.registrationEnd = r.GetDateTime(16 + dataOffset);
dojoSeminar.details = r.GetString(17 + dataOffset);
dojoSeminar.detailsOverrideUrl = r.GetString(18 + dataOffset);
dojoSeminar.pdfUrl = r.GetString(19 + dataOffset);
if (!r.IsDBNull(20 + dataOffset) && r.GetInt32(20 + dataOffset) > 0)
{
dojoSeminar.item = RHItem.NewPlaceHolder(r.GetInt32(20 + dataOffset));
}
}
/// <summary>
/// Fills the {0} from a OleIDataReader.
/// </summary>
public static void FillFromReader(DojoOrganization dojoOrganization, IDataReader r, int idOffset, int dataOffset)
{
dojoOrganization.iD = r.GetInt32(idOffset);
dojoOrganization.isSynced = true;
dojoOrganization.isPlaceHolder = false;
dojoOrganization.name = r.GetString(0 + dataOffset);
dojoOrganization.description = r.GetString(1 + dataOffset);
if (!r.IsDBNull(2 + dataOffset) && r.GetInt32(2 + dataOffset) > 0)
{
dojoOrganization.location = GreyFoxContact.NewPlaceHolder("kitTessen_Locations", r.GetInt32(2 + dataOffset));
}
if (!r.IsDBNull(3 + dataOffset) && r.GetInt32(3 + dataOffset) > 0)
{
dojoOrganization.administrativeContact = GreyFoxContact.NewPlaceHolder("sysGlobal_Contacts", r.GetInt32(3 + dataOffset));
}
dojoOrganization.webServiceUrl = r.GetString(4 + dataOffset);
dojoOrganization.refreshTime = TimeSpan.FromTicks((long)r.GetDouble(5 + dataOffset));
dojoOrganization.isPrimary = r.GetBoolean(6 + dataOffset);
if (!r.IsDBNull(7 + dataOffset) && r.GetInt32(7 + dataOffset) > 0)
{
dojoOrganization.defaultMemberType = DojoMemberType.NewPlaceHolder(r.GetInt32(7 + dataOffset));
}
dojoOrganization.promotionFlagEnabled = r.GetBoolean(8 + dataOffset);
}
public static GreyFoxContact ParseFromReader(string tableName, IDataReader r, int idOffset, int dataOffset)
{
GreyFoxContact greyFoxContact = new GreyFoxContact(tableName);
FillFromReader(greyFoxContact, tableName, r, idOffset, dataOffset);
return(greyFoxContact);
}
//--- Begin Custom Code ---
public bool FullNameExists(string fullName)
{
bool exists;
Database database;
DbCommand dbCommand;
GreyFoxContact c;
c = new GreyFoxContact();
c.ParseName(fullName);
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand("SELECT COUNT(*) " +
"FROM " + tableName +
"WHERE FirstName=@FirstName " +
" AND MiddleName=@MiddleName "+
" AND LastName=@LastName "+
" AND Suffix=@Suffix;");
addParameter(database, dbCommand, "FirstName", DbType.String, c.firstName);
addParameter(database, dbCommand, "MiddleName", DbType.String, c.middleName);
addParameter(database, dbCommand, "LastName", DbType.String, c.lastName);
addParameter(database, dbCommand, "Suffix", DbType.String, c.Suffix);
exists = ((int)database.ExecuteScalar(dbCommand)) > 0;
c = null;
return(exists);
}
private static void fillParameters(Database database, DbCommand dbCommand, GreyFoxContact greyFoxContact)
{
#region Name
addParameter(database, dbCommand, "@DisplayName", DbType.String, greyFoxContact.displayName);
addParameter(database, dbCommand, "@Prefix", DbType.String, greyFoxContact.prefix);
addParameter(database, dbCommand, "@FirstName", DbType.String, greyFoxContact.firstName);
addParameter(database, dbCommand, "@MiddleName", DbType.String, greyFoxContact.middleName);
addParameter(database, dbCommand, "@LastName", DbType.String, greyFoxContact.lastName);
addParameter(database, dbCommand, "@SuffixCommaEnabled", DbType.Boolean, greyFoxContact.suffixCommaEnabled);
addParameter(database, dbCommand, "@Suffix", DbType.String, greyFoxContact.suffix);
addParameter(database, dbCommand, "@Title", DbType.String, greyFoxContact.title);
addParameter(database, dbCommand, "@ValidationMemo", DbType.String, greyFoxContact.validationMemo);
addParameter(database, dbCommand, "@ValidationFlags", DbType.Byte, (Byte)greyFoxContact.validationFlags);
#endregion
#region Address
addParameter(database, dbCommand, "@Address1", DbType.String, greyFoxContact.address1);
addParameter(database, dbCommand, "@Address2", DbType.String, greyFoxContact.address2);
addParameter(database, dbCommand, "@City", DbType.String, greyFoxContact.city);
addParameter(database, dbCommand, "@StateProvince", DbType.String, greyFoxContact.stateProvince);
addParameter(database, dbCommand, "@Country", DbType.String, greyFoxContact.country);
addParameter(database, dbCommand, "@PostalCode", DbType.String, greyFoxContact.postalCode);
#endregion
#region Voice
addParameter(database, dbCommand, "@HomePhone", DbType.String, greyFoxContact.homePhone);
addParameter(database, dbCommand, "@WorkPhone", DbType.String, greyFoxContact.workPhone);
addParameter(database, dbCommand, "@Fax", DbType.String, greyFoxContact.fax);
addParameter(database, dbCommand, "@Pager", DbType.String, greyFoxContact.pager);
addParameter(database, dbCommand, "@MobilePhone", DbType.String, greyFoxContact.mobilePhone);
#endregion
#region Internet
addParameter(database, dbCommand, "@Email1", DbType.String, greyFoxContact.email1);
addParameter(database, dbCommand, "@Email2", DbType.String, greyFoxContact.email2);
addParameter(database, dbCommand, "@Url", DbType.String, greyFoxContact.url);
#endregion
#region Business
addParameter(database, dbCommand, "@BusinessName", DbType.String, greyFoxContact.businessName);
#endregion
#region Default
addParameter(database, dbCommand, "@MemoText", DbType.String, greyFoxContact.memoText);
addParameter(database, dbCommand, "@BirthDate", DbType.Date, greyFoxContact.birthDate);
addParameter(database, dbCommand, "@ContactMethod", DbType.Byte, (Byte)greyFoxContact.contactMethod);
#endregion
}
public static void FillClassLocations(DojoOrganizationCollection dojoOrganizationCollection)
{
StringBuilder s;
Database database;
DbCommand dbCommand;
IDataReader r;
if (dojoOrganizationCollection.Count > 0)
{
s = new StringBuilder("SELECT DojoOrganizationID, GreyFoxContactID FROM kitTessen_OrganizationsChildren_ClassLocations ORDER BY DojoOrganizationID; ");
// Clone and sort collection by ID first to fill children in one pass
DojoOrganizationCollection clonedCollection = dojoOrganizationCollection.Clone();
clonedCollection.Sort();
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand(s.ToString());
r = database.ExecuteReader(dbCommand);
bool more = r.Read();
foreach (DojoOrganization dojoOrganization in clonedCollection)
{
GreyFoxContactCollection classLocations;
if (dojoOrganization.classLocations != null)
{
classLocations = dojoOrganization.classLocations;
classLocations.Clear();
}
else
{
classLocations = new GreyFoxContactCollection();
dojoOrganization.classLocations = classLocations;
}
while (more)
{
if (r.GetInt32(0) < dojoOrganization.iD)
{
more = r.Read();
}
else if (r.GetInt32(0) == dojoOrganization.iD)
{
classLocations.Add(GreyFoxContact.NewPlaceHolder("kitTessen_Locations", r.GetInt32(1)));
more = r.Read();
}
else
{
break;
}
}
// No need to continue if there are no more records
if (!more)
{
break;
}
}
}
}
public static GreyFoxContact Location(string name)
{
GreyFoxContact location = new GreyFoxContact(DojoOrganizationManager.LocationTable);
location.BusinessName = name;
location.BirthDate = new DateTime(1980, 1, 1);
return(location);
}
protected void btOk_Click(object sender, EventArgs e)
{
GreyFoxContact greyFoxContact = new GreyFoxContact(greyFoxContactID);
greyFoxContact.Delete();
greyFoxContactID = 0;
OnDeleted(EventArgs.Empty);
}
public void Remove(GreyFoxContact value)
{
OnCollectionChanged(EventArgs.Empty);
int index = IndexOf(value);
if (index == -1)
{
throw(new Exception("GreyFoxContact not found in collection."));
}
RemoveAt(index);
}
private static DojoOrganization Organization(
string name,
string description,
GreyFoxContact location)
{
DojoOrganization organization = new DojoOrganization();
organization.Name = name;
organization.Description = description;
organization.Location = location;
return(organization);
}
internal static int _update(GreyFoxContact greyFoxContact)
{
Database database;
DbCommand dbCommand;
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand("UPDATE " + greyFoxContact.tableName + " SET DisplayName=@DisplayName," +
"Prefix=@Prefix," +
"FirstName=@FirstName," +
"MiddleName=@MiddleName," +
"LastName=@LastName," +
"SuffixCommaEnabled=@SuffixCommaEnabled," +
"Suffix=@Suffix," +
"Title=@Title," +
"ValidationMemo=@ValidationMemo," +
"ValidationFlags=@ValidationFlags," +
"Address1=@Address1," +
"Address2=@Address2," +
"City=@City," +
"StateProvince=@StateProvince," +
"Country=@Country," +
"PostalCode=@PostalCode," +
"HomePhone=@HomePhone," +
"WorkPhone=@WorkPhone," +
"Fax=@Fax," +
"Pager=@Pager," +
"MobilePhone=@MobilePhone," +
"Email1=@Email1," +
"Email2=@Email2," +
"Url=@Url," +
"BusinessName=@BusinessName," +
"MemoText=@MemoText," +
"BirthDate=@BirthDate," +
"ContactMethod=@ContactMethod WHERE GreyFoxContactID=@GreyFoxContactID;");
fillParameters(database, dbCommand, greyFoxContact);
database.AddInParameter(dbCommand, "GreyFoxContactID", DbType.Int32, greyFoxContact.iD);
// Abandon remaining updates if no rows have been updated by returning false immediately.
if (database.ExecuteNonQuery(dbCommand) == 0)
{
return(-1);
}
// Store greyFoxContact in cache.
if (cacheEnabled)
{
cacheStore(greyFoxContact);
}
return(greyFoxContact.iD);
}
protected override void OnPreRender(EventArgs e)
{
if (greyFoxContactID != 0)
{
greyFoxContact = new GreyFoxContact(greyFoxContactID);
text = "Delete - " + greyFoxContact.ToString();
}
else
{
text = "Delete ";
}
EnsureWindowScripts();
}
/// <summary>
/// An object to cache the parameterized query for full name queries.
/// </summary>
public GreyFoxContact FindByFullName(string fullName, bool placeHolderOnly)
{
StringBuilder query;
Database database;
DbCommand dbCommand;
IDataReader r;
GreyFoxContact c;
// create a new contact to parse a name into.
c = new GreyFoxContact(tableName);
c.ParseName(fullName);
query = new StringBuilder();
query.Append("SELECT ");
if (placeHolderOnly)
{
query.Append(InnerJoinFields[0]);
}
else
{
query.Append(string.Join(",", InnerJoinFields));
}
query.Append(" FROM ");
query.Append(tableName);
query.Append(" WHERE FirstName=@FirstName AND " +
"MiddleName=@MiddleName AND " +
"LastName=@LastName AND " +
"Suffix=@Suffix;");
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand(query.ToString());
addParameter(database, dbCommand, "FirstName", DbType.String, c.firstName);
addParameter(database, dbCommand, "MiddleName", DbType.String, c.middleName);
addParameter(database, dbCommand, "LastName", DbType.String, c.lastName);
addParameter(database, dbCommand, "Suffix", DbType.String, c.Suffix);
r = database.ExecuteReader(dbCommand);
if (r.Read())
{
if (placeHolderOnly)
{
c = GreyFoxContact.NewPlaceHolder(tableName, r.GetInt32(0));
}
else
{
c = GreyFoxContactManager.ParseFromReader(tableName, r, 0, 1);
}
}
return(c);
}
public int IndexOf(GreyFoxContact value)
{
lock (this)
{
for (int x = 0; x < count; x++)
{
if (GreyFoxContactArray[x].Equals(value))
{
return(x);
}
}
return(-1);
}
}
internal static bool _fill(GreyFoxContact greyFoxContact)
{
// Clone item from cache.
if (cacheEnabled)
{
object cachedObject = cacheFind(greyFoxContact.tableName, greyFoxContact.iD);
if (cachedObject != null)
{
((GreyFoxContact)cachedObject).CopyTo(greyFoxContact, true);
return(greyFoxContact.isSynced);
}
}
StringBuilder query;
Database database;
DbCommand dbCommand;
query = new StringBuilder("SELECT ");
query.Append(string.Join(",", InnerJoinFields));
query.Append(" FROM ");
query.Append(greyFoxContact.tableName);
query.Append(" WHERE GreyFoxContactID=");
query.Append(greyFoxContact.iD);
query.Append(";");
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand(query.ToString());
IDataReader r = database.ExecuteReader(dbCommand);
if (!r.Read())
{
throw(new Exception(string.Format("Cannot find GreyFoxContactID '{0}'.",
greyFoxContact.iD)));
}
FillFromReader(greyFoxContact, greyFoxContact.tableName, r, 0, 1);
// Microsoft DAAB still needs to have the reader closed.
r.Close();
// Store greyFoxContact in cache.
if (cacheEnabled)
{
cacheStore(greyFoxContact);
}
return(true);
}
protected override void OnPreRender(EventArgs e)
{
if (loadFlag)
{
if (greyFoxContactID > 0)
{
obj = new GreyFoxContact(greyFoxContactTable, greyFoxContactID);
text = "Edit - " + obj.ToString();
}
else if (greyFoxContactID <= 0)
{
obj = new GreyFoxContact(greyFoxContactTable);
text = "Add ";
}
//
// Set Field Entries
//
tbDisplayName.Text = obj.DisplayName;
tbPrefix.Text = obj.Prefix;
tbFirstName.Text = obj.FirstName;
tbMiddleName.Text = obj.MiddleName;
tbLastName.Text = obj.LastName;
cbSuffixCommaEnabled.Checked = obj.SuffixCommaEnabled;
tbSuffix.Text = obj.Suffix;
tbTitle.Text = obj.Title;
tbValidationFlags.Text = obj.ValidationFlags.ToString();
tbValidationMemo.Text = obj.ValidationMemo;
tbAddress1.Text = obj.Address1;
tbAddress2.Text = obj.Address2;
tbCity.Text = obj.City;
tbStateProvince.Text = obj.StateProvince;
tbCountry.Text = obj.Country;
tbPostalCode.Text = obj.PostalCode;
tbHomePhone.Text = obj.HomePhone;
tbWorkPhone.Text = obj.WorkPhone;
tbFax.Text = obj.Fax;
tbPager.Text = obj.Pager;
tbMobilePhone.Text = obj.MobilePhone;
tbEmail1.Text = obj.Email1;
tbEmail2.Text = obj.Email2;
tbUrl.Text = obj.Url;
tbBusinessName.Text = obj.BusinessName;
tbMemoText.Text = obj.MemoText;
tbBirthDate.Text = obj.BirthDate.ToString();
}
}
public GreyFoxContact FindByBusinessName(string businessName, bool placeHolderOnly)
{
StringBuilder query;
Database database;
DbCommand dbCommand;
IDataReader r;
GreyFoxContact c;
query = new StringBuilder();
query.Append("SELECT ");
if (placeHolderOnly)
{
query.Append(InnerJoinFields[0]);
}
else
{
query.Append(string.Join(",", InnerJoinFields));
}
query.Append(" FROM ");
query.Append(tableName);
query.Append(" WHERE BusinessName=@BusinessName;");
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand(query.ToString());
addParameter(database, dbCommand, "BusinessName", DbType.String, businessName);
r = database.ExecuteReader(dbCommand);
if (r.Read())
{
if (placeHolderOnly)
{
c = GreyFoxContact.NewPlaceHolder(tableName, r.GetInt32(0));
}
else
{
c = GreyFoxContactManager.ParseFromReader(tableName, r, 0, 1);
}
}
else
{
c = new GreyFoxContact(tableName);
c.BusinessName = businessName;
}
return(c);
}
public int Add(GreyFoxContact value)
{
OnCollectionChanged(EventArgs.Empty);
lock (this)
{
count++;
// Resize the array if the count is greater than the length
// of the array.
if (count > GreyFoxContactArray.GetUpperBound(0) + 1)
{
GreyFoxContact[] tempGreyFoxContactArray = new GreyFoxContact[count * 2];
Array.Copy(GreyFoxContactArray, tempGreyFoxContactArray, count - 1);
GreyFoxContactArray = tempGreyFoxContactArray;
}
GreyFoxContactArray[count - 1] = value;
}
return(count - 1);
}
/// <summary>
/// Fills the {0} from a OleIDataReader.
/// </summary>
public static void FillFromReader(GreyFoxUser greyFoxUser, IDataReader r, int idOffset, int dataOffset)
{
greyFoxUser.iD = r.GetInt32(idOffset);
greyFoxUser.isSynced = true;
greyFoxUser.isPlaceHolder = false;
greyFoxUser.userName = r.GetString(0 + dataOffset);
if (!r.IsDBNull(1 + dataOffset))
{
greyFoxUser.isDisabled = r.GetBoolean(1 + dataOffset);
}
if (!r.IsDBNull(2 + dataOffset))
{
greyFoxUser.loginDate = r.GetDateTime(2 + dataOffset);
}
else
{
greyFoxUser.loginDate = DateTime.MinValue;
}
if (!r.IsDBNull(3 + dataOffset))
{
greyFoxUser.loginCount = r.GetInt32(3 + dataOffset);
}
if (!r.IsDBNull(4 + dataOffset))
{
greyFoxUser.loginPassword = r.GetString(4 + dataOffset);
}
else
{
greyFoxUser.loginPassword = null;
}
if (!r.IsDBNull(5 + dataOffset) && r.GetInt32(5 + dataOffset) > 0)
{
greyFoxUser.contact = GreyFoxContact.NewPlaceHolder("sysGlobal_Contacts", r.GetInt32(5 + dataOffset));
}
if (!r.IsDBNull(6 + dataOffset))
{
greyFoxUser.activationID = r.GetString(6 + dataOffset);
}
else
{
greyFoxUser.activationID = string.Empty;
}
}
protected void ok_Click(object sender, EventArgs e)
{
if (greyFoxContactID == 0)
{
editGreyFoxContact = new GreyFoxContact(GreyFoxContactTable);
}
else
{
editGreyFoxContact = new GreyFoxContact(GreyFoxContactTable, GreyFoxContactID);
}
editGreyFoxContact.Prefix = tbPrefix.Text;
editGreyFoxContact.FirstName = tbFirstName.Text;
editGreyFoxContact.MiddleName = tbMiddleName.Text;
editGreyFoxContact.LastName = tbLastName.Text;
editGreyFoxContact.Suffix = tbSuffix.Text;
editGreyFoxContact.SuffixCommaEnabled = bool.Parse(tbSuffixCommaEnabled.Text);
editGreyFoxContact.BusinessName = tbBusinessName.Text;
editGreyFoxContact.Title = tbTitle.Text;
editGreyFoxContact.Address1 = tbAddress1.Text;
editGreyFoxContact.Address2 = tbAddress2.Text;
editGreyFoxContact.City = tbCity.Text;
editGreyFoxContact.StateProvince = tbStateProvince.Text;
editGreyFoxContact.PostalCode = tbPostalCode.Text;
editGreyFoxContact.Country = tbCountry.Text;
editGreyFoxContact.HomePhone = tbHomePhone.Text;
editGreyFoxContact.WorkPhone = tbWorkPhone.Text;
editGreyFoxContact.MobilePhone = tbMobilePhone.Text;
editGreyFoxContact.Pager = tbPager.Text;
editGreyFoxContact.Fax = tbFax.Text;
editGreyFoxContact.Email1 = tbEmail1.Text;
editGreyFoxContact.Email2 = tbEmail2.Text;
editGreyFoxContact.Url = tbUrl.Text;
editGreyFoxContact.MemoText = tbMemoText.Text;
editGreyFoxContact.BirthDate = DateTime.Parse(tbBirthDate.Text);
editGreyFoxContact.ContactMethod =
(GreyFoxContactMethod)byte.Parse(tbContactMethod.Text);
greyFoxContactID = editGreyFoxContact.Save();
OnUpdated(EventArgs.Empty);
}
//
// You can use the following additional attributes as you write your tests:
//
// Use ClassInitialize to run code before running the first test in the class
// [ClassInitialize()]
// public static void MyClassInitialize(TestContext testContext) { }
//
// Use ClassCleanup to run code after all tests in a class have run
// [ClassCleanup()]
// public static void MyClassCleanup() { }
//
// Use TestInitialize to run code before running each test
// [TestInitialize()]
// public void MyTestInitialize() { }
//
// Use TestCleanup to run code after each test has run
// [TestCleanup()]
// public void MyTestCleanup() { }
//
#endregion
private void parseTest(string name,
string prefix, string first, string middle, string last, string suffix)
{
GreyFoxContact contact;
bool pass;
contact = new GreyFoxContact();
contact.ParseName(name);
pass = contact.Prefix == prefix &&
contact.FirstName == first &&
contact.MiddleName == middle &&
contact.LastName == last &&
contact.Suffix == suffix;
if (!pass)
{
throw new Exception("Failed name parse.");
}
}
public PeopleTestData()
{
contactA = new GreyFoxContact("TestContacts");
contactA.ParseName("Alexander E. Smith");
contactA.DisplayName = "Alexander E. Smith";
contactA.Address1 = "5555 Somewhere St.";
contactA.City = "Anytown";
contactA.StateProvince = "VA";
contactA.PostalCode = "55555";
contactA.Country = "USA";
contactA.HomePhone = "(555)555-5555";
contactA.WorkPhone = "(555)555-5555";
contactA.BirthDate = new DateTime(1954, 3, 20);
contactA.ContactMethod = GreyFoxContactMethod.WorkPhone;
contactB = new GreyFoxContact("TestContacts");
contactB.ParseName("Frank Corndog");
contactB.DisplayName = "Frank Corndog";
contactB.Address1 = "5555 Somewhere St.";
contactB.City = "Anytown";
contactB.StateProvince = "VA";
contactB.PostalCode = "55555";
contactB.Country = "USA";
contactB.HomePhone = "(555)555-5555";
contactB.WorkPhone = "(555)555-5555";
contactB.BirthDate = new DateTime(1978, 6, 14);
contactB.ContactMethod = GreyFoxContactMethod.Email;
contactC = new GreyFoxContact("TestContacts");
contactC.ParseName("Professor Martin E. Shorty III");
contactC.DisplayName = "Professor Martin E. Shorty III";
contactC.Address1 = "5555 Somewhere St.";
contactC.City = "Anytown";
contactC.StateProvince = "VA";
contactC.PostalCode = "55555";
contactC.Country = "USA";
contactC.HomePhone = "(555)555-5555";
contactC.WorkPhone = "(555)555-5555";
contactC.ContactMethod = GreyFoxContactMethod.Email;
contactC.BirthDate = new DateTime(1952, 12, 10);
}
public static void FillClassLocations(DojoOrganization dojoOrganization)
{
StringBuilder s;
Database database;
DbCommand dbCommand;
IDataReader r;
s = new StringBuilder("SELECT GreyFoxContactID FROM kitTessen_OrganizationsChildren_ClassLocations ");
s.Append("WHERE DojoOrganizationID=");
s.Append(dojoOrganization.iD);
s.Append(";");
database = DatabaseFactory.CreateDatabase();
dbCommand = database.GetSqlStringCommand(s.ToString());
r = database.ExecuteReader(dbCommand);
GreyFoxContactCollection classLocations;
if (dojoOrganization.classLocations != null)
{
classLocations = dojoOrganization.classLocations;
classLocations.Clear();
}
else
{
classLocations = new GreyFoxContactCollection();
dojoOrganization.classLocations = classLocations;
}
while (r.Read())
{
classLocations.Add(GreyFoxContact.NewPlaceHolder("kitTessen_Locations", r.GetInt32(0)));
}
dojoOrganization.ClassLocations = classLocations;
// Store DojoOrganization in cache.
if (cacheEnabled)
{
cacheStore(dojoOrganization);
}
}
public void Insert(int index, GreyFoxContact value)
{
OnCollectionChanged(EventArgs.Empty);
lock (this)
{
count++;
// Resize the array if the count is greater than the length
// of the array.
if (count > GreyFoxContactArray.GetUpperBound(0) + 1)
{
GreyFoxContact[] tempGreyFoxContactArray = new GreyFoxContact[count * 2];
Array.Copy(GreyFoxContactArray, tempGreyFoxContactArray, count - 1);
GreyFoxContactArray = tempGreyFoxContactArray;
}
for (int x = index + 1; x == count - 2; x++)
{
GreyFoxContactArray[x] = GreyFoxContactArray[x - 1];
}
GreyFoxContactArray[index] = value;
}
}
public ContactTest()
{
try
{
Amns.GreyFox.Data.MsJetUtility.CreateDB("Test.mdb");
}
catch {}
try
{
GreyFoxContactManager manager = new GreyFoxContactManager("TestContacts");
manager.CreateTable();
}
catch { }
// For load testing please make sure "Run unit tests in application domain" is set to
// true in the Run Settings!
contactA = PeopleTestData.GetInstance().ContactA;
contactB = PeopleTestData.GetInstance().ContactB;
contactC = PeopleTestData.GetInstance().ContactC;
}
protected override void OnPreRender(EventArgs e)
{
if (greyFoxContactID != 0)
{
editGreyFoxContact = new GreyFoxContact(GreyFoxContactTable, GreyFoxContactID);
tbPrefix.Text = editGreyFoxContact.Prefix.ToString();
tbFirstName.Text = editGreyFoxContact.FirstName.ToString();
tbMiddleName.Text = editGreyFoxContact.MiddleName.ToString();
tbLastName.Text = editGreyFoxContact.LastName.ToString();
tbSuffix.Text = editGreyFoxContact.Suffix.ToString();
tbSuffixCommaEnabled.Text = editGreyFoxContact.SuffixCommaEnabled.ToString();
tbBusinessName.Text = editGreyFoxContact.BusinessName.ToString();
tbTitle.Text = editGreyFoxContact.Title.ToString();
tbAddress1.Text = editGreyFoxContact.Address1.ToString();
tbAddress2.Text = editGreyFoxContact.Address2.ToString();
tbCity.Text = editGreyFoxContact.City.ToString();
tbStateProvince.Text = editGreyFoxContact.StateProvince.ToString();
tbPostalCode.Text = editGreyFoxContact.PostalCode.ToString();
tbCountry.Text = editGreyFoxContact.Country.ToString();
tbHomePhone.Text = editGreyFoxContact.HomePhone.ToString();
tbWorkPhone.Text = editGreyFoxContact.WorkPhone.ToString();
tbMobilePhone.Text = editGreyFoxContact.MobilePhone.ToString();
tbPager.Text = editGreyFoxContact.Pager.ToString();
tbFax.Text = editGreyFoxContact.Fax.ToString();
tbEmail1.Text = editGreyFoxContact.Email1.ToString();
tbEmail2.Text = editGreyFoxContact.Email2.ToString();
tbUrl.Text = editGreyFoxContact.Url.ToString();
tbMemoText.Text = editGreyFoxContact.MemoText.ToString();
tbBirthDate.Text = editGreyFoxContact.BirthDate.ToString();
tbContactMethod.Text = editGreyFoxContact.ContactMethod.ToString();
Text = "Edit GreyFoxContact - " + editGreyFoxContact.FullName;
}
else
{
Text = "Add GreyFoxContact";
}
}
public void SaveLoadContactA()
{
GreyFoxContact loadContact;
contactA.Save();
loadContact = new GreyFoxContact(contactA.TableName, contactA.ID);
if (contactA.FirstName != loadContact.FirstName ||
contactA.MiddleName != loadContact.MiddleName ||
contactA.LastName != loadContact.LastName ||
contactA.DisplayName != loadContact.DisplayName ||
contactA.Address1 != loadContact.Address1 ||
contactA.Address2 != loadContact.Address2 ||
contactA.City != loadContact.City ||
contactA.StateProvince != loadContact.StateProvince ||
contactA.Country != loadContact.Country ||
contactA.HomePhone != loadContact.HomePhone ||
contactA.WorkPhone != loadContact.WorkPhone ||
contactA.BirthDate != loadContact.BirthDate ||
contactA.ContactMethod != loadContact.ContactMethod)
{
throw new Exception("Contact saved incorrectly.");
}
}
protected void ok_Click(object sender, EventArgs e)
{
if (dojoSeminarRegistrationID == 0)
{
obj = new DojoSeminarRegistration();
}
else
{
obj = new DojoSeminarRegistration(dojoSeminarRegistrationID);
}
obj.Status = byte.Parse(tbStatus.Text);
obj.RegistrationDate = deRegistrationDate.Date;
obj.ClassUnits = int.Parse(tbClassUnits.Text);
obj.TotalFee = decimal.Parse(tbTotalFee.Text);
obj.PaymentDate = dePaymentDate.Date;
obj.PaymentReference = tbPaymentReference.Text;
obj.PaymentAmount = decimal.Parse(tbPaymentAmount.Text);
if (msContact.SelectedItem != null && msContact.SelectedItem.Value != "Null")
{
obj.Contact = GreyFoxContact.NewPlaceHolder("kitTessen_SeminarRegistrations_Contacts",
int.Parse(msContact.SelectedItem.Value));
}
else
{
obj.Contact = null;
}
if (msCustomer.SelectedItem != null && msCustomer.SelectedItem.Value != "Null")
{
obj.Customer = RHCustomer.NewPlaceHolder(
int.Parse(msCustomer.SelectedItem.Value));
}
else
{
obj.Customer = null;
}
if (msInvoiceLine.SelectedItem != null && msInvoiceLine.SelectedItem.Value != "Null")
{
obj.InvoiceLine = RHInvoiceLine.NewPlaceHolder(
int.Parse(msInvoiceLine.SelectedItem.Value));
}
else
{
obj.InvoiceLine = null;
}
if (msSalesOrderLine.SelectedItem != null && msSalesOrderLine.SelectedItem.Value != "Null")
{
obj.SalesOrderLine = RHSalesOrderLine.NewPlaceHolder(
int.Parse(msSalesOrderLine.SelectedItem.Value));
}
else
{
obj.SalesOrderLine = null;
}
if (editOnAdd)
{
dojoSeminarRegistrationID = obj.Save();
}
else
{
obj.Save();
}
if (resetOnAdd)
{
tbStatus.Text = string.Empty;
deRegistrationDate.Date = DateTime.Now;
tbClassUnits.Text = string.Empty;
tbTotalFee.Text = string.Empty;
dePaymentDate.Date = DateTime.Now;
tbPaymentReference.Text = string.Empty;
tbPaymentAmount.Text = string.Empty;
msContact.SelectedIndex = 0;
msCustomer.SelectedIndex = 0;
msInvoiceLine.SelectedIndex = 0;
msSalesOrderLine.SelectedIndex = 0;
}
OnUpdated(EventArgs.Empty);
}
protected void ok_Click(object sender, EventArgs e)
{
if (dojoClassDefinitionID == 0)
{
obj = new DojoClassDefinition();
}
else
{
obj = new DojoClassDefinition(dojoClassDefinitionID);
}
obj.Name = tbName.Text;
obj.Description = tbDescription.Text;
obj.IsDisabled = cbIsDisabled.Checked;
obj.OccupancyAvg = int.Parse(tbOccupancyAvg.Text);
obj.OccupancyAvgDate = DateTime.Parse(tbOccupancyAvgDate.Text);
obj.RecurrenceType = byte.Parse(tbRecurrenceType.Text);
obj.RecurrenceCount = int.Parse(tbRecurrenceCount.Text);
obj.RecurrenceEnd = DateTime.Parse(tbRecurrenceEnd.Text);
obj.RecurrenceSpan = TimeSpan.Parse(tbRecurrenceSpan.Text);
obj.NextSigninStart = DateTime.Parse(tbNextSigninStart.Text);
obj.NextSigninEnd = DateTime.Parse(tbNextSigninEnd.Text);
obj.NextClassStart = DateTime.Parse(tbNextClassStart.Text);
obj.NextClassEnd = DateTime.Parse(tbNextClassEnd.Text);
if (msAccessControlGroup.SelectedItem != null && msAccessControlGroup.SelectedItem.Value != "Null")
{
obj.AccessControlGroup = DojoAccessControlGroup.NewPlaceHolder(
int.Parse(msAccessControlGroup.SelectedItem.Value));
}
else
{
obj.AccessControlGroup = null;
}
if (msInstructor.SelectedItem != null && msInstructor.SelectedItem.Value != "Null")
{
obj.Instructor = DojoMember.NewPlaceHolder(
int.Parse(msInstructor.SelectedItem.Value));
}
else
{
obj.Instructor = null;
}
if (msLocation.SelectedItem != null && msLocation.SelectedItem.Value != "Null")
{
obj.Location = GreyFoxContact.NewPlaceHolder("kitTessen_Locations",
int.Parse(msLocation.SelectedItem.Value));
}
else
{
obj.Location = null;
}
if (editOnAdd)
{
dojoClassDefinitionID = obj.Save();
}
else
{
obj.Save();
}
if (resetOnAdd)
{
tbName.Text = string.Empty;
tbDescription.Text = string.Empty;
cbIsDisabled.Checked = false;
tbOccupancyAvg.Text = string.Empty;
tbOccupancyAvgDate.Text = DateTime.Now.ToString();
tbRecurrenceType.Text = string.Empty;
tbRecurrenceCount.Text = string.Empty;
tbRecurrenceEnd.Text = DateTime.Now.ToString();
tbRecurrenceSpan.Text = string.Empty;
tbNextSigninStart.Text = DateTime.Now.ToString();
tbNextSigninEnd.Text = DateTime.Now.ToString();
tbNextClassStart.Text = DateTime.Now.ToString();
tbNextClassEnd.Text = DateTime.Now.ToString();
msAccessControlGroup.SelectedIndex = 0;
msInstructor.SelectedIndex = 0;
msLocation.SelectedIndex = 0;
}
OnUpdated(EventArgs.Empty);
}
protected void ok_Click(object sender, EventArgs e)
{
if (greyFoxContactID == 0)
{
obj = new GreyFoxContact(greyFoxContactTable);
}
else
{
obj = new GreyFoxContact(greyFoxContactTable, greyFoxContactID);
}
obj.DisplayName = tbDisplayName.Text;
obj.Prefix = tbPrefix.Text;
obj.FirstName = tbFirstName.Text;
obj.MiddleName = tbMiddleName.Text;
obj.LastName = tbLastName.Text;
obj.SuffixCommaEnabled = cbSuffixCommaEnabled.Checked;
obj.Suffix = tbSuffix.Text;
obj.Title = tbTitle.Text;
obj.ValidationFlags = byte.Parse(tbValidationFlags.Text);
obj.ValidationMemo = tbValidationMemo.Text;
obj.Address1 = tbAddress1.Text;
obj.Address2 = tbAddress2.Text;
obj.City = tbCity.Text;
obj.StateProvince = tbStateProvince.Text;
obj.Country = tbCountry.Text;
obj.PostalCode = tbPostalCode.Text;
obj.HomePhone = tbHomePhone.Text;
obj.WorkPhone = tbWorkPhone.Text;
obj.Fax = tbFax.Text;
obj.Pager = tbPager.Text;
obj.MobilePhone = tbMobilePhone.Text;
obj.Email1 = tbEmail1.Text;
obj.Email2 = tbEmail2.Text;
obj.Url = tbUrl.Text;
obj.BusinessName = tbBusinessName.Text;
obj.MemoText = tbMemoText.Text;
obj.BirthDate = DateTime.Parse(tbBirthDate.Text);
if (editOnAdd)
{
greyFoxContactID = obj.Save();
}
else
{
obj.Save();
}
if (resetOnAdd)
{
tbDisplayName.Text = string.Empty;
tbPrefix.Text = string.Empty;
tbFirstName.Text = string.Empty;
tbMiddleName.Text = string.Empty;
tbLastName.Text = string.Empty;
cbSuffixCommaEnabled.Checked = false;
tbSuffix.Text = string.Empty;
tbTitle.Text = string.Empty;
tbValidationFlags.Text = string.Empty;
tbValidationMemo.Text = string.Empty;
tbAddress1.Text = string.Empty;
tbAddress2.Text = string.Empty;
tbCity.Text = string.Empty;
tbStateProvince.Text = string.Empty;
tbCountry.Text = string.Empty;
tbPostalCode.Text = string.Empty;
tbHomePhone.Text = string.Empty;
tbWorkPhone.Text = string.Empty;
tbFax.Text = string.Empty;
tbPager.Text = string.Empty;
tbMobilePhone.Text = string.Empty;
tbEmail1.Text = string.Empty;
tbEmail2.Text = string.Empty;
tbUrl.Text = string.Empty;
tbBusinessName.Text = string.Empty;
tbMemoText.Text = string.Empty;
tbBirthDate.Text = DateTime.Now.ToString();
}
OnUpdated(EventArgs.Empty);
}
