Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "2014-12-22": { "url" : "link curso" },
- "2014-12-26": { "url" : "url do curso"},
- "2015-01-12": { "url" : "link deste curso"}
- {
- "data": "29-12-2014",
- "url": "gestao-agropecuaria"
- },
- {
- "data": "26-12-2014",
- "url": "producao-animal"
- },
- {
- "data": "06-01-2015",
- "url": "teste"
- }
- public IHttpActionResult Get()
- {
- var events = new Admin.AppClass.Agenda();
- return Ok(events.ListarDatasCalendario());
- }
- public DataTable ListarDatasCalendario()
- {
- Mysql mysql = new Mysql();
- try
- {
- return mysql.ExecutarComando(@" SELECT DATE_FORMAT(a.data, '%d-%m-%Y') as data,
- c.nome as url
- FROM agenda a, cursos c
- WHERE a.curso = c.id
- ORDER BY data DESC");
- }
- catch (Exception)
- {
- throw;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement