public void CalledChecked([FromBody] MarkCalledRequest called) { // 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.CallChecked(called); return; }
public void CallChecked(MarkCalledRequest callchecked) { string insertCalled; if (callchecked.IsCalled) { insertCalled = "UPDATE PersonalInformation set IsCalled = 1 WHERE Guid='" + callchecked.Id + "'"; } else { insertCalled = "UPDATE PersonalInformation set IsCalled = 0 WHERE Guid='" + callchecked.Id + "'"; } _cnn.Open(); SqlCommand cmd = new SqlCommand(insertCalled, _cnn); cmd.ExecuteNonQuery(); _cnn.Close(); }