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