public static IList<IssueItem> GetIssues()
{
try
{
using (var db = new IssuesEntities())
{
return (from i in db.Issue
select new IssueItem
{
Id = i.Id,
Title = i.Title,
Type = i.Type1.Name,
Description = i.Description,
CreatedOn = i.CreatedOn,
ModifiedOn = i.ModifiedOn,
Status = i.Status1.Name,
TypeId = i.Type1.Id,
StatusId = i.Status1.Id
}).ToList();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
public static bool AddIssue(Issue issue)
{
try
{
using (var db = new IssuesEntities())
{
db.Issue.Add(issue);
db.SaveChanges();
return true;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
public static IList<StatusItem> GetStatuses(IssueType typeId)
{
try
{
using (var db = new IssuesEntities())
{
var query = (from s in db.Status select s);
switch (typeId)
{
case IssueType.Userstory:
{
query = query.Where(arg => arg.UserstorySupport);
break;
}
case IssueType.Bag:
{
query = query.Where(arg => arg.BagSupport);
break;
}
case IssueType.Enhancement:
{
query = query.Where(arg => arg.EnhancementSupport);
break;
}
default:
{
return null;
}
}
return query.Select(arg => new StatusItem { Id = arg.Id, Name = arg.Name }).ToList();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
public static bool UpdateIssue(IssueAjax issue)
{
try
{
using (var db = new IssuesEntities())
{
var iss = (from i in db.Issue where i.Id == issue.Id select i).Single();
iss.ModifiedOn = DateTime.Now;
iss.Title = issue.Title;
iss.Description = issue.Description;
iss.Type = issue.TypeId;
iss.Status = issue.StatusId;
db.Issue.AddOrUpdate(iss);
db.SaveChanges();
return true;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
public static bool RemoveIssue(int id)
{
using (var db = new IssuesEntities())
{
try
{
var forremove = (from i in db.Issue where i.Id == id select i).Single();
db.Issue.Remove(forremove);
db.SaveChanges();
return true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
}
public static IList<TypeItem> GetTypes()
{
try
{
using (var db = new IssuesEntities())
{
return (from t in db.Type select new TypeItem { Id = t.Id, Name = t.Name }).ToList();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
