public static DeletedMessage GetDeletedMessage(int id) { DeletedMessage result = null; const string query = @"select * from dbo.DeletedMessages where Id=@Id"; var connection = new SqlConnection(connStr); var sqlCommand = new SqlCommand(query, connection); sqlCommand.Parameters.AddWithValue("Id", id); try { connection.Open(); using (var reader = sqlCommand.ExecuteReader()) { if (reader.Read()) { result = ReadDeletedMessageInfo(reader); } } } catch (Exception ex) { string methodName = MethodBase.GetCurrentMethod().Name; throw new Exception("in DeletedMessagesDAL." + methodName + "(): " + ex); } finally { connection.Close(); } return(result); }
public static int AddDeletedMessage(DeletedMessage deletedMessage) { int newDeletedMessageId = 0; const string query = @"insert into dbo.DeletedMessages (UserId, DialogWithUserId, MessageId) values (@UserId, @DialogWithUserId, @MessageId); DECLARE @newDeletedMessageId int; SELECT @newDeletedMessageId = SCOPE_IDENTITY(); SELECT @newDeletedMessageId"; var connect = new SqlConnection(connStr); var sqlCommand = new SqlCommand(query, connect); sqlCommand.Parameters.AddWithValue("UserId", deletedMessage.UserId); sqlCommand.Parameters.AddWithValue("DialogWithUserId", deletedMessage.DialogWithUserId); sqlCommand.Parameters.AddWithValue("MessageId", deletedMessage.MessageId); try { connect.Open(); newDeletedMessageId = (int)sqlCommand.ExecuteScalar(); } catch (Exception ex) { string methodName = MethodBase.GetCurrentMethod().Name; throw new Exception("in DeletedMessagesDAL." + methodName + "(): " + ex); } finally { connect.Close(); } return(newDeletedMessageId); }
void deletedMessageReceived(DeletedMessage prd) { main.Dispatcher.BeginInvoke(new Action(() => { main.ItemHolder.Children.Remove(main.Products[int.Parse(prd.id)]); main.Products.Remove(int.Parse(prd.id)); })); }
void deletedMessageReceived(DeletedMessage msg) { main.Dispatcher.BeginInvoke(new Action(() => { main.MessageHolder.Children.Remove(main.MessageControls[msg.ID]); main.MessageControls.Remove(msg.ID); })); }
private static DeletedMessage ReadDeletedMessageInfo(SqlDataReader reader) { var result = new DeletedMessage { Id = (int)reader["Id"], UserId = (int)reader["UserId"], DialogWithUserId = (int)reader["DialogWithUserId"], MessageId = (int)reader["MessageId"] }; return(result); }
protected virtual void OnRaiseCustomEvent(DeletedMessageEventArgs e) { DeletedMessage?.Invoke(this, e); }
internal MessageDeletedEventArgs(DeletedMessage msg) { DeletedMessage = msg; }