public int GetNumberOfListItem(string listTitle) { ListItemLoader listItemLoader = new ListItemLoader(); int number = listItemLoader.GetAllListItem(listTitle, new List <string> { "Status" }).Count; return(number); }
public string SendTextFromOriginalTicket(int id, string listTitle) { ServiceDeskRequests serviceDeskItem = new ServiceDeskRequests(); ListItemLoader listItemLoader = new ListItemLoader(); ListItem listItem = listItemLoader.GetListItem(id, listTitle, new List <string> { "TicketID" }); int ticketID = ((FieldLookupValue)listItem["TicketID"]).LookupId; Ticket ticket = serviceDeskItem.GetTicket(ticketID); string textToSend = "Subject: " + ticket.Subject.ToString() + " " + "Original text: " + ticket.Body.ToString(); return(textToSend); }
public string GetEmailFromOriginalTicket(int id, string listTitle) { ListItemLoader listItemLoader = new ListItemLoader(); ListItem listItem = listItemLoader.GetListItem(id, listTitle, new List <string> { "From" }); string resultFrom = listItem["From"].ToString(); if (listItem["From"] != null) { FieldUserValue user = (FieldUserValue)listItem["From"]; resultFrom = user.Email; } return(resultFrom); }
public int GetNumberOfTicketInProgress(string listTitle) { int ok = 0; ListItemLoader listItemLoader = new ListItemLoader(); var listItem = listItemLoader.GetAllListItem(listTitle, new List <string> { "Status" }); for (int i = 0; i < listItem.Count; i++) { if (listItem[i].FieldValues.Values.Contains("In progress")) { ok++; } } return(ok); }
public int GetTotalNumberOfTicketReceivedInCurrentMonth(string listTitle) { ListItemLoader listItemLoader = new ListItemLoader(); var listItem = listItemLoader.GetAllListItem(listTitle, new List <string> { "Created" }); DateTime validfrom; int number = 0; for (int i = 0; i < listItem.Count; i++) { validfrom = (DateTime)listItem[i]["Created"]; if (validfrom.Month == DateTime.Now.Month) { number++; } } return(number); }
public ListStatisticsStatus GetStatisticsOfStatus(string listTitle) { ListItemLoader listItemLoader = new ListItemLoader(); var listItem = listItemLoader.GetAllListItem(listTitle, new List <string> { "Status", "Created" }); DateTime validfrom; int itemsInProgress = 0; int itemsSolved = 0; int itemsNew = 0; for (int i = 0; i < listItem.Count; i++) { validfrom = (DateTime)listItem[i]["Created"]; if (validfrom.Month == DateTime.Now.Month) { if (listItem[i].FieldValues.Values.Contains("In progress")) { itemsInProgress++; } if (listItem[i].FieldValues.Values.Contains("Solved")) { itemsSolved++; } if (listItem[i].FieldValues.Values.Contains("New")) { itemsNew++; } } } var status = new ListStatisticsStatus() { InProgress = itemsInProgress, New = itemsNew, Solved = itemsSolved }; return(status); }