public OperationStatus SaveUser(User user)
{
try
{
if (user.ID == 0)
{
user.CreatedDate = DateTime.UtcNow;
db.Users.Add(user);
}
else
{
db.Entry(user).State = EntityState.Modified;
}
db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
return(OperationStatus.CreateFromException("error", dbEx));
}
catch (Exception ex)
{
var res = new OperationStatus();
}
return(new OperationStatus {
OperationID = user.ID, Status = true
});
}
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 SaveActivity(Activity activity)
{
try
{
activity.CreatedDate = DateTime.UtcNow;
db.Activities.Add(activity);
db.SaveChanges();
return(new OperationStatus {
Status = true
});
}
catch (Exception ex)
{
return(OperationStatus.CreateFromException("error in saving", ex));
}
}
public OperationStatus SaveComment(Comment comment)
{
try
{
comment.CreatedDate = DateTime.UtcNow;
db.Comments.Add(comment);
db.SaveChanges();
}
catch (Exception ex)
{
return(OperationStatus.CreateFromException("Error in comment", ex));
}
return(new OperationStatus {
Status = true, OperationID = comment.ID
});
}
/*
* 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 OperationStatus DeleteIssue(int issueId)
{
try
{
var issue = db.Issues.FirstOrDefault(s => s.ID == issueId);
if (issue != null)
{
issue.Active = false;
db.Entry(issue).State = EntityState.Modified;
db.SaveChanges();
}
return(new OperationStatus {
Status = true
});
}
catch (Exception ex)
{
return(OperationStatus.CreateFromException("Error deleting issue " + issueId, ex));
}
}
public OperationStatus DeleteIssueMember(int issueId, int memberId)
{
try
{
var issueMember = db.IssueMembers.Where(s => s.IssueID == issueId && s.MemberID == memberId).FirstOrDefault();
if (issueMember != null)
{
db.IssueMembers.Remove(issueMember);
db.SaveChanges();
return(new OperationStatus {
Status = true
});
}
}
catch (Exception ex)
{
return(OperationStatus.CreateFromException("Error in deleting issue member. Issue:" + issueId + ", member:" + memberId, ex));
}
return(new OperationStatus {
Status = false, Message = "No record found!"
});
}
public OperationStatus SaveTeamMemberRequest(TeamMemberRequest teamMemberRequest)
{
try
{
if (teamMemberRequest.ID == 0)
{
teamMemberRequest.CreatedDate = DateTime.UtcNow;
db.TeamMemberRequests.Add(teamMemberRequest);
}
else
{
db.Entry(teamMemberRequest).State = EntityState.Modified;
}
db.SaveChanges();
return(new OperationStatus {
Status = true
});
}
catch (Exception ex)
{
return(OperationStatus.CreateFromException("Error in saving team member", ex));
}
}
