/// <summary>
/// Get Specific Contact
/// </summary>
/// <param name="id"></param>
/// <param name="name"></param>
/// <param name="email"></param>
/// <param name="phoneNumber"></param>
public Contact GetContact(int id)
{
Contact contact = new Contact();
try
{
StoredProcedure sproc = new StoredProcedure();
MySqlDataReader rdr = null;
var list = new List<KeyValuePair<string, string>>();
//Add Parameters
list.Add(new KeyValuePair<string, string>("@contactID", id.ToString()));
MySqlCommand cmd = sproc.Command("NMS_UpdateContact", list, null, false);
// execute the command
rdr = cmd.ExecuteReader();
// iterate through results, printing each to console
while (rdr.Read())
{
contact.Id = Convert.ToInt32(rdr["id"]);
contact.Email = rdr["email"].ToString();
contact.Mobile = rdr["phone_number"].ToString();
contact.Name = rdr["name"].ToString();
}
}
catch (Exception ex)
{
log.Error("Error Editing Contacts : " + ex);
}
return contact;
}
public void EditContact(Contact contact)
{
ContactSprocs sproc = new ContactSprocs();
sproc.EditContacts(contact.Id.ToString(), contact.Name, contact.Email, contact.Mobile);
}
/// <summary>
/// Returns all the Contacts in the system
/// </summary>
/// <returns></returns>
public List<Contact> GetContacts()
{
StoredProcedure sproc = new StoredProcedure();
MySqlCommand cmd = sproc.Command("NMS_GetContacts", null, null,false);
MySqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
List<Contact> results = new List<Contact>();
// iterate through results, printing each to console
while (rdr.Read())
{
Contact contact = new Contact();
contact.Id = Convert.ToInt32(rdr["id"]);
contact.Email = rdr["email"].ToString();
contact.Mobile = rdr["phone_number"].ToString();
contact.Name = rdr["name"].ToString();
results.Add(contact);
}
return results;
}
public int AddContact(Contact contact)
{
ContactSprocs sproc = new ContactSprocs();
return sproc.AddContact(contact.Name, contact.Email, contact.Mobile);
}