//Get pledges by project id single project view
public List <Pledge> GetPledgesByProjectId(int projectId)
{
return(_db.Set <Pledge>()
.Include(p => p.PledgeUsers)
.Where(p => p.Project.ProjectId == projectId)
.ToList());
}
public async Task <IActionResult> GetAllProjects(string projectCategory, string searchString)
{
//Use LINQ to get list of genres.
IQueryable <string> categoryQuery = from m in _db.Set <Project>()
orderby m.ProjectCategory
select m.ProjectCategory;
var viewallprojects = new ProjectsGridVM
{
Categories = new SelectList(await categoryQuery.Distinct().ToListAsync()),
Projects = _projectservices.GetAllActiveProjects(projectCategory, searchString).ToList(),
ProjectMultimedia = _multimediaServices.GetAll()
};
return(View(viewallprojects));
}
public IQueryable <Fund> GetUserFunds()
{
string userId = httpContextAccessor.HttpContext.User.FindFirstValue(ClaimTypes.NameIdentifier);
var result = _db.Set <Fund>()
.Include(p => p.Project)
.Where(p => p.UserId == userId)
.Distinct()
.AsQueryable();
if (result == null)
{
return(null);
}
return(result);
}
public Result <Post> UpdatePost(PostOptions postOptions)
{
if (postOptions == null)
{
return(Result <Post> .CreateFailed(
StatusCode.BadRequest, "Null options"));
}
if (string.IsNullOrWhiteSpace(postOptions.PostDescription))
{
return(Result <Post> .CreateFailed(
StatusCode.BadRequest, "Null or empty PostDescription"));
}
//string userId = httpContextAccessor.HttpContext.User.FindFirstValue(ClaimTypes.NameIdentifier);
var post = _db.Set <Post>().Find(postOptions.PostId);
post.PostDescription = postOptions.PostDescription;
var rows = 0;
try
{
rows = _db.SaveChanges();
}
catch (Exception ex)
{
return(Result <Post> .CreateFailed(
StatusCode.InternalServerError, ex.ToString()));
}
if (rows <= 0)
{
return(Result <Post> .CreateFailed(
StatusCode.InternalServerError,
"Post could not be updated"));
}
return(Result <Post> .CreateSuccessful(post));
}
//GetMultimediaOfProject(int projectId);
public List <Multimedia> GetMultimediaOfProject(int projectId)
{
return(_db.Set <Multimedia>()
.Where(p => p.Project.ProjectId == projectId)
.ToList());
}