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;
}
