public async Task <IActionResult> Edit(int id, [Bind("IdPlanAlim,Nome,MarcaAlim,Tipo,Temperatura,Racao,RacaoDia")] PlanoAlimentar planoAlimentar)
{
if (id != planoAlimentar.IdPlanAlim)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(planoAlimentar);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PlanoAlimentarExists(planoAlimentar.IdPlanAlim))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(planoAlimentar));
}
public ActionResult DeleteConfirmed(int id)
{
PlanoAlimentar PlanoAlimentar = db.PlanoAlimentar.Find(id);
db.PlanoAlimentar.Remove(PlanoAlimentar);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult <string> SetPlano([FromBody] dynamic rec)
{
lock (_system)
{
var jobject = JObject.Parse(JsonSerializer.Serialize(rec));
if (!_system.isUserOnline(jobject.valueST.ToString()))
{
return(Unauthorized("Client Offline"));
}
ActionResult <string> ret = BadRequest("Impossível inserir plano alimentar");
string email = jobject.GetValue("email");
JObject plano = jobject.GetValue("planoAlimentar");
List <Refeiçao> lista = new List <Refeiçao>();
JArray ja = plano.GetValue("lista_refeicoes").ToObject <JArray>();
try
{
if (email.Equals(""))
{
throw new Exception("EMAIL BROKEN");
}
foreach (JObject v in ja)
{
Refeiçao re = new Refeiçao(v.GetValue("nome").ToString(),
v.GetValue("descricao").ToString()
);
lista.Add(re);
}
PlanoAlimentar pa = new PlanoAlimentar(
email,
plano.GetValue("nome").ToString(),
plano.GetValue("frequencia").ToString(),
int.Parse(plano.GetValue("refeicoes_livres").ToString()),
DateTime.Parse(plano.GetValue("data_fim").ToString()),
lista
);
if (_system.AddPlanoAlimentar(pa))
{
ret = Ok();
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return(ret);
}
}
public ActionResult Edit([Bind(Include = "Id,Nome,Descricao,Usuario")] PlanoAlimentar PlanoAlimentar)
{
if (ModelState.IsValid)
{
db.Entry(PlanoAlimentar).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(PlanoAlimentar));
}
public ActionResult Edit([Bind(Include = "ID,ClienteID,Desjejum,Colacao,Almoco,LancheTarde,LancheTardeDois,Jantar,Ceia,CeiaDois,DataRegistro")] PlanoAlimentar planoAlimentar)
{
if (ModelState.IsValid)
{
db.Entry(planoAlimentar).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(planoAlimentar));
}
public async Task <IActionResult> Create([Bind("IdPlanAlim,Nome,MarcaAlim,Tipo,Temperatura,Racao,RacaoDia")] PlanoAlimentar planoAlimentar)
{
if (ModelState.IsValid)
{
_context.Add(planoAlimentar);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(planoAlimentar));
}
public ActionResult Create([Bind(Include = "Id,Nome,Descricao")] PlanoAlimentar PlanoAlimentar)
{
if (ModelState.IsValid)
{
PlanoAlimentar.Usuario = User.Identity.Name;
db.PlanoAlimentar.Add(PlanoAlimentar);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(PlanoAlimentar));
}
public ActionResult Create([Bind(Include = "pln_id,pln_datainicial,pln_datafinal,pla_plano,atl_id,nut_id")] PlanoAlimentar planoAlimentar)
{
if (ModelState.IsValid)
{
db.PlanoAlimentars.Add(planoAlimentar);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.atl_id = new SelectList(db.Atletas.Include(a => a.Pessoa), "atl_id", "Pessoa.pes_nome", planoAlimentar.atl_id);
ViewBag.nut_id = new SelectList(db.Nutricionistas.Include(a => a.Pessoa), "nut_id", "Pessoa.pes_nome", planoAlimentar.nut_id);
return(View(planoAlimentar));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PlanoAlimentar PlanoAlimentar = db.PlanoAlimentar.Find(id);
if (PlanoAlimentar == null)
{
return(HttpNotFound());
}
return(View(PlanoAlimentar));
}
private PlanoAlimentar setRelations(PlanoAlimentar t, int?id)
{
var regAlimentar = _context.RegAlimentar.Where(b => EF.Property <int>(b, "PlanoAlimentarIdPlanAlim") == id);
t.regAli = regAlimentar;
if (t.regAli.Any())
{
t.isDeletable = false;
}
else
{
t.isDeletable = true;
}
return(t);
}
// GET: PlanoAlimentares/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PlanoAlimentar planoAlimentar = db.PlanoAlimentars.Find(id);
if (planoAlimentar == null)
{
return(HttpNotFound());
}
ViewBag.atl_id = new SelectList(db.Atletas.Include(a => a.Pessoa), "atl_id", "Pessoa.pes_nome", planoAlimentar.atl_id);
ViewBag.nut_id = new SelectList(db.Nutricionistas.Include(a => a.Pessoa), "nut_id", "Pessoa.pes_nome", planoAlimentar.nut_id);
return(View(planoAlimentar));
}
public ActionResult PlanoPacienteIndex(int?id)
{
PlanoAlimentar PlanoAlimentar = db.PlanoAlimentar.Find(id);
if (PlanoAlimentar == null)
{
return(HttpNotFound());
}
List <PlanoPaciente> Pacientes = db.PlanoPaciente.Where(a => a.IdPlanoAlimentar == PlanoAlimentar.Id).ToList();
PlanoPacienteViewModel PlanoPacienteView = new PlanoPacienteViewModel
{
PlanoAlimentar = PlanoAlimentar,
Pacientes = Pacientes
};
return(View(PlanoPacienteView));
}
// GET: PlanoAlimentares/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PlanoAlimentar planoAlimentar = db.PlanoAlimentars.Find(id);
db.Entry(planoAlimentar).Reference(p => p.Atleta).Load();
db.Entry(planoAlimentar.Atleta).Reference(p => p.Pessoa).Load();
db.Entry(planoAlimentar).Reference(p => p.Nutricionista).Load();
db.Entry(planoAlimentar.Nutricionista).Reference(p => p.Pessoa).Load();
if (planoAlimentar == null)
{
return(HttpNotFound());
}
return(View(planoAlimentar));
}
public async Task <IActionResult> Create([Bind("IdPlanAlim,Nome,MarcaAlim,Tipo,Temperatura,Racao,RacaoDia")] PlanoAlimentar planoAlimentar)
{
if (planoAlimentar.RacaoDia < 0)
{
ModelState.AddModelError("RacaoDia", string.Format("Este valor tem de ser positivo", planoAlimentar.RacaoDia));
}
if (planoAlimentar.Racao < 0)
{
ModelState.AddModelError("Racao", string.Format("Este valor tem de ser positivo", planoAlimentar.Racao));
}
if (ModelState.IsValid)
{
_context.Add(planoAlimentar);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(planoAlimentar));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PlanoAlimentar PlanoAlimentar = db.PlanoAlimentar.Find(id);
if (PlanoAlimentar == null)
{
return(HttpNotFound());
}
List <ItemPlanoAlimentar> itensPlanoAlimentar = db.ItemPlanoAlimentar.Where(a => a.IdPlanoAlimentar == PlanoAlimentar.Id).ToList();
PlanoAlimentarViewModel PlanoAlimentarView = new PlanoAlimentarViewModel
{
PlanoAlimentar = PlanoAlimentar,
items = itensPlanoAlimentar
};
return(View(PlanoAlimentarView));
}
public ActionResult Index()
{
var cultureInfo = new System.Globalization.CultureInfo("pt-BR");
Thread.CurrentThread.CurrentCulture = cultureInfo;
Thread.CurrentThread.CurrentUICulture = cultureInfo;
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
int pes_id = Convert.ToInt32(Session["pes_id"]);
TimeSpan hora = DateTime.Now.TimeOfDay.Subtract(TimeSpan.FromHours(1));
PlanoAlimentar plano = db.PlanoAlimentars.Where(pln => pln.Atleta.pes_id == pes_id && DateTime.Today >= pln.pln_datainicial && DateTime.Today <= pln.pln_datafinal).FirstOrDefault();
Avaliacao avaliacao = db.Avaliacaos.Where(ava => ava.Atleta.pes_id == pes_id).OrderByDescending(ava => ava.ava_data).FirstOrDefault();
Treinamento treinamento = db.Treinamentoes.Where(tre => tre.Atleta.pes_id == pes_id && tre.tre_data > DateTime.Today || (tre.tre_hora >= hora && tre.tre_data == DateTime.Today)).Include(tre => tre.Assessor.Pessoa).OrderBy(tre => tre.tre_data).OrderBy(tre => tre.tre_hora).FirstOrDefault();
ViewBag.treinamento = treinamento;
ViewBag.plano = plano;
ViewBag.avaliacao = avaliacao;
return(View());
}
public List <PlanoAlimentar> GetPlanoAlimentar(string cliente_email)
{
List <PlanoAlimentar> planos = new List <PlanoAlimentar>();
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
string sqlCommand = "select idPlano_Alimentar from PlanoAlimentar_do_Cliente where Cliente_email = @CLIENTE_EMAIL";
MySqlCommand command = new MySqlCommand(sqlCommand, connection);
command.Parameters.Add("@CLIENTE_EMAIL", MySqlDbType.VarChar);
command.Parameters["@CLIENTE_EMAIL"].Value = cliente_email;
MySqlDataReader reader = command.ExecuteReader();
List <int> listaIdPlanos = new List <int>();
while (reader.Read())
{
listaIdPlanos.Add(reader.GetInt16(0));
}
reader.Close();
DateTime now = DateTime.Now.Date;
for (int i = 0; i < listaIdPlanos.Count; i++)
{
string sqlCommandPlanoAlimentar = "select * from Plano_Alimentar where idPlano_Alimentar = @ID and " +
"data_Fim > @DATA";
MySqlCommand commandPlanoAlimentar = new MySqlCommand(sqlCommandPlanoAlimentar, connection);
string sqlCommandRefeiçao = "select * from Refeiçao e left join Plano_Alimentar_Refeiçoes ept " +
"on e.idRefeiçao = ept.idRefeiçao where ept.idPlano_Alimentar = @ID";
MySqlCommand commandRefeiçao = new MySqlCommand(sqlCommandRefeiçao, connection);
commandPlanoAlimentar.Parameters.Add("@ID", MySqlDbType.Int16);
commandPlanoAlimentar.Parameters["@ID"].Value = listaIdPlanos[i];
commandPlanoAlimentar.Parameters.Add("@DATA", MySqlDbType.Date);
commandPlanoAlimentar.Parameters["@DATA"].Value = now;
reader = commandPlanoAlimentar.ExecuteReader();
reader.Read();
PlanoAlimentar pa = null;
if (reader.HasRows)
{
pa = new PlanoAlimentar(cliente_email, reader.GetString(1), reader.GetString(2),
reader.GetInt16(3), reader.GetDateTime(4), new List <Refeiçao>());
commandRefeiçao.Parameters.Add("@ID", MySqlDbType.Int16);
commandRefeiçao.Parameters["@ID"].Value = listaIdPlanos[i];
reader.Close();
reader = commandRefeiçao.ExecuteReader();
while (reader.HasRows && reader.Read())
{
Refeiçao r = new Refeiçao(reader.GetString(1), reader.GetString(2));
pa.refeiçoes.Add(r);
}
reader.Close();
}
reader.Close();
planos.Add(pa);
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
connection.Close();
}
return(planos);
}
public bool InsertPlanoAlimentar(PlanoAlimentar pa)
{
bool r = false;
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
string sqlCommand = "insert into Plano_Alimentar (nome, frequencia, refeiçoes_livres, data_Fim) " +
"values(" + pa.ToSql() + ")";
MySqlCommand command = new MySqlCommand(sqlCommand, connection);
pa.InitParam(command);
if (command.ExecuteNonQuery() > 0)
{
r = true;
}
command = new MySqlCommand("select LAST_INSERT_ID()", connection);
int idPlano_Alimentar = Convert.ToInt32(command.ExecuteScalar());
for (int i = 0; i < pa.refeiçoes.Count; i++)
{
sqlCommand = "insert into Refeiçao (nome, descriçao) values(" + pa.refeiçoes[i].ToSql() + ")";
command = new MySqlCommand(sqlCommand, connection);
pa.refeiçoes[i].InitParam(command);
command.ExecuteScalar();
command = new MySqlCommand("select LAST_INSERT_ID()", connection);
int idRefeiçao = Convert.ToInt32(command.ExecuteScalar());
sqlCommand = "insert into Plano_Alimentar_Refeiçoes values(@ID_PLANOALIMENTAR, @ID_REFEIÇAO)";
command = new MySqlCommand(sqlCommand, connection);
command.Parameters.Add("@ID_PLANOALIMENTAR", MySqlDbType.Int16);
command.Parameters["@ID_PLANOALIMENTAR"].Value = idPlano_Alimentar;
command.Parameters.Add("@ID_REFEIÇAO", MySqlDbType.Int16);
command.Parameters["@ID_REFEIÇAO"].Value = idRefeiçao;
command.ExecuteScalar();
}
sqlCommand = "insert into PlanoAlimentar_do_Cliente values(@ID, @CLIENTE_EMAIL)";
command = new MySqlCommand(sqlCommand, connection);
command.Parameters.Add("@ID", MySqlDbType.Int16);
command.Parameters["@ID"].Value = idPlano_Alimentar;
command.Parameters.Add("@CLIENTE_EMAIL", MySqlDbType.VarChar);
command.Parameters["@CLIENTE_EMAIL"].Value = pa.cliente_email;
// Verifica se foi atribuido o plano ao cliente
if (command.ExecuteNonQuery() > 0)
{
r = true;
}
else
{
r = false;
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
finally
{
connection.Close();
}
return(r);
}
