public void MailChecked([FromBody] MarkMailRequest mailed)
{
// List<Person> list = _memoryCache.Get<List<Person>>(CACHE_KEY);
//var count = list.RemoveAll(p => arr.ToList().Contains(p.Id));
// _memoryCache.Set(CACHE_KEY, list);
DatabaseHelper db = new DatabaseHelper();
db.MailChecked(mailed);
return;
}
public void MailChecked(MarkMailRequest mailchecked)
{
string insertMailed;
if (mailchecked.IsMailed)
{
insertMailed = "UPDATE PersonalInformation set IsMailed = 1 WHERE Guid='" + mailchecked.Id + "'";
}
else
{
insertMailed = "UPDATE PersonalInformation set IsMailed = 0 WHERE Guid='" + mailchecked.Id + "'";
}
_cnn.Open();
SqlCommand cmd = new SqlCommand(insertMailed, _cnn);
cmd.ExecuteNonQuery();
_cnn.Close();
}
