public void SaveDefaultProject(int userId, int teamId, int?selectedProject)
{
var teamMember = db.TeamMembers.FirstOrDefault(s => s.MemberID == userId && s.TeamID == teamId);
if (teamMember != null)
{
teamMember.DefaultProjectID = selectedProject;
db.Entry(teamMember).State = EntityState.Modified;
db.SaveChanges();
}
}
public int Save(UserAccountDto userAccount)
{
var userEntity = new User();
userEntity.FirstName = userAccount.Name;
userEntity.EmailAddress = userAccount.EmailAddress;
userEntity.Password = userAccount.Password;
userEntity.Avatar = userAccount.GravatarUrl;
userEntity.CreatedDate = DateTime.UtcNow;
db.Users.Add(userEntity);
db.SaveChanges();
return(userEntity.ID);
}
public int Save(CommentVM comment)
{
using (var db = new TeamEntitiesConn())
{
var commentEntity = new Comment();
commentEntity.IssueID = comment.IssueId;
commentEntity.CommentText = comment.CommentBody;
commentEntity.CreatedDate = DateTime.Now;
commentEntity.CreatedByID = comment.Author.Id;
;
db.Comments.Add(commentEntity);
db.SaveChanges();
return commentEntity.ID;
}
}
public int Save(CommentVM comment)
{
using (var db = new TeamEntitiesConn())
{
var commentEntity = new Comment();
commentEntity.IssueID = comment.IssueId;
commentEntity.CommentText = comment.CommentBody;
commentEntity.CreatedDate = DateTime.Now;
commentEntity.CreatedByID = comment.Author.Id;
;
db.Comments.Add(commentEntity);
db.SaveChanges();
return(commentEntity.ID);
}
}
public int Save(ActivityDto activity)
{
using (var db = new TeamEntitiesConn())
{
var a = new Activity
{
OldState = activity.OldState,
NewState = activity.NewState,
ObjectID = activity.ObjectId,
ObjectType = activity.ObjectType,
ActivityDesc = activity.Description,
ObjectTitle = activity.ObjectTite,
CreatedByID = activity.Actor.Id,
TeamID = activity.TeamId,
CreatedDate = DateTime.Now
};
db.Activities.Add(a);
db.SaveChanges();
return a.ID;
}
}
public int Save(ActivityDto activity)
{
using (var db = new TeamEntitiesConn())
{
var a = new Activity
{
OldState = activity.OldState,
NewState = activity.NewState,
ObjectID = activity.ObjectId,
ObjectType = activity.ObjectType,
ActivityDesc = activity.Description,
ObjectTitle = activity.ObjectTite,
CreatedByID = activity.Actor.Id,
TeamID = activity.TeamId,
CreatedDate = DateTime.Now
};
db.Activities.Add(a);
db.SaveChanges();
return(a.ID);
}
}
public int SaveIssue(CreateIssue issue)
{
Issue issueEntity = null;
using (var db = new TeamEntitiesConn())
{
if (issue.Id > 0)
{
issueEntity = db.Issues.FirstOrDefault(s => s.ID == issue.Id);
if (issueEntity == null)
{
return 0;
}
}
else
{
issueEntity = new Issue();
}
issueEntity.Title = issue.Title;
issueEntity.Description = issue.Description;
issueEntity.ProjectID = issue.ProjectID;
issueEntity.TeamID = issue.TeamID;
issueEntity.CategoryID = issue.SelectedCategory;
issueEntity.CreatedByID = issue.CreatedByID;
issueEntity.Location = issue.Iteration;
issueEntity.StatusID = issue.SelectedStatus;
issueEntity.PriorityID = issue.SelectedPriority;
if (issueEntity.CategoryID == 0)
{
issueEntity.CategoryID = db.Categories.FirstOrDefault().ID;
}
if (issueEntity.StatusID == 0)
{
var status = db.Status.FirstOrDefault(s => s.Code == "New");
issueEntity.StatusID = status.ID;
}
if (issueEntity.PriorityID == null || issueEntity.PriorityID.Value == 0)
{
var priority = db.Priorities.FirstOrDefault(s => s.Code == "Normal");
issueEntity.PriorityID = priority.ID;
}
if (issue.Id == 0)
{
issueEntity.CreatedDate = DateTime.UtcNow;
issueEntity.Active = true;
db.Issues.Add(issueEntity);
}
else
{
issueEntity.ModifiedDate = DateTime.Now;
issueEntity.ModifiedByID = issue.CreatedByID;
db.Entry(issueEntity).State = EntityState.Modified;
}
db.SaveChanges();
return issueEntity.ID;
}
}
public void SaveDefaultTeam(int userId, int teamId)
{
var user = db.Users.FirstOrDefault(s => s.ID == userId);
if (user != null)
{
user.DefaultTeamID = teamId;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
}
public int SaveIssue(CreateIssue issue)
{
Issue issueEntity = null;
using (var db = new TeamEntitiesConn())
{
if (issue.ID > 0)
{
issueEntity = db.Issues.FirstOrDefault(s => s.ID == issue.ID);
if (issueEntity == null)
{
return(0);
}
}
else
{
issueEntity = new Issue();
}
issueEntity.Title = issue.Title;
issueEntity.Description = issue.Description;
issueEntity.ProjectID = issue.ProjectID;
issueEntity.TeamID = issue.TeamID;
issueEntity.CategoryID = issue.SelectedCategory;
issueEntity.CreatedByID = issue.CreatedByID;
issueEntity.Location = issue.Iteration;
issueEntity.StatusID = issue.SelectedStatus;
issueEntity.PriorityID = issue.SelectedPriority;
if (issueEntity.CategoryID == 0)
{
issueEntity.CategoryID = db.Categories.FirstOrDefault().ID;
}
if (issueEntity.StatusID == 0)
{
var status = db.Status.FirstOrDefault(s => s.Code == "New");
issueEntity.StatusID = status.ID;
}
if (issueEntity.PriorityID == null || issueEntity.PriorityID.Value == 0)
{
var priority = db.Priorities.FirstOrDefault(s => s.Code == "Normal");
issueEntity.PriorityID = priority.ID;
}
if (issue.ID == 0)
{
issueEntity.CreatedDate = DateTime.UtcNow;
issueEntity.Active = true;
db.Issues.Add(issueEntity);
}
else
{
issueEntity.ModifiedDate = DateTime.Now;
issueEntity.ModifiedByID = issue.CreatedByID;
db.Entry(issueEntity).State = EntityState.Modified;
}
db.SaveChanges();
return(issueEntity.ID);
}
}
