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