public async Task SaveLastLoginAsync(int userId)
{
var user = db.Users.FirstOrDefault(s => s.ID == userId);
if (user != null)
{
user.LastLoginDate = DateTime.UtcNow;
db.Entry(user).State = EntityState.Modified;
await db.SaveChangesAsync();
}
}
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 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;
}
}
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);
}
}
