public ActionResult Index(int?pageNumber = 1)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
var errors = repositoriesContainer.RepositoryFor <Error>().GetPageableBy(new PageableQuery <Error>(new PageInfo
{
PageNumber = pageNumber ?? 1,
PageSize = 15
}).OrderBy(new SortCriteria("Date", SortDirection.Desc)));
var viewModels = errors.Items.Select(e => new ErrorViewModel
{
Id = e.Id,
Title = e.Message,
Time = e.Date,
});
return(View(new PageableList <ErrorViewModel>
{
Items = viewModels.ToList(),
HasNext = errors.HasNext,
HasPrevious = errors.HasPrevious,
TotalCount = errors.TotalCount,
PageInfo = errors.PageInfo
}));
}
}
public Resource GetResource(int id)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapObjectsRepository.GetResource(id));
}
}
public IList <MapObject> GetAllMapObjects(MapObjectType mapObjectType)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapObjectsRepository.GetAllMapObjects(mapObjectType));
}
}
public Project GetProject(int id)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapObjectsRepository.GetProject(id));
}
}
public ICollection <string> GetAllTags()
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapObjectsRepository.GetAllTags());
}
}
public byte[] GetMapObjectImage(MapObjectType mapObjectType, int id)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapObjectsRepository.GetMapObjectImage(mapObjectType, id));
}
}
public OrganizationProjectRelation GetOrganizationRelation(int id)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapProjectsRepository.GetOrganizationRelation(id));
}
}
public User GetUser(IQuery <User> query)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.RepositoryFor <User>().GetBy(query));
}
}
public Organization GetOrganization(int id)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.RepositoryFor <Organization>().GetBy(new Query <Organization>(e => e.Id == id).Include(e => e.ActivitiesDirections).Include(e => e.ActivitiesTypes).Include(e => e.OrganizationForm)));
}
}
public void UpdateUser(User user)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
repositoriesContainer.RepositoryFor <User>().Save(user);
}
}
public bool IsExistsUser(IQuery <User> query)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.RepositoryFor <User>().GetBy(query) != null);
}
}
public IEnumerable <Organization> GetTitles(string query)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapOrganizationsRepository.GetTitles(query, 5));
}
}
public IEnumerable <Role> GetAllRoles()
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.RepositoryFor <Role>().GetAll());
}
}
public void RefreshCoordinates()
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
var organizationsList = repositoriesContainer.RepositoryFor <Organization>().GetAll().ToList();
IGeoCoder geoCoder = new GoogleGeoCoder();
foreach (var mapObject in organizationsList)
{
var organization = mapObject;
var addresses = geoCoder.GeoCode(organization.Address).ToList();
if (addresses.Any())
{
organization.Latitude = addresses.First().Coordinates.Latitude;
organization.Longitude = addresses.First().Coordinates.Longitude;
}
}
repositoriesContainer.RepositoryFor <Organization>().Save(organizationsList);
repositoriesContainer.ApplyChanges();
}
}
public IPageableList <Resource> GetResources(string text, IPageInfo pageInfo)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.RepositoryFor <Resource>().GetPageableBy(new PageableQuery <Resource>(pageInfo).AddFilterClause(e => e.Title.Contains(text) || string.IsNullOrEmpty(text))));
}
}
public IEnumerable <TCatalog> GetCatalogValues <TCatalog>() where TCatalog : CatalogBase, new()
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.CatalogsRepository <TCatalog>().GetAll());
}
}
public TCatalog GetCatalogValue <TCatalog>(int catalogValueId) where TCatalog : CatalogBase, new()
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.CatalogsRepository <TCatalog>().GetBy(new Query <TCatalog>(e => e.Id == catalogValueId)));
}
}
public ActionResult Index(int?pageNumber = 1)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
var templates = repositoriesContainer.RepositoryFor <MessageTemplate>().GetPageableBy(new PageableQuery <MessageTemplate>(new PageInfo
{
PageNumber = pageNumber ?? 1,
PageSize = 15
}));
var viewModels = templates.Items.Select(e => new MessageTemplateViewModel
{
Id = e.Id,
Title = e.Title,
Blocked = e.Blocked
});
return(View(new PageableList <MessageTemplateViewModel>
{
Items = viewModels.ToList(),
HasNext = templates.HasNext,
HasPrevious = templates.HasPrevious,
TotalCount = templates.TotalCount,
PageInfo = templates.PageInfo
}));
}
}
public ProjectContactRelation GetProjectRelation(int id)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapPersonsRepository.GetProjectRelation(id));
}
}
public IList <MapObject> GetSuggestions(string query)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapPersonsRepository.GetSuggestions(query));
}
}
public IList <OrganizationContactRelation> GetOrganizationsRelations(int parentId)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapPersonsRepository.GetRelatedOrganizations(parentId));
}
}
public IList <ProjectContactRelation> GetProjectsRelations(int parentId)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.MapPersonsRepository.GetProjectsRelations(parentId));
}
}
public IPageableList <Person> GetPersons(string text, IPageInfo pageInfo)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.RepositoryFor <Person>().GetPageableBy(new PageableQuery <Person>(pageInfo).AddFilterClause(e => (e.LastName + " " + e.Name + " " + e.MiddleName).Contains(text) || string.IsNullOrEmpty(text))));
}
}
public void Save(Person person)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
repositoriesContainer.RepositoryFor <Person>().Save(person);
repositoriesContainer.ApplyChanges();
}
}
public Person GetPerson(int id)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
return(repositoriesContainer.RepositoryFor <Person>().GetBy(new Query <Person>(e => e.Id == id)
.Include(e => e.PersonStatuses)));
}
}
public void DeletePerson(Person person)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
repositoriesContainer.MapPersonsRepository.Delete(person);
repositoriesContainer.ApplyChanges();
}
}
public void DeleteResource(Resource resource)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
repositoriesContainer.MapResourcesRepository.Delete(resource);
repositoriesContainer.ApplyChanges();
}
}
public void SaveProjectPersonRelation(ProjectContactRelation domainModel)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
repositoriesContainer.ProjectPersonRelationRepository.Save(domainModel);
repositoriesContainer.ApplyChanges();
}
}
public void SaveOrganizationsRelation(OrganizationsRelation organizationsRelation)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
repositoriesContainer.OrganizationsRelations.Save(organizationsRelation);
repositoriesContainer.ApplyChanges();
}
}
public void Save(Project project)
{
using (var repositoriesContainer = new InnostarRepositoriesContainer())
{
repositoriesContainer.RepositoryFor <Project>().Save(project);
repositoriesContainer.ApplyChanges();
}
}
