public void LoadContact(int ContactID)
{
DataSet ds = DBTask.ExecuteDataset(ConfigurationSettings.AppSettings[Web.Global.CfgKeyConnString], "ContactInfo_GetContact", ContactID);
DataRow row = ds.Tables[0].Rows[0];
_ContactID = Convert.ToInt32(row["ContactID"].ToString());
_Title = row["Title"].ToString();
_FirstName = row["FirstName"].ToString();
_MiddleName = row["MiddleName"].ToString();
_LastName = row["LastName"].ToString();
_JobTitle = row["JobTitle"].ToString();
_Company = row["Company"].ToString();
_Website = row["Website"].ToString();
_OfficePhone = row["OfficePhone"].ToString();
_HomePhone = row["HomePhone"].ToString();
_Mobile = row["Mobile"].ToString();
_Fax = row["Fax"].ToString();
_OEmail = row["OfficialEmail"].ToString();
_PEmail = row["PersonalEmail"].ToString();
_OAStreet = row["OAStreet"].ToString();
_OACity = row["OACity"].ToString();
_OAState = row["OAState"].ToString();
_OACountry = row["OACountry"].ToString();
_OAZipCode = row["OAZip"].ToString();
_PAStreet = row["PAStreet"].ToString();
_PACity = row["PACity"].ToString();
_PAState = row["PAState"].ToString();
_PACountry = row["PACountry"].ToString();
_PAZipCode = row["PAZip"].ToString();
}
public static AddressBookCollection GetEntries(string BLetter)
{
DataSet dsData = DBTask.ExecuteDataset(ConfigurationSettings.AppSettings[Web.Global.CfgKeyConnString]
, "ContactInfo_GetContactList", BLetter);
AddressBookCollection entryList = new AddressBookCollection();
foreach (DataRow row in dsData.Tables[0].Rows)
{
Address AB = new Address();
AB.ContactID = Convert.ToInt32(row["ContactID"]);
AB.FullName = row["FullName"].ToString();
AB.OfficialEmail = row["OfficialEmail"].ToString();
AB.PersonalEmail = row["PersonalEmail"].ToString();
AB.OfficePhone = row["OfficePhone"].ToString();
AB.HomePhone = row["HomePhone"].ToString();
entryList.Add(AB);
}
return(entryList);
}
