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));
}
