public async Task EnableUsers(IEnumerable <User> users)
{
using (var sequenceEnum = users.GetEnumerator())
{
while (sequenceEnum.MoveNext())
{
var user = GetById(sequenceEnum.Current.UserId).Result;
user.IsEnabled = sequenceEnum.Current.IsEnabled;
_dataMarketDbContext.SaveChanges();
}
}
}
public async Task DeleteById(int id)
{
var savedFilter = _dataMarketDbContext.SavedFilters
.Where(f => f.SavedFilterId == id).FirstOrDefault();
_dataMarketDbContext.SavedFilters.Remove(savedFilter);
_dataMarketDbContext.SaveChanges();
var query = "Drop table SequenceForList_" + id.ToString();
SqlConnection objConnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DataMarketConnectionString"].ConnectionString);
{
objConnection.Open();
using (SqlCommand cmd = new SqlCommand(query, objConnection))
{
cmd.ExecuteNonQuery();
}
objConnection.Close();
}
}