public int InsertContact(Contact contact)
{
try
{
con.Open();
string query = "INSERT INTO Contacts " +
"(User01 " +
",User02) "+
"VALUES " +
"(@User01 " +
",@User02)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@User01", contact.User01);
cmd.Parameters.AddWithValue("@User02", contact.User02);
return cmd.ExecuteNonQuery();
}
catch (SqlException i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
catch (Exception i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
finally
{
con.Close();
}
}
public int DeleteContact(Contact contact)
{
try
{
con.Open();
string query = "DELETE FROM Contacts " +
"WHERE ContactID = @ContactID OR User01 = @User01 OR User02 = @User02";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@ContactID", contact.ContactId);
cmd.Parameters.AddWithValue("@User01", contact.User01);
cmd.Parameters.AddWithValue("@User02", contact.User02);
return cmd.ExecuteNonQuery();
}
catch (SqlException i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
catch (Exception i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
finally
{
con.Close();
}
}
public DataTable SelectContact(Contact contact)
{
try
{
con = new SqlConnection(connectionString);
con.Open();
string query = "SELECT * " +
"FROM Contacts "+
"WHERE ContactID = @ContactID OR User01 = @User01 OR User02 = @User02";
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@ContactID", contact.ContactId);
cmd.Parameters.AddWithValue("@User01", contact.User01);
cmd.Parameters.AddWithValue("@User02", contact.User02);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "Contacts");
DataTable dt = ds.Tables["Contacts"];
return dt;
}
catch (SqlException i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return null;
}
catch (Exception i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return null;
}
finally
{
con.Close();
}
}
