public bool SetTicket(Model.Tickets.Ticket ticket) { ConnectwiseEntities entities = new ConnectwiseEntities(); SR_Service SR_ticket = entities.SR_Service.First(t => t.SR_Service_RecID == ticket.TicketID); if (ticket.StatusID > 0) SR_ticket.SR_Status_RecID = ticket.StatusID; if (ticket.HoursBudget > 0) SR_ticket.Hours_Budget = (decimal)ticket.HoursBudget; return entities.SaveChanges() > 0; }
public IEnumerable<Status> GetStatus(int serviceBoard) { List<Status> statusList = new List<Status>(); ConnectwiseEntities entities = new ConnectwiseEntities(); List<string> exclusions = new List<string> {"New (portal)", "New (email connector)", "Ready for Front End Development", "Closed", "Code Status Review", "Canceled", "Done yet?", "Waiting parts/repair" }; foreach (SR_Status status in entities.SR_Status.Where(s => s.SR_Board_RecID == serviceBoard)) { if (!exclusions.Contains(status.Description)) statusList.Add(Status.CreateStatus(status)); } return statusList; }
public IEnumerable<Ticket> GetTicketsForTheWeek(int?[] members, int?[] clients, int serviceBoard) { List<Ticket> returnTickets = new List<Ticket>(); ConnectwiseEntities entities = new ConnectwiseEntities(); int diff = DateTime.Now.DayOfWeek - DayOfWeek.Monday; if (diff < 0) { diff += 7; } DateTime startDate = DateTime.Now.AddDays((-1 * diff) - 1).Date; DateTime endDate = startDate.AddDays(7); var tickets = entities.somethingdigital_vTickets.Where(t => t.scheduleDate < endDate && t.scheduleDate > startDate); if (members != null) tickets = tickets.Where(t => members.Contains(t.employeeId)); if (clients != null) tickets = tickets.Where(t => clients.Contains(t.clientId)); tickets = tickets.Where(t => t.boardId == serviceBoard); tickets = tickets.OrderBy(t => t.Sort_Order); foreach (somethingdigital_vTickets ticket in tickets) returnTickets.Add( Ticket.CreateTicket(ticket)); return returnTickets; }