Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2014
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. "2014-12-22": { "url" : "link curso" },
  2. "2014-12-26": { "url" : "url do curso"},
  3. "2015-01-12": { "url" : "link deste curso"}
  4.  
  5. {
  6. "data": "29-12-2014",
  7. "url": "gestao-agropecuaria"
  8. },
  9. {
  10. "data": "26-12-2014",
  11. "url": "producao-animal"
  12. },
  13. {
  14. "data": "06-01-2015",
  15. "url": "teste"
  16. }
  17.  
  18. public IHttpActionResult Get()
  19. {
  20. var events = new Admin.AppClass.Agenda();
  21. return Ok(events.ListarDatasCalendario());
  22. }
  23.  
  24.  
  25.  
  26. public DataTable ListarDatasCalendario()
  27. {
  28. Mysql mysql = new Mysql();
  29.  
  30. try
  31. {
  32.  
  33. return mysql.ExecutarComando(@" SELECT DATE_FORMAT(a.data, '%d-%m-%Y') as data,
  34. c.nome as url
  35. FROM agenda a, cursos c
  36. WHERE a.curso = c.id
  37. ORDER BY data DESC");
  38.  
  39. }
  40. catch (Exception)
  41. {
  42. throw;
  43. }
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement