public void MarkResolved(int issueId)
 {
     using (var context = new OrdersIssuesDataClassDataContext(_connectionString))
     {
         context.Issues.FirstOrDefault(i => i.Id == issueId).Resolved = true;
         context.SubmitChanges();
     }
 }
 public void AddIssue(Issue issue)
 {
     using (var context = new OrdersIssuesDataClassDataContext(_connectionString))
     {
         context.Issues.InsertOnSubmit(issue);
         context.SubmitChanges();
     }
 }
 public void MarkComplete(int OrderId)
 {
     using (var context = new OrdersIssuesDataClassDataContext(_connectionString))
     {
         context.Orders.FirstOrDefault(o => o.Id == OrderId).Completed = true;
         context.SubmitChanges();
     }
 }
 public void AddOrder(Order order)
 {
     order.Date = DateTime.Now;
     using (var context = new OrdersIssuesDataClassDataContext(_connectionString))
     {
         context.Orders.InsertOnSubmit(order);
         context.SubmitChanges();
     }
 }
 public IEnumerable <Issue> GetIssues(int orderId)
 {
     using (var context = new OrdersIssuesDataClassDataContext(_connectionString))
     {
         var loadOptions = new DataLoadOptions();
         loadOptions.LoadWith <Issue>(i => i.Order);
         context.LoadOptions = loadOptions;
         return(context.Issues.Where(i => i.OrderId == orderId).ToList());
     }
 }
 public Order GetOrder(int orderId)
 {
     using (var context = new OrdersIssuesDataClassDataContext(_connectionString))
     {
         var loadOptions = new DataLoadOptions();
         loadOptions.LoadWith <Order>(o => o.Issues);
         context.LoadOptions = loadOptions;
         return(context.Orders.FirstOrDefault(o => o.Id == orderId));
     }
 }
 public IEnumerable <Order> GetOrders()
 {
     using (var context = new OrdersIssuesDataClassDataContext(_connectionString))
     {
         var loadOptions = new DataLoadOptions();
         loadOptions.LoadWith <Order>(o => o.Issues);
         context.LoadOptions = loadOptions;
         return(context.Orders.ToList());
     }
 }