Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class CallbackModel : SharedModel
- {
- public CallbackModel() : base()
- {
- }
- public List<Callback> getData(DateTime start, DateTime end)
- {
- StringBuilder query = new StringBuilder();
- query.Append("SELECT LAST_UPD AS PERIOD, ");
- query.Append("COUNT(CASE WHEN STATUS ='Færdig' THEN 1 END) as completed, ");
- query.Append("COUNT(CASE WHEN SOLVED_SECONDS /60 /60 <= 2 THEN 1 END) as completed_within_2hours ");
- query.Append("FROM KS_DRIFT.NYK_SIEBEL_CALLBACK_AGENT_H_V ");
- query.Append("WHERE LAST_UPD BETWEEN '" + start.ToString("yyyy-MM-dd") + "' AND '" + end.ToString("yyyy-MM-dd") + "' ");
- query.Append("AND STATUS ='Færdig' ");
- query.Append("GROUP BY LAST_UPD ORDER BY LAST_UPD ASC");
- var session = sessionFactory.OpenSession();
- var result = session.CreateSQLQuery(query.ToString())
- .AddEntity(typeof(Callback))
- .List<Callback>();
- return result;
- }
- }
- 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?)
- public IList<Callback> getData(DateTime start, DateTime end)
- {
- // your code here
- }
- return result.ToList();
- return (List<Callback>)result;
- List<Callback>();
- to
- ToList();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement