public async Task <int> SaveIssueMember(int issueId, int userId, string relationShipType) { using (var db = new TeamEntitiesConn()) { var re = db.IssueMembers.FirstOrDefault( s => s.IssueID == issueId && s.MemberID == userId && s.RelationType == relationShipType); if (re == null) { re = new IssueMember { MemberID = userId, IssueID = issueId, CreatedByID = userId, CreatedDate = DateTime.UtcNow }; db.IssueMembers.Add(re); await db.SaveChangesAsync(); return(1); } else { db.IssueMembers.Remove(re); await db.SaveChangesAsync(); return(0); } } }
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 async Task Delete(int id) { using (var db = new TeamEntitiesConn()) { var c = db.Comments.FirstOrDefault(s => s.ID == id); if (c != null) { db.Comments.Remove(c); await db.SaveChangesAsync(); } } }
public async Task Delete(int id) { using (var db = new TeamEntitiesConn()) { var c = new Comment {ID = id}; db.Comments.Attach(c); db.Comments.Remove(c); await db.SaveChangesAsync(); //var c = db.Comments.FirstOrDefault(s => s.ID == id); //if (c != null) //{ // db.Comments.Remove(c); // await db.SaveChangesAsync(); //} } }
public async Task Delete(int id) { using (var db = new TeamEntitiesConn()) { var c = new Comment { ID = id }; db.Comments.Attach(c); db.Comments.Remove(c); await db.SaveChangesAsync(); //var c = db.Comments.FirstOrDefault(s => s.ID == id); //if (c != null) //{ // db.Comments.Remove(c); // await db.SaveChangesAsync(); //} } }
public async Task<int> SaveIssueMember(int issueId, int userId, string relationShipType) { using (var db = new TeamEntitiesConn()) { var re = db.IssueMembers.FirstOrDefault( s => s.IssueID == issueId && s.MemberID == userId && s.RelationType == relationShipType); if (re == null) { re = new IssueMember { MemberID = userId, IssueID = issueId, CreatedByID = userId, CreatedDate = DateTime.UtcNow }; db.IssueMembers.Add(re); await db.SaveChangesAsync(); return 1; } else { db.IssueMembers.Remove(re); await db.SaveChangesAsync(); return 0; } } }