public string GetContacts(string userId)
{
string response = "";
int id = -1;
MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["database"].ToString());
try
{
bool s = int.TryParse(userId, out id);
if (s == false)
{
return("Failed");
}
var cmd = new MySqlCommand(string.Format("CALL GetAllContacts({0});", id), connection);
connection.Open();
List <BasicContact> resList = new List <BasicContact>();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
BasicContact contact = new BasicContact();
contact.Id = int.Parse(reader["Id"].ToString());
contact.FirstName = reader["FirstName"].ToString();
contact.LastName = reader["LastName"].ToString();
resList.Add(contact);
}
}
response = JsonConvert.SerializeObject(resList);
return(response);
}
catch (Exception e)
{
return(JsonConvert.SerializeObject(e));
}
finally
{
connection.Close();
}
}
public string GetSingleContact(string searchData, string userId)
{
MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["database"].ToString());
string response = "";
try
{
connection.Open();
string query = string.Format("SELECT * FROM contactinfo WHERE UserId={0} AND (FirstName LIKE '%{1}%' OR LastName LIKE '%{2}%');", userId, searchData, searchData);
MySqlCommand cmd = new MySqlCommand(query, connection);
List <BasicContact> resList = new List <BasicContact>();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
BasicContact contact = new BasicContact();
contact.Id = int.Parse(reader["Id"].ToString());
contact.FirstName = reader["FirstName"].ToString();
contact.LastName = reader["LastName"].ToString();
resList.Add(contact);
}
}
response = JsonConvert.SerializeObject(resList);
return(response);
}
catch (Exception e)
{
return(JsonConvert.SerializeObject(e));
}
finally
{
connection.Close();
}
}
