public ActionResult Create([Bind(Include = "BeanID,Image,Name,Protein,Carbohydrates,Fat,Energy")] Bean bean) { if (ModelState.IsValid) { db.Beans.Add(bean); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bean)); }
public ActionResult Create([Bind(Include = "Id,Nome,ValorConsulta")] Especialidade especialidade) { if (ModelState.IsValid) { db.Especialidades.Add(especialidade); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(especialidade)); }
public ActionResult Create([Bind(Include = "FruitID,Image,Name,Protein,Carbohydrates,Fat,Energy")] Fruit fruit) { if (ModelState.IsValid) { db.Fruits.Add(fruit); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fruit)); }
public ActionResult Create([Bind(Include = "ID,Image,Name,Group")] Food food) { if (ModelState.IsValid) { db.Foods.Add(food); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(food)); }
public ActionResult Create([Bind(Include = "MeatFishEggID,Image,Name,Protein,Carbohydrates,Fat,Energy")] MeatFishEgg meatFishEgg) { if (ModelState.IsValid) { db.MeatFishEggs.Add(meatFishEgg); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(meatFishEgg)); }
public ActionResult Create([Bind(Include = "Id,Nome,Modelo")] ModeloAnamnese modeloAnamnese) { if (ModelState.IsValid) { db.ModelosAnamneses.Add(modeloAnamnese); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(modeloAnamnese)); }
public ActionResult Create([Bind(Include = "Id,Nome,Valor")] Procedimento procedimento) { if (ModelState.IsValid) { db.Procedimentos.Add(procedimento); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(procedimento)); }
public ActionResult Create([Bind(Include = "Id,Nome")] FormaPagamento formaPagamento) { if (ModelState.IsValid) { db.FormasPagamento.Add(formaPagamento); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(formaPagamento)); }
public ActionResult Create([Bind(Include = "VegetableID,Image,Name,Protein,Carbohydrates,Fat,Energy")] Vegetable vegetable) { if (ModelState.IsValid) { db.Vegetables.Add(vegetable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(vegetable)); }
public async Task UpsertAsync(IEnumerable <Weight> weights) { for (int i = 0; i < weights.Count(); i += 500) { await _healthContext .UpsertRange(weights.Skip(i).Take(500)) .RunAsync(); _healthContext.SaveChanges(); } }
public TargetAppDto Add(CreateTargetAppDto registerDto) { if (!registerDto.Url.IsValidUrl()) { throw new Exception("Invalid Url Please Check"); } var app = Mapper.MapToAppFromCreateDto(registerDto); _db.TargetApps.Add(app); _db.SaveChanges(); var created = Mapper.MapToAppDto(app); _jobScheduler.AddOrUpdate(created); return(created); }
public ActionResult Create([Bind(Include = "Id,Nome,Cpf,DataNascimento,DataCadastro,ComoConheceu,Cidade,Bairro,Rua,NumeroResidencia,NumeroTelefone,NumeroCelular,Email,NumeroCarteiraPlano")] PacienteViewModel pacienteViewModel) { if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { var endereco = new Endereco(); endereco.Cidade = pacienteViewModel.Cidade; endereco.Bairro = pacienteViewModel.Bairro; endereco.Rua = pacienteViewModel.Rua; endereco.Numero = pacienteViewModel.NumeroResidencia; db.Enderecos.Add(endereco); var telefone = new Telefone(); telefone.Numero = pacienteViewModel.NumeroTelefone; db.Telefones.Add(telefone); var celular = new Telefone(); celular.Numero = pacienteViewModel.NumeroCelular; db.Telefones.Add(celular); db.SaveChanges(); var paciente = new Paciente(); paciente.Nome = pacienteViewModel.Nome; paciente.Cpf = pacienteViewModel.Cpf; paciente.DataNascimento = pacienteViewModel.DataNascimento; paciente.DataCadastro = pacienteViewModel.DataCadastro; paciente.ComoConheceu = pacienteViewModel.ComoConheceu; paciente.Email = pacienteViewModel.Email; paciente.NumeroCarteiraPlano = pacienteViewModel.NumeroCarteiraPlano; paciente.EnderecoId = endereco.Id; paciente.TelefoneId = telefone.Id; paciente.CelularId = celular.Id; db.Pacientes.Add(paciente); db.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); } } return(RedirectToAction("Index")); } return(View(pacienteViewModel)); }
private static void AddAppointment(HealthContext context, Doctor doctor, Patient patient, DateTime appointmentDate) { Appointment appointment = new Appointment(); appointment.DoctorId = doctor.Id; appointment.PatientId = patient.Id; appointment.AppointmentDate = appointmentDate; appointment.Status = "Confirmed"; context.Appointments.Add(appointment); context.SaveChanges(); }
public ActionResult Create([Bind(Include = "Id,Name,HashValue,IsMedical")] Usuario usuario) { if (ModelState.IsValid) { var previous = db.Usuarios.Where(x => x.Name.ToUpper() == usuario.Name.ToUpper()).FirstOrDefault(); if (previous == null) { usuario.HashValue = HashUtil.ComputeHash(usuario.HashValue, null); db.Usuarios.Add(usuario); db.SaveChanges(); } else { ViewBag.Message = "Usuário já existe!"; ViewBag.StyleClass = "alert alert-danger"; return(View("Index")); } return(RedirectToAction("Index")); } return(View(usuario)); }
public void TestEfInMemoryAppCountForUser() { var options = new DbContextOptionsBuilder <HealthContext>().UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString() + "HealthCheckTestDB").Options; using (var context = new HealthContext(options)) { AddSeedTestData(context); context.SaveChanges(); var count = context.TargetApps.Where(x => x.CreatedById == 1).Count(); Assert.AreEqual(2, count, "Kullnıcı 1'in 2 app'i olması gerekir."); } }
public UserDto Register(UserRegisterDto registerDto) { var user = _db.Users.Where(x => x.Username == registerDto.Username).FirstOrDefault(); if (user != null) { throw new Exception("This username in use"); } ; user = Mapper.MapToUserFromRegister(registerDto, _appSettings.Secret); _db.Users.Add(user); _db.SaveChanges(); return(Mapper.MapToUserDto(user)); }
public IActionResult UpdateUser(int id, [FromBody] UserDTO user) { UserDTO userDTO = new UserDTO(); if (user == null || id == 0) { BadRequest(); } try { var existantUser = _context.Patients.FirstOrDefault(u => u.Id == id); if (existantUser == null) { return(NotFound()); } //TO DO.USE A DELTA existantUser.PhoneNumber = user.PhoneNumber; existantUser.Location = user.Location; existantUser.InsuranceName = user.InsuranceName; existantUser.Email = user.Email; existantUser.BirthDate = user.BirthDate; _context.Patients.Update(existantUser); int valuesSaved = _context.SaveChanges(); if (valuesSaved > 0) { IEnumerable <Appointment> appointments = _context.Appointments.Where(x => x.PatientId == existantUser.Id).ToList(); IEnumerable <int> sicknessIds = _context.PatientSicknesses.Where(x => x.PatientId == existantUser.Id).Select(x => x.SicknessId); IEnumerable <Sickness> sicknesses = _context.Sicknesses.Where(x => sicknessIds.Contains(x.Id)).ToList(); userDTO = mapUserDto(existantUser, sicknesses, appointments); return(Ok(userDTO)); } else { return(BadRequest()); } } catch (Exception ex) { return(BadRequest()); } }
public TargetAppDto MarkAsChecked(UpdateChecksStatusDto checkStatus) { var app = _db.TargetApps.FirstOrDefault(c => c.Id == checkStatus.Id); if (app == null) { return(null); } app.IsAlive = checkStatus.IsAlive; app.LastCheck = checkStatus.CheckDate; _db.SaveChanges(); return(new TargetAppDto { Id = app.Id, Url = app.Url, Name = app.Name }); }
public async Task UpsertToken(string tokenName, string tokenValue) { var existingToken = await _healthContext.Tokens.FindAsync(tokenName); if (existingToken != null) { existingToken.Value = tokenValue; } else { _healthContext.Add(new Token { Name = tokenName, Value = tokenValue }); } _healthContext.SaveChanges(); }
private static void AddDoctors(HealthContext context) { context.Doctors.Add(new Doctor() { FirstName = "Doctor 1", LastName = "Doctor 1", Email = "*****@*****.**", Mobile = "500001" }); context.Doctors.Add(new Doctor() { FirstName = "Doctor 2", LastName = "Doctor 2", Email = "*****@*****.**", Mobile = "500002" }); context.Doctors.Add(new Doctor() { FirstName = "Doctor 3", LastName = "Doctor 3", Email = "*****@*****.**", Mobile = "500003" }); context.Doctors.Add(new Doctor() { FirstName = "Doctor 4", LastName = "Doctor 4", Email = "*****@*****.**", Mobile = "500004" }); context.SaveChanges(); }
private static void AddPatients(HealthContext context) { context.Patients.Add(new Patient() { FirstName = "Patient 1", LastName = "Patient 1", Email = "*****@*****.**", Mobile = "300001" }); context.Patients.Add(new Patient() { FirstName = "Patient 2", LastName = "Patient 2", Email = "*****@*****.**", Mobile = "300002" }); context.Patients.Add(new Patient() { FirstName = "Patient 3", LastName = "Patient 3", Email = "*****@*****.**", Mobile = "300003" }); context.Patients.Add(new Patient() { FirstName = "Patient 4", LastName = "Patient 4", Email = "*****@*****.**", Mobile = "300004" }); context.SaveChanges(); }
public static void AddSeedTestData(HealthContext context) { context.Users.Add(new User { Id = 1, Username = "******", Name = "Enver Gökmen", Email = "*****@*****.**", Gsm = "5069516750", NotificationPreference = NotificationType.Email }); context.Users.Add(new User { Id = 2, Username = "******", Name = "Diger Kullanıcı", Email = "*****@*****.**", Gsm = "5069516750", NotificationPreference = NotificationType.Sms }); //user1's apps context.TargetApps.Add(new TargetApp { Id = 1, Name = "google", Url = "https://www.google.com", CreatedById = 1, IntervalType = IntervalType.Minutely, IntervalValue = 1 }); context.TargetApps.Add(new TargetApp { Id = 2, Name = "twitter", Url = "https://www.twitter.com", CreatedById = 1, IntervalType = IntervalType.Minutely, IntervalValue = 1 }); //users 2's apps context.TargetApps.Add(new TargetApp { Id = 3, Name = "facebook", Url = "https://www.facebook.com", CreatedById = 2, IntervalType = IntervalType.Minutely, IntervalValue = 1 }); context.SaveChanges(); }
public ActionResult Create([Bind(Include = "Id,Date,Hora,Minuto,EspecialidadeId,EspecialistaId," + "PacienteId,Observacao,ValorPago,FormaPagamentoId,Tratamento")] ConsultaViewModel consultaViewModel, [Bind(Include = "Cpf,Nome,DataNascimento")] Paciente formPaciente, string cidade, string bairro, string rua, string numero, string telefone, HttpPostedFileBase file) { if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { string path = ""; try { var paciente = db.Pacientes.Where(x => x.Cpf == formPaciente.Cpf).FirstOrDefault(); if (paciente == null || string.IsNullOrEmpty(formPaciente.Cpf)) { var lvtelefone = new Telefone(); lvtelefone.Numero = telefone; db.Telefones.Add(lvtelefone); db.SaveChanges(); var endereco = new Endereco(); endereco.Cidade = cidade; endereco.Bairro = bairro; endereco.Rua = rua; endereco.Numero = numero; db.Enderecos.Add(endereco); db.SaveChanges(); paciente = new Paciente(); paciente.Nome = formPaciente.Nome; paciente.DataNascimento = formPaciente.DataNascimento; paciente.DataCadastro = DateTime.Now; paciente.Cpf = formPaciente.Cpf; paciente.TelefoneId = lvtelefone.Id; paciente.EnderecoId = endereco.Id; db.Pacientes.Add(paciente); db.SaveChanges(); } Arquivo arquivo = new Arquivo(); arquivo.OriginalName = ""; arquivo.Path = "#"; db.Arquivos.Add(arquivo); db.SaveChanges(); var consulta = new Consulta(); consulta.Date = consultaViewModel.Date; consulta.Hora = consultaViewModel.Hora; consulta.Minuto = consultaViewModel.Minuto; consulta.EspecialidadeId = consultaViewModel.EspecialidadeId; consulta.EspecialistaId = consultaViewModel.EspecialistaId; consulta.PacienteId = paciente.Id; consulta.Observacao = consultaViewModel.Observacao; consulta.ValorPago = consultaViewModel.ValorPago; consulta.ArquivoId = arquivo.Id; consulta.AtendimentoRealizado = false; consulta.Tratamento = consultaViewModel.Tratamento; db.Consultas.Add(consulta); db.SaveChanges(); var atendimentoArquivo = new AtendimentoArquivo(); atendimentoArquivo.ArquivoId = arquivo.Id; atendimentoArquivo.Tipo = "Consulta"; atendimentoArquivo.AtendimentoId = consulta.Id; db.AtendimentoArquivo.Add(atendimentoArquivo); db.SaveChanges(); if (file != null) { path = Path.Combine(@Server.MapPath(@"~\Files\Clientes"), string.Format("c_{0}_{1}", consulta.Id, file.FileName)); file.SaveAs(path); arquivo.Path = path; arquivo.OriginalName = file.FileName; } if (consultaViewModel.FormaPagamentoId != -1) { db.PagamentosConsultas.Add(new PagamentoConsulta() { ConsultaId = consulta.Id, FormaPagamentoId = consultaViewModel.FormaPagamentoId }); } db.SaveChanges(); transaction.Commit(); } catch (Exception e) { DebugLog.Logar(e.Message); DebugLog.Logar(e.StackTrace); DebugLog.Logar(Utility.Details(e)); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } transaction.Rollback(); } } return(RedirectToAction("Index")); } var paymentWays = db.FormasPagamento.ToList(); paymentWays.Insert(0, new FormaPagamento() { Id = -1, Nome = "-" }); ViewBag.EspecialidadeId = new SelectList(db.Especialidades, "Id", "Nome", consultaViewModel.EspecialidadeId); ViewBag.EspecialistaId = new SelectList(db.Especialistas, "Id", "Nome", consultaViewModel.EspecialistaId); ViewBag.FormaPagamentoId = new SelectList(paymentWays, "Id", "Nome", consultaViewModel.FormaPagamentoId); ViewBag.PacienteId = new SelectList(db.Pacientes, "Id", "Nome", consultaViewModel.PacienteId); ViewBag.Hora = GetListHour(); ViewBag.Minuto = GetListMinute(); return(View(consultaViewModel)); }
public bool Save() { return(_healthContext.SaveChanges() > 1); }
public ActionResult Create([Bind(Include = "Id,Nome,Crm,ConselhoUF,EspecialidadeId,Especialidade," + "DataNascimento,Email,Rua,Bairro,Cidade,Numero,Telefone," + "AtendeSegunda,AtendeTerca,AtendeQuarta,AtendeQuinta,AtendeSexta,AtendeSabado,AtendeDomingo," + "HoraInicial,MinutoInicial,HoraFinal,MinutoFinal")] EspecialistaViewModel especialistaViewModel) { if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { /* Telefone */ var telefone = new Telefone(); telefone.Numero = especialistaViewModel.Telefone; db.Telefones.Add(telefone); /* Endereço */ var endereco = new Endereco(); endereco.Bairro = especialistaViewModel.Bairro; endereco.Cidade = especialistaViewModel.Cidade; endereco.Rua = especialistaViewModel.Rua; endereco.Numero = especialistaViewModel.Numero; db.Enderecos.Add(endereco); db.SaveChanges(); /*Dias de Atendimento*/ var diasAtendimento = new DiasAtendimento(); diasAtendimento.AtendeSegunda = especialistaViewModel.AtendeSegunda; diasAtendimento.AtendeTerca = especialistaViewModel.AtendeTerca; diasAtendimento.AtendeQuarta = especialistaViewModel.AtendeQuarta; diasAtendimento.AtendeQuinta = especialistaViewModel.AtendeQuinta; diasAtendimento.AtendeSexta = especialistaViewModel.AtendeSexta; diasAtendimento.AtendeSabado = especialistaViewModel.AtendeSabado; diasAtendimento.AtendeDomingo = especialistaViewModel.AtendeDomingo; db.DiasAtendimentos.Add(diasAtendimento); db.SaveChanges(); /* Especialista */ var especialista = new Especialista(); especialista.Nome = especialistaViewModel.Nome; especialista.Crm = especialistaViewModel.Crm; especialista.Email = especialistaViewModel.Email; especialista.ConselhoUF = especialistaViewModel.ConselhoUF; especialista.EnderecoId = endereco.Id; especialista.TelefoneId = telefone.Id; especialista.DiasAtendimentoId = diasAtendimento.Id; especialista.DataNascimento = especialistaViewModel.DataNascimento; especialista.HoraInicial = especialistaViewModel.HoraInicial; especialista.MinutoInicial = especialistaViewModel.MinutoInicial; especialista.HoraFinal = especialistaViewModel.HoraFinal; especialista.MinutoFinal = especialistaViewModel.MinutoFinal; db.Especialistas.Add(especialista); db.SaveChanges(); /* EspecialistaEspecialidade */ var especialistaEspecialidade = new EspecialistaEspecialidade(); especialistaEspecialidade.EspecialistaId = especialista.Id; especialistaEspecialidade.EspecialidadeId = especialistaViewModel.EspecialidadeId; db.EspecialistasEspecialidades.Add(especialistaEspecialidade); db.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); } } return(RedirectToAction("Index")); } return(View(especialistaViewModel)); }