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 OperationStatus SaveIssueMemberRelation(IssueMember issueMember)
{
try
{
issueMember.CreatedDate = DateTime.Now;
db.IssueMembers.Add(issueMember);
db.SaveChanges();
}
catch (Exception ex)
{
return(OperationStatus.CreateFromException("error saving issue member", ex));
}
return(new OperationStatus());
}
/*
* public List<TechiesWeb.TeamBins.Entities.User> GetNonIssueMembers(int teamId, int issueId)
* {
* throw new System.NotImplementedException();
* }
*/
public OperationStatus SaveIssueMember(int issueId, int memberId, int addedBy)
{
try
{
var issueMember = new IssueMember {
IssueID = issueId, MemberID = memberId, CreatedByID = addedBy, CreatedDate = DateTime.UtcNow
};
db.IssueMembers.Add(issueMember);
db.SaveChanges();
return(new OperationStatus {
Status = true
});
}
catch (Exception ex)
{
return(OperationStatus.CreateFromException("Errorin saving issuemember", ex));
}
}
public OperationStatus DeleteIssueMemberRelation(IssueMember issueMember)
{
try
{
var issueMemberRelation = db.IssueMembers.Where(s => s.IssueID == issueMember.IssueID && s.MemberID == issueMember.MemberID && s.RelationType == issueMember.RelationType).FirstOrDefault();
if (issueMemberRelation != null)
{
db.IssueMembers.Remove(issueMemberRelation);
db.SaveChanges();
return(new OperationStatus {
Status = true
});
}
}
catch (Exception ex)
{
return(OperationStatus.CreateFromException("error deleting issue member relation " + issueMember.ID, ex));
}
return(new OperationStatus());
}
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;
}
}
}
private bool SaveIssueMemberRelation(int issueId, int userId, IssueMemberRelationType relationType, int createdById)
{
try
{
var issueMember = new IssueMember { MemberID = userId, IssueID = issueId, CreatedByID=createdById, RelationType = relationType.ToString() };
var result = repo.SaveIssueMemberRelation(issueMember);
}
catch(Exception ex)
{
// to do : Log
return false;
}
return true;
}
/*
public List<TechiesWeb.TeamBins.Entities.User> GetNonIssueMembers(int teamId, int issueId)
{
throw new System.NotImplementedException();
}
*/
public OperationStatus SaveIssueMember(int issueId, int memberId, int addedBy)
{
try
{
var issueMember = new IssueMember { IssueID = issueId, MemberID = memberId, CreatedByID = addedBy, CreatedDate = DateTime.UtcNow };
db.IssueMembers.Add(issueMember);
db.SaveChanges();
return new OperationStatus { Status = true };
}
catch (Exception ex)
{
return OperationStatus.CreateFromException("Errorin saving issuemember", ex);
}
}
public OperationStatus SaveIssueMemberRelation(IssueMember issueMember)
{
try
{
issueMember.CreatedDate = DateTime.Now;
db.IssueMembers.Add(issueMember);
db.SaveChanges();
}
catch(Exception ex)
{
return OperationStatus.CreateFromException("error saving issue member",ex);
}
return new OperationStatus();
}
public OperationStatus DeleteIssueMemberRelation(IssueMember issueMember)
{
try
{
var issueMemberRelation = db.IssueMembers.Where(s => s.IssueID == issueMember.IssueID && s.MemberID == issueMember.MemberID && s.RelationType == issueMember.RelationType).FirstOrDefault();
if (issueMemberRelation != null)
{
db.IssueMembers.Remove(issueMemberRelation);
db.SaveChanges();
return new OperationStatus { Status = true };
}
}
catch (Exception ex)
{
return OperationStatus.CreateFromException("error deleting issue member relation "+issueMember.ID , ex);
}
return new OperationStatus();
}
