public static ContactDS.ContactDSDataTable SearchContact(string firstName, string lastName, string email, string phone)
{
ContactDSTableAdapter ta = new ContactDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.SearchContact(firstName, lastName, email, phone));
}
public static Int32 DeleteContact(Int32 contactId)
{
ContactDSTableAdapter ta = new ContactDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.Delete(contactId));
}
public static ContactDS.ContactDSDataTable GetUserContactId(Int32 userId)
{
ContactDSTableAdapter ta = new ContactDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetUserContactId(userId));
}
public static ContactDS.ContactDSDataTable GetContactByGuid(Guid contactGuid)
{
ContactDSTableAdapter ta = new ContactDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetContactByGuid(contactGuid));
}
public static ContactDS.ContactDSDataTable SelectContact(Int32 contactId)
{
ContactDSTableAdapter ta = new ContactDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetData(contactId));
}
public static ContactDS.ContactDSDataTable GetContactsByPhoneNumber(string phoneNumber)
{
ContactDSTableAdapter ta = new ContactDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetContactsByPhoneNumber(phoneNumber));
}
public static ContactDS.ContactDSDataTable GetAllContacts()
{
ContactDSTableAdapter ta = new ContactDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetAllContacts());
}
public static Int32 UpdateContact(Int32 contactId, Int32 userId, string firstName, string lastName, string email, string phone, string memo)
{
ContactDSTableAdapter ta = new ContactDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
System.Nullable <Int32> user_id = Helper.ResolveEmptyInt(userId);
if (memo == "")
{
memo = null;
}
return(ta.Update(contactId, user_id, firstName, lastName, email, phone, memo));
}
public static Int32 InsertContact(Int32 userId, string first_name, string last_name, string email, string phone, string memo)
{
ContactDSTableAdapter ta = new ContactDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
System.Nullable <Int32> user_id = Helper.ResolveEmptyInt(userId);
if (memo == "")
{
memo = null;
}
int id = Convert.ToInt32(ta.InsertContact(user_id, first_name, last_name, email, phone, memo));
return(id);
}
