public int CreateReview([FromBody] FullReviewSetup review)
{
Review r = new Review()
{
Name = review.Setup.Name,
CloseDate = review.Setup.EndDate,
Description = review.Setup.Description,
StartDate = review.Setup.StartDate,
//WorkproductId = review.Setup.WorkProduct,
ReviewTameplateId = review.Setup.Tameplate,
Html = review.Setup.Html,
IsEmpty = review.Setup.IsEmpty
};
var tmp = context.ReviewTameplate.Where(x => x.Id == review.Setup.Tameplate).
Include(p => p.HeaderRow).FirstOrDefault();
foreach (var t in tmp.HeaderRow)
{
HeaderRowData data = new HeaderRowData()
{
HeaderRowId = t.Id
};
r.HeaderRowData.Add(data);
}
foreach (var p in review.Participant)
{
UserReviewRole userReviewRole = new UserReviewRole()
{
UsersEmail = p.Email,
ReviewRoleId = p.Role,
};
r.UserReviewRole.Add(userReviewRole);
}
foreach (int i in review.Artifact)
{
var artifact = context.IbmArtifact.Where(a => a.Id == i).FirstOrDefault();
IbmArtifactReview ar = new IbmArtifactReview();
ar.IbmArtifactIbmId = artifact.IbmId;
ar.IbmArtifactId = artifact.Id;
r.IbmArtifactReview.Add(ar);
r.IbmArtifact.Add(artifact);
}
context.Workproduct.Where(w => w.Id == review.Setup.WorkProduct).FirstOrDefault().Review.Add(r);
//context.Review.Add(r);
context.SaveChanges();
return(r.Id);
}
private void SaveArtifactToDatabase(List <JazzArtifact> artifacts, IbmUrlModel model)
{
;
foreach (var a in artifacts)
{
IbmArtifact artifact = new IbmArtifact()
{
IbmId = a.IbmId, Name = a.Name, Url = a.Url, WorkproductId = model.WorkProductId
};
context.Workproduct.Where(w => w.Id == model.WorkProductId).FirstOrDefault().IbmArtifact.Add(artifact);
}
context.SaveChanges();
}
public IActionResult SaveProject([FromBody] ProjectModel project)
{
var identity = HttpContext.User.Identity as ClaimsIdentity;
if (identity != null)
{
string email = identity.FindFirst("UserEmail").Value;
Project p = new Project()
{
Name = project.Name, Description = project.Description, UsersEmail = email, ProjectTypeId = project.ProjectTypeId
};
context.Project.Add(p);
context.SaveChanges();
UserProject r = new UserProject()
{
ProjectId = p.Id, UsersEmail = email
};
context.UserProject.Add(r);
context.SaveChanges();
return(Ok());
}
return(Unauthorized());
}
public ActionResult Registration([FromBody] RegistrationModel registrationModel)
{
byte[] salt;
new RNGCryptoServiceProvider().GetBytes(salt = new byte[16]);
string slt = Convert.ToBase64String(salt);
byte[] passwordBytes = System.Text.Encoding.UTF8.GetBytes(registrationModel.Password + slt);
SHA256Managed sHA256 = new SHA256Managed();
byte[] hash = sHA256.ComputeHash(passwordBytes);
string hashedPassword = Convert.ToBase64String(hash);
Users u = new Users();
u.Email = registrationModel.Email;
u.Firstname = registrationModel.Firstname;
u.Lastname = registrationModel.Lastname;
u.Password = hashedPassword;
u.Salt = slt;
u.SystemRoleId = context.SystemRole.FirstOrDefault().Id;
context.Users.Add(u);
context.SaveChanges();
return(Ok());
}
public IActionResult CreateTameplate([FromBody] ReviewTameplateModel model)
{
var identity = HttpContext.User.Identity as ClaimsIdentity;
string email = identity.FindFirst("UserEmail").Value;
ReviewTameplate tameplate = new ReviewTameplate()
{
Name = model.Name, Description = model.Descritpion, UsersEmail = email
};
foreach (var row in model.Header)
{
if (row.ColumnName == null)
{
HeaderRow headerRow = new HeaderRow()
{
Function = row.Fcn, Parameter = row.Parameter, Name = row.Name
};
tameplate.HeaderRow.Add(headerRow);
}
}
foreach (string s in model.Role)
{
ReviewRole role = new ReviewRole()
{
Name = s
};
tameplate.ReviewRole.Add(role);
}
foreach (ReviewTameplateViewModel m in model.Model)
{
ReviewColumn column = new ReviewColumn()
{
Name = m.ColumnName, Type = m.Type
};
ReviewHeader row = model.Header.Where(x => x.ColumnName == m.ColumnName).FirstOrDefault();
if (row != null)
{
HeaderRow headerRow = new HeaderRow()
{
Function = row.Fcn, Parameter = row.Parameter, Name = row.Name
};
column.HeaderRow.Add(headerRow);
tameplate.HeaderRow.Add(headerRow);
}
tameplate.ReviewColumn.Add(column);
if (m.Option != null)
{
foreach (string s in m.Option)
{
ReviewColumnTypeEnum en = new ReviewColumnTypeEnum()
{
Name = s
};
column.ReviewColumnTypeEnum.Add(en);
}
}
}
context.ReviewTameplate.Add(tameplate);
context.SaveChanges();
return(Ok());
}
