public HttpResponseMessage ListarAgenda([FromBody]JObject model) { try { dynamic json = model["Funcionario"]; int idFuncionario = 0; int ano = json.ano, mes = json.mes, dia = json.dia; //DateTime data = new DateTime(ano, mes+1, dia); idFuncionario = json.idEmpresaCliente; List<Agenda> agendaProfissional = new List<Agenda>(); DBContext db = new DBContext(); var query = from a in db.Agenda where a.idEmpresaCliente == idFuncionario && a.horarioAgenda.Year == ano && a.horarioAgenda.Month == mes + 1 && a.horarioAgenda.Day == dia select a; foreach (Agenda a in query) { agendaProfissional.Add(a); } return Request.CreateResponse(HttpStatusCode.OK, agendaProfissional); } catch (Exception ex) { return Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message); } }
public HttpResponseMessage CadastroCategoria(Categoria c) { try { using (DBContext db = new DBContext()) { db.Database.CreateIfNotExists(); db.Categoria.Add(c); db.SaveChanges(); } return Request.CreateResponse(HttpStatusCode.OK, "Cadastro da categoria " + c.nomeCategoria + " realizado."); } catch (Exception ex) { return Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message); } }
public HttpResponseMessage ListarCategorias([FromBody]JObject model) { try { List<Categoria> categorias = new List<Categoria>(); using(DBContext db = new DBContext()) { db.Database.CreateIfNotExists(); var query = from c in db.Categoria select c; foreach (Categoria cat in query) { categorias.Add(cat); } } return Request.CreateResponse(HttpStatusCode.OK, categorias); } catch (Exception ex) { return Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message); } }
public static Usuario VerificarUsuario(string password, int user) { try { var usuario = new Usuario(); using (DBContext db = new DBContext()) { var pass = Decrypt(password); var query = from u in db.Usuario where u.idUsuario == user && u.senhaUsuario == pass select u; foreach (Usuario u in query) { usuario = u; } } return usuario; }catch(Exception) { return null; } }
public HttpResponseMessage CadastroEmpresa([FromBody]JObject model) { try { dynamic json = model["Horario"]; var idUsuario = 0; var idCliente = 0; string dataServico = json.dataServico; idUsuario = json.idUsuario; DBContext db = new DBContext(); var query = from user in db.Usuario where user.idUsuario == idUsuario select user.idCliente; foreach (var x in query) { idCliente = x; } ClienteServico cs = new ClienteServico() { dataServico = Convert.ToDateTime(json.dataServico), idEmpresaClienteServico = json.idEmpresaCliente, valorServico = json.valorServico, idCliente = idCliente }; db.Database.CreateIfNotExists(); db.ClienteServico.Add(cs); db.SaveChanges(); return Request.CreateResponse(HttpStatusCode.OK, "Cadastro realizado."); } catch (Exception ex) { return Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message); } }