public FullReview GetReview(int id)
{
FullReview review = new FullReview();
Review r = context.Review.Where(x => x.Id == id).FirstOrDefault();
Workproduct w = context.Workproduct.Where(s => s.Id == r.WorkproductId).FirstOrDefault();
Project p = context.Project.Where(i => i.Id == w.ProjectId).FirstOrDefault();
Setup setup = new Setup()
{
ProjectName = p.Name,
WorkProductName = w.Name,
Html = r.Html,
IsEmpty = r.IsEmpty, Complete = r.Complete
};
review.Setup = setup;
review.Participant = GetParticipants(id);
List <Header> headers = new List <Header>();
List <int> ids = context.HeaderRowData.Where(x => x.ReviewId == r.Id).Select(x => x.HeaderRowId).ToList();
List <HeaderRow> rows = context.HeaderRow.Where(x => x.ReviewTameplateId == r.ReviewTameplateId && ids.Contains(x.Id)).ToList();
for (int i = 0; i < rows.Count; i++)
{
string name = context.ReviewColumn.Where(x => x.Id == rows[i].ReviewColumnId).Select(a => a.Name).FirstOrDefault();
string data = context.HeaderRowData.Where(x => x.ReviewId == r.Id && x.HeaderRowId == rows[i].Id).Select(o => o.Value).FirstOrDefault();
Header h = new Header()
{
Fcn = rows[i].Function, Name = rows[i].Name, Id = rows[i].Id, Parameter = rows[i].Parameter, ColumnName = name, Data = data
};
headers.Add(h);
}
review.HeadersRow = headers;
return(review);
}
public ActionResult SaveWorkProduct([FromBody] Workproduct workproduct)
{
var identity = HttpContext.User.Identity as ClaimsIdentity;
workproduct.UsersEmail = identity.FindFirst("UserEmail").Value;
Project p = context.Project.Where(o => o.Id == workproduct.ProjectId).FirstOrDefault();
if (p == null)
{
return(NotFound(new { Message = "Project doesn't exist!" }));
}
if (workproduct.Name != "")
{
context.Workproduct.Add(workproduct);
context.SaveChanges();
return(Ok());
}
return(BadRequest(new { Message = "Name can't be empty" }));
}
