public int DeleteMessage(Message message) { try { con.Open(); string query = "DELETE FROM Messages " + "WHERE MessageID = @MessageID OR Sender = @Sender OR Receiver = @Receiver "; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@MessageID", message.MessageID); cmd.Parameters.AddWithValue("@Sender", message.Sender); cmd.Parameters.AddWithValue("@Receiver", message.Receiver); 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 InsertMessage(Message message) { try { con.Open(); string query = "INSERT INTO Messages " + "(Sender " + ",Receiver " + ",Content) " + "VALUES " + "(@Sender " + ",@Receiver " + ",@Content)"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@Sender", message.Sender); cmd.Parameters.AddWithValue("@Receiver", message.Receiver); cmd.Parameters.AddWithValue("@Content", message.Content); 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 SelectMessage(Message message) { try { con = new SqlConnection(connectionString); con.Open(); string query = "SELECT * " + "FROM Messages " + "WHERE MessageID = @MessageID OR Sender = @Sender OR Receiver = @Receiver "; cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@MessageID", message.MessageID); cmd.Parameters.AddWithValue("@Sender", message.Sender); cmd.Parameters.AddWithValue("@Receiver", message.Receiver); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds, "Messages"); DataTable dt = ds.Tables["Messages"]; 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(); } }
public int SendMessage(Message message) { throw new NotImplementedException(); }
public int AddNewMessage(Message message) { throw new NotImplementedException(); }