public bool UpdateTicketSolved(User userItem, Ticket ticketItem)
{
using (var db = new TechnicalSupportEntities())
{
try
{
var SelectedTicket = (from ticket in db.Ticket
where ticket.TicketID == ticketItem.TicketID
select ticket).FirstOrDefault();
SelectedTicket.Solved = true;
SelectedTicket.SolvedBy = userItem.UserName;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public ObservableCollection <Ticket> SelectMostTicketSolvedUsers()
{
using (var db = new TechnicalSupportEntities())
{
return(null);
}
}
public ObservableCollection <DataAccessLayer.Models.MostTicketSolvedUser> SelectMostTicketSolvedUsers()
{
var returnCollelction = new ObservableCollection <DataAccessLayer.Models.MostTicketSolvedUser>();
using (var db = new TechnicalSupportEntities())
{
var users = from ticket in db.Ticket
where ticket.Solved == true && ticket.SolvedBy != null
group ticket by ticket.SolvedBy into usr
orderby usr.Count() descending
select new { UserName = usr.Key, TotalTickets = usr.Count() };
foreach (var item in users)
{
returnCollelction.Add(new Models.MostTicketSolvedUser()
{
UserName = item.UserName,
TotalSolvedTickets = item.TotalTickets
});
}
return(returnCollelction);
}
}
public ObservableCollection <DataAccessLayer.Ticket> SelectAll()
{
using (var db = new TechnicalSupportEntities())
{
var Tickets = from tickets in db.Ticket
select tickets;
return(new ObservableCollection <Ticket>(Tickets));
}
}
public User UserAuthentication(User item)
{
using (var db = new TechnicalSupportEntities())
{
var result = db.User.Where(x => x.UserName == item.UserName && x.UserPassword == item.UserPassword).FirstOrDefault();
if (result != null)
{
return(result);
}
else
{
return(null);
}
}
}
public bool InsertNew(Ticket item)
{
using (var db = new TechnicalSupportEntities())
{
item.Solved = false;
item.TimeCreated = DateTime.Now;
db.Ticket.Add(item);
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
}