public async Task RemoveEntry (int ID)
{
try
{
await Task.Run(() =>
{
var Query = @"update GuestBook set IsDeleted = 1 where GuestBookID = @GuestBookID";
var Params = new { @GuestBookID = ID };
SetUpRawSQL(Params, Query);
SqlCommand.ExecuteNonQuery();
});
}
catch (Exception Ex)
{
}
}
public async Task AddEntry (GuestBookModel GuestBook)
{
try
{
await Task.Run(() =>
{
GuestBook.Message = Regex.Replace(GuestBook.Message, @"\p{Cs}", "");
var Query = @"insert into GuestBook (Message, Email, Name) values
(@Message, @Email, @Name)";
var Params = new { @Message = GuestBook.Message, @Email = GuestBook.Email, @Name = GuestBook.Name };
SetUpRawSQL(Params, Query);
SqlCommand.ExecuteNonQuery();
});
}
catch (Exception Ex)
{
}
}
