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); }