public static ContactDS GetContacts() { // ContactDS contacts = null; try { // contacts = new ContactDS(); if (_Mediator.OnLine) { DataSet ds = _Mediator.FillDataset(USP_CONTACTS, TBL_CONTACTS, null); if (ds.Tables[TBL_CONTACTS].Rows.Count > 0) { DataSet _ds = new DataSet(); _ds.Merge(ds.Tables[TBL_CONTACTS].Select("", "FirstName ASC")); contacts.Merge(_ds); for (int i = 0; i < contacts.IssueContactTable.Rows.Count; i++) { contacts.IssueContactTable[i].FullName = contacts.IssueContactTable[i].FirstName + " " + contacts.IssueContactTable[i].LastName; } } } } catch (Exception ex) { throw new ApplicationException("Unexpected error while creating new contact.", ex); } return(contacts); }
public Contact GetContact(int contactID) { //Get issue types Contact contact = null; try { ContactDS contacts = GetContacts(); ContactDS.ContactTableRow c = (ContactDS.ContactTableRow)contacts.ContactTable.Select("ID=" + contactID)[0]; contact = new Contact(c); } catch (Exception ex) { throw new ApplicationException("Unexpected error while reading contact.", ex); } return(contact); }
public ContactDS GetContacts(int companyID, string regionNumber, string districtNumber, string agentNumber, string storeNumber) { ContactDS contacts = null; try { // contacts = new ContactDS(); DataSet ds = fillDataset(USP_CONTACTS_BYLOC, TBL_CONTACTS, new object[] { companyID, regionNumber, districtNumber, agentNumber, storeNumber }); if (ds.Tables[TBL_CONTACTS].Rows.Count > 0) { contacts.Merge(ds); for (int i = 0; i < contacts.ContactTable.Rows.Count; i++) { contacts.ContactTable[i].FullName = contacts.ContactTable[i].FirstName + " " + contacts.ContactTable[i].LastName; } } } catch (Exception ex) { throw new ApplicationException("Unexpected error while creating new contact.", ex); } return(contacts); }
public DataSet ToDataSet() { //Return a dataset containing values for this object ContactDS ds = null; try { ds = new ContactDS(); ContactDS.IssueContactTableRow contact = ds.IssueContactTable.NewIssueContactTableRow(); contact.ID = this._id; contact.FirstName = this._firstname; contact.LastName = this._lastname; contact.FullName = this._fullname; contact.Phone = this._phone; contact.Mobile = this._mobile; contact.Fax = this._fax; contact.Email = this._email; ds.IssueContactTable.AddIssueContactTableRow(contact); } catch (Exception) { } return(ds); }