public async Task <PaginatedViewInstances> GetNotAssignedInstances(int id, int page = 0, String namefilter = "",
String serverNamefilter = "", String versionFilter = "", String sqlversions = "")
{
PaginatedInstances result = await unitOfWork.Users.GetNotAssignedInstancesAsync(id, page, namefilter, serverNamefilter, versionFilter, sqlversions);
return(new PaginatedViewInstances(result));
}
public async Task <IHttpActionResult> GetAssigned(int id = 0, int page = 0, String namefilter = "",
String serverNamefilter = "", String versionFilter = "", String sqlversions = "")
{
InstanceRepository repository = new InstanceRepository(new MsSqlMonitorEntities());
IListModelResponse <InstanceViewModel> response = new ListModelResponse <InstanceViewModel>();
try
{
PaginatedInstances data = await repository.GetAssignedInstancesAsync(id, page, namefilter, serverNamefilter, versionFilter, sqlversions);
response.Model = data.List.Select(i => i.ToViewModel());
response.PagesCount = data.PageCount;
response.PageNumber = data.Page;
response.PageSize = data.PageSize;
response.Versions = data.Versions;
}
catch (Exception e)
{
response.DidError = true;
response.ErrorMessage = e.Message;
}
return(response.ToHttpResponse(Request));
}
public PaginatedViewInstances(PaginatedInstances i)
{
PageSize = i.PageSize;
Page = i.Page;
PagesCount = i.PageCount;
List = i.List.Select(k => k.ToViewModel());
Versions = i.Versions;
Error = i.Error;
}
public async Task <PaginatedInstances> GetAssignedInstancesAsync(int userId, int page = 0, String namefilter = "", String serverNamefilter = "", String versionFilter = "", string sqlversions = "")
{
var result = new PaginatedInstances();
try
{
List <int> assignedInstanceId = GetAssignedInstanceId(userId);
var listAll = await instanceRepository.GetAllAsync();
var instances = listAll.Where(g => assignedInstanceId.Any(i => i == g.Id) && CheckInstance(g, namefilter, serverNamefilter, versionFilter, sqlversions));
int pageCount = instances.Count <Instance>() / PAGE_SIZE;
if (pageCount * PAGE_SIZE < instances.Count <Instance>())
{
pageCount++;
}
if (page > pageCount)
{
page = pageCount;
}
if (page < 0)
{
page = 0;
}
int startElement = page * PAGE_SIZE;
var resultList = instances.Skip <Instance>(startElement).Take <Instance>(PAGE_SIZE);
result.List = resultList;
result.Page = page;
result.PageCount = pageCount;
result.PageSize = PAGE_SIZE;
result.Versions = listAll.Where(i => i.InstanceVersion != null).Select <Instance, String>(i => i.InstanceVersion.Version.Split('.')[0]).ToList().Distinct();
}
catch (Exception e)
{
result.Error = e.Message;
}
return(result);
}
public async Task <PaginatedInstances> GetAssignedDeletedInstancesAsync(int userID, int page, string nameFilter, string serverNameFilter, string versionFilter, string sqlversions)
{
List <int> ids = await context.Assigns.Where(a => a.UserId == userID).Select(g => g.InstanceId).ToListAsync();
var instances = await context.Instances.Where(g => ids.Any(i => i == g.Id && g.IsDeleted)).ToListAsync();
PaginatedInstances result = new PaginatedInstances();
var list = instances.Where(p => CheckInstance(p, nameFilter, serverNameFilter, versionFilter, sqlversions));
int pageCount = list.Count <Instance>() / PAGE_SIZE;
if (pageCount * PAGE_SIZE < list.Count <Instance>())
{
pageCount++;
}
if (page > pageCount)
{
page = pageCount;
}
if (page < 0)
{
page = 0;
}
int startElement = page * PAGE_SIZE;
var resultList = list.Skip <Instance>(startElement).Take <Instance>(PAGE_SIZE);
result.List = resultList;
result.Page = page;
result.PageCount = pageCount;
result.PageSize = PAGE_SIZE;
result.Versions = resultList.Where(i => i.InstanceVersion != null).Select <Instance, String>(i => i.InstanceVersion.Version.Split('.')[0]).ToList().Distinct();
return(result);
}
public async Task <PaginatedInstances> GetDeletedInstancesAsync(int page, string nameFilter, string serverNameFilter, string versionFilter, string sqlversions)
{
var tmpList = await context.Instances.ToListAsync();
PaginatedInstances result = new PaginatedInstances();
var list = tmpList.Where(p => CheckInstance(p, nameFilter, serverNameFilter, versionFilter, sqlversions) && p.IsDeleted);
int pageCount = list.Count <Instance>() / PAGE_SIZE;
if (pageCount * PAGE_SIZE < list.Count <Instance>())
{
pageCount++;
}
if (page > pageCount)
{
page = pageCount;
}
if (page < 0)
{
page = 0;
}
int startElement = page * PAGE_SIZE;
var resultList = list.Skip <Instance>(startElement).Take <Instance>(PAGE_SIZE);
result.List = resultList;
result.Page = page;
result.PageCount = pageCount;
result.PageSize = PAGE_SIZE;
result.Versions = resultList.Where(i => i.InstanceVersion != null).Select <Instance, String>(i => i.InstanceVersion.Version.Split('.')[0]).ToList().Distinct();
return(result);
}
