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) { } }