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