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 = 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;
}
}
}
