Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. public class CallbackModel : SharedModel
  2. {
  3. public CallbackModel() : base()
  4. {
  5.  
  6. }
  7.  
  8. public List<Callback> getData(DateTime start, DateTime end)
  9. {
  10.  
  11. StringBuilder query = new StringBuilder();
  12. query.Append("SELECT LAST_UPD AS PERIOD, ");
  13. query.Append("COUNT(CASE WHEN STATUS ='Færdig' THEN 1 END) as completed, ");
  14. query.Append("COUNT(CASE WHEN SOLVED_SECONDS /60 /60 <= 2 THEN 1 END) as completed_within_2hours ");
  15. query.Append("FROM KS_DRIFT.NYK_SIEBEL_CALLBACK_AGENT_H_V ");
  16. query.Append("WHERE LAST_UPD BETWEEN '" + start.ToString("yyyy-MM-dd") + "' AND '" + end.ToString("yyyy-MM-dd") + "' ");
  17. query.Append("AND STATUS ='Færdig' ");
  18. query.Append("GROUP BY LAST_UPD ORDER BY LAST_UPD ASC");
  19. var session = sessionFactory.OpenSession();
  20. var result = session.CreateSQLQuery(query.ToString())
  21. .AddEntity(typeof(Callback))
  22. .List<Callback>();
  23.  
  24. return result;
  25. }
  26. }
  27.  
  28. Error 19 Cannot implicitly convert type 'System.Collections.Generic.IList<Henvendelser.Objects.Callback>' to 'System.Collections.Generic.List<Henvendelser.Objects.Callback>'. An explicit conversion exists (are you missing a cast?)
  29.  
  30. public IList<Callback> getData(DateTime start, DateTime end)
  31. {
  32. // your code here
  33. }
  34.  
  35. return result.ToList();
  36.  
  37. return (List<Callback>)result;
  38.  
  39. List<Callback>();
  40.  
  41. to
  42.  
  43. ToList();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement