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()); }