public async Task <ActionResult> DeleteConfirmed(int id)
{
fichas_medicas fichas_medicas = await db.fichas_medicas.FindAsync(id);
db.fichas_medicas.Remove(fichas_medicas);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
// GET: FichasMedicas/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
fichas_medicas fichas_medicas = await db.fichas_medicas.FindAsync(id);
if (fichas_medicas == null)
{
return(HttpNotFound());
}
return(View(fichas_medicas));
}
public async Task <ActionResult> Create(int clientId, CardioInfo cardioInfo)
{
if (ModelState.IsValid)
{
fichas_medicas fm = db.fichas_medicas.Where(m => m.cliente_id == clientId).Include(m => m.cardio).OrderByDescending(m => m.created_at).FirstOrDefault();
fm.cardio.Add(cardioInfo);
fm.updated_at = Utilities.CurrentDate.getNow();
db.Entry(fm).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index", new { clientId = clientId }));
}
return(View(cardioInfo));
}
public async Task <ActionResult> Global(int id)
{
int daysInMonth = DateTime.DaysInMonth(CurrentDate.getNow().Year, CurrentDate.getNow().Month);
DateTime today = CurrentDate.getNow();
DateTime firstDay = new DateTime(today.Year, today.Month, 1);
DateTime lastDay = new DateTime(today.Year, today.Month, daysInMonth);
// Info General
clientes client = await db.clientes
.Where(m => m.id_alt == id)
.Include(m => m.nutricionistas.usuarios)
.FirstOrDefaultAsync();
// Info Programa
programa_clientes program = await db.programa_clientes
.Where(m => m.cliente_id == client.id_alt && m.fecha_inicio <= today && m.fecha_fin >= today)
.Include(m => m.programa)
.Include(m => m.horario.sala.local)
.OrderBy(m => m.fecha_fin)
.FirstOrDefaultAsync();
ViewBag.ProgramId = program != null?program.id.ToString() : "";
ViewBag.ProgramName = program != null ? program.programa.nombre : "";
ViewBag.ProgramInitDate = program != null?program.fecha_inicio.ToShortDateString() : "";
ViewBag.ProgramEndDate = program != null?program.fecha_fin.ToShortDateString() : "";
ViewBag.ProgramSchedule = program != null?program.horario.hora.ToString() : "";
ViewBag.Gym = program != null ? program.horario.sala.local.nombre : "";
// Info Notas del cliente
List <clientes_notas> notes = await db.clientes_notas.Where(n => n.idCliente == id).OrderByDescending(n => n.created_at).Take(15).ToListAsync();
ViewBag.ClientNotes = notes;
//// Info Calendario.
//List<pesos_medidas> clientPyM = await db.pesos_medidas.Where(m => m.clienteId == id && m.created_at >= firstDay && m.created_at <= lastDay).ToListAsync();
//List<clientes_asistencia> clientAssistance = await db.clientes_asistencia.Where(m => m.clienteId == id && m.fecha >= firstDay && m.fecha <= lastDay).ToListAsync();
//List<clientes_congelamientos> clientFreezing = await db.clientes_congelamientos.Where(m => m.clienteId == id && m.fecha_desde >= firstDay).ToListAsync();
//List<citas> clientConsults = await db.citas.Where(m => m.cliente_id == id && m.fecha >= firstDay && m.fecha <= lastDay).ToListAsync();
// Info Nutricion.
ViewBag.AssignedNutritionist = client.nutricionistas.usuarios.nombres + " " + client.nutricionistas.usuarios.apellidos;
if (program != null)
{
// Info Ficha Medica
fichas_medicas medicalHistory = await db.fichas_medicas.Where(m => m.programa_id == program.id).Include(m => m.cardio).FirstOrDefaultAsync();
ViewBag.MedicalId = "No ha sido creada.";
ViewBag.Cardio = "No se han ingresado datos.";
if (medicalHistory != null)
{
int clientCurrMedicalHistoryIdCode = 10000000 + medicalHistory.id;
ViewBag.MedicalId = clientCurrMedicalHistoryIdCode.ToString("FS#");
if (medicalHistory.cardio != null)
{
CardioInfo lastCardioResults = medicalHistory.cardio.OrderByDescending(m => m.fecha).FirstOrDefault();
if (lastCardioResults.cardiologia_aprobacion == CardioSuittable.Apto)
{
ViewBag.Cardio = CardioSuittable.Apto.ToString();
}
else
{
ViewBag.Cardio = CardioSuittable.NoApto.ToString();
}
}
}
// Info Dieta
clientes_dietas clientDiet = await db.clientes_dietas.Where(m => m.programa_clientes_id == program.id).OrderByDescending(m => m.created_at).FirstOrDefaultAsync();
if (clientDiet != null)
{
int dietCode = 10000000 + clientDiet.id;
ViewBag.DietCode = dietCode.ToString("D#");
}
}
// Info Ventas
venta_usuarios usrSales = await db.venta_usuarios
.Where(m => m.cliente_id == client.id_alt)
.OrderByDescending(m => m.created_at)
.FirstOrDefaultAsync();
if (usrSales != null)
{
usuarios usr = await db.vendedores.Where(v => v.usuario_id == usrSales.vendedor_id).Include(v => v.usuarios).Select(v => v.usuarios).FirstOrDefaultAsync();
ViewBag.Seller = usr.nombres + " " + usr.apellidos;
ViewBag.LastTicket = usrSales.numero_boleta;
ViewBag.LastRenewal = usrSales.fecha_inicio.ToShortDateString();
semanas_precios weeks = db.semanas_precios.Where(s => s.id == usrSales.semanas_precio_id).FirstOrDefault();
int boughtWeeks = weeks.cantidad_semanas;
ViewBag.BoughtWeeks = boughtWeeks.ToString();
int usedWeeks = await GetUsedWeeks(ClientId : client.id_alt, LastSaleId : usrSales.id);
ViewBag.UsedWeeks = usedWeeks;
ViewBag.PendingWeeks = boughtWeeks - usedWeeks;
}
//ViewBag.venta_usuario = db.venta_usuarios.Where(vu => vu.cliente_id == id).FirstOrDefault();
//ViewBag.programa_cliente = db.programa_clientes.Where(pc => pc.cliente_id == id).FirstOrDefault();
//ViewBag.calPyM = clientPyM;
//ViewBag.calAsist = clientAssistance;
//ViewBag.calFrz = clientFreezing;
//ViewBag.calCitas = clientConsults;
//
//ViewBag.cardioApt = cardioApt;
//ViewBag.foto = Convert.ToBase64String(cliente.foto);
return(View(client));
}
// GET: FichasMedicas/Create
public ActionResult Create(int clienteId)
{
clientes cl = db.clientes.Where(c => c.id_alt == clienteId).FirstOrDefault();
DateTime today = CurrentDate.getNow();
programa_clientes prgCl = db.programa_clientes.Where(m => m.cliente_id == cl.id_alt && m.fecha_inicio <= today && m.fecha_fin >= today).FirstOrDefault();
fichas_medicas fm = db.fichas_medicas.Where(m => m.cliente_id == cl.id_alt).Include(m => m.controles).Include(m => m.regimen_alimentacion).Include(m => m.cardio).Include(m => m.laboratorio).OrderByDescending(m => m.created_at).FirstOrDefault();
ViewBag.currentCardioControl = null;
if (fm != null && fm.cardio.Count > 0)
{
CardioInfo lastCardioInfoInserted = fm.cardio.OrderByDescending(m => m.fecha).First();
TimeSpan dateDif = CurrentDate.getNow().Subtract(lastCardioInfoInserted.fecha);
if (dateDif <= new TimeSpan(180, 0, 0, 0))
{
ViewBag.currentCardioControl = lastCardioInfoInserted;
}
}
ViewBag.currentLabControl = null;
if (fm != null && fm.laboratorio.Count > 0)
{
LabResults lastLabInfoInserted = fm.laboratorio.OrderByDescending(m => m.fecha).First();
TimeSpan dateDif = CurrentDate.getNow().Subtract(lastLabInfoInserted.fecha);
if (dateDif <= new TimeSpan(180, 0, 0, 0))
{
ViewBag.currentLabControl = lastLabInfoInserted;
}
}
if (fm != null && fm.controles.Count > 0)
{
List <ControlesNutricionales> cn = fm.controles;
List <string> cnRows = new List <string>();
foreach (ControlesNutricionales c in cn)
{
string row = GetNutritionalControlString(c: c);
cnRows.Add(row);
controlsCount++;
}
controlsCount = 0;
ViewBag.controlsLst = cnRows;
}
if (fm != null && fm.regimen_alimentacion.Count > 0)
{
List <FeedingRegime> fr = fm.regimen_alimentacion;
List <string> frList = new List <string>();
foreach (FeedingRegime f in fr)
{
string row = GetFoodRegimeString(f: f);
frList.Add(row);
foodRegimesCount++;
}
foodRegimesCount = 0;
ViewBag.regimenLst = frList;
}
ViewBag.clientId = cl.id_alt;
ViewBag.programId = prgCl.programa_id;
return(View());
}
public async Task <string> Edit(string json)
{
Dictionary <string, object> oDict = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, object> >(json);
int fmID = int.Parse((string)oDict["fmId"]);
fichas_medicas oFM = db.fichas_medicas.Where(f => f.id == fmID).Include(f => f.controles).Include(f => f.regimen_alimentacion).FirstOrDefault();
// C_1
#region C_1
oFM.programa_id = int.Parse((string)oDict["programId"]);
oFM.cliente_id = int.Parse((string)oDict["clientId"]);
oFM.estatura = double.Parse((string)oDict["height"]);
oFM.contextura = (Contextures)(int.Parse((string)oDict["contexture"]));
oFM.peso_actual = double.Parse((string)oDict["actualWeight"]);
oFM.peso_deseado = double.Parse((string)oDict["wishedWeight"]);
oFM.peso_ideal = double.Parse((string)oDict["idealWeight"]);
#endregion
// C_2
#region C_2
var controlsJArray = (Newtonsoft.Json.Linq.JArray)oDict["controls"];
var controlsJArrayAsString = controlsJArray.ToString();
List <Dictionary <string, object> > oControlsLst = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(controlsJArrayAsString);
List <ControlesNutricionales> controlesNutricionalesLst = new List <ControlesNutricionales>();
List <ControlesNutricionales> controlesGuardadosLst = oFM.controles;
foreach (Dictionary <string, object> c in oControlsLst)
{
if (c.Count > 0)
{
ControlesNutricionales cn = new ControlesNutricionales();
int id = 0;
bool exists = int.TryParse((string)c["id"], out id);
if (exists)
{
cn.id = id;
cn.created_at = DateTime.Parse((string)c["created_at"]);
}
else
{
cn.created_at = CurrentDate.getNow();
}
string format = "MM'/'dd'/'yyyy";
System.Globalization.CultureInfo pe = new System.Globalization.CultureInfo("es-PE");
cn.fecha = DateTime.ParseExact((string)c["date"], format, pe);
cn.act = double.Parse((string)c["act"]);
cn.mme = double.Parse((string)c["mme"]);
cn.mgc = double.Parse((string)c["mgc"]);
cn.mc = double.Parse((string)c["imc"]);
cn.pgc = double.Parse((string)c["pgc"]);
cn.rcc = double.Parse((string)c["rcc"]);
cn.peso = double.Parse((string)c["weight"]);
cn.updated_at = CurrentDate.getNow();
controlesNutricionalesLst.Add(cn);
}
}
for (int c = 0; c < controlesNutricionalesLst.Count; c++)
{
if (controlesNutricionalesLst[c].id > 0)
{
controlesGuardadosLst[c].fecha = controlesNutricionalesLst[c].fecha;
controlesGuardadosLst[c].act = controlesNutricionalesLst[c].act;
controlesGuardadosLst[c].mme = controlesNutricionalesLst[c].mme;
controlesGuardadosLst[c].mgc = controlesNutricionalesLst[c].mgc;
controlesGuardadosLst[c].mc = controlesNutricionalesLst[c].mc;
controlesGuardadosLst[c].pgc = controlesNutricionalesLst[c].pgc;
controlesGuardadosLst[c].rcc = controlesNutricionalesLst[c].rcc;
controlesGuardadosLst[c].peso = controlesNutricionalesLst[c].peso;
controlesGuardadosLst[c].updated_at = controlesNutricionalesLst[c].updated_at;
}
else
{
controlesGuardadosLst.Add(controlesNutricionalesLst[c]);
}
}
#endregion
// C_3
#region C_3
oFM.frec_fumador = (Frecuencies)(int.Parse((string)oDict["smokeFrecuency"]));
oFM.frec_bebedor = (Frecuencies)(int.Parse((string)oDict["drinkFrecuency"]));
oFM.cortisona = (bool)oDict["cortisone"];
oFM.esteroidesAnabolicos = (bool)oDict["anabolics"];
oFM.anfetaminas = (bool)oDict["anfetamines"];
oFM.marihuana = (bool)oDict["marihuana"];
oFM.otra = (bool)oDict["other"];
oFM.ninguna = (bool)oDict["none"];
WomenMenstruationInfo m = new WomenMenstruationInfo();
oFM.menstruacion_menopausia = m;
int childQty = 0;
int.TryParse((string)oDict["childQty"], out childQty);
oFM.menstruacion_menopausia.cantidad_hijos = childQty;
int birthType = 0;
bool bt = int.TryParse((string)oDict["birthType"], out birthType);
if (bt)
{
oFM.menstruacion_menopausia.tipo_parto = (BirthTypes)birthType;
}
int menopauseAge = 0;
bool ma = int.TryParse((string)oDict["menopauseAge"], out menopauseAge);
if (ma)
{
oFM.menstruacion_menopausia.edad_menopausia = menopauseAge;
}
oFM.menstruacion_menopausia.menopausia_activa = (bool)oDict["menopauseActive"];
if (string.IsNullOrEmpty((string)oDict["hormoneTreatment"]))
{
oFM.menstruacion_menopausia.tratamiento_hormonal = "";
}
else
{
oFM.menstruacion_menopausia.tratamiento_hormonal = (string)oDict["hormoneTreatment"];
}
Background bg = new Background();
oFM.antecedentes = bg;
oFM.antecedentes.gastricos = (bool)oDict["bgGastric"];
oFM.antecedentes.diabetes = (bool)oDict["bgDiabetes"];
oFM.antecedentes.trigliceridos_altos = (bool)oDict["bgHighTriglicerids"];
oFM.antecedentes.hipertiroidismo = (bool)oDict["bgHipertiroidism"];
oFM.antecedentes.hipotiroidismo = (bool)oDict["bgHipotiroidism"];
oFM.antecedentes.quistes = (bool)oDict["bgQuists"];
oFM.antecedentes.tumores = (bool)oDict["bgTumors"];
oFM.antecedentes.resistencia_insulina = (bool)oDict["bgInsulinResistant"];
oFM.antecedentes.otras_dislipidemias = (bool)oDict["bgOtherDyslipidemias"];
oFM.antecedentes.prostata = (bool)oDict["bgProstate"];
oFM.antecedentes.renales = (bool)oDict["bgRenal"];
oFM.antecedentes.hepaticos = (bool)oDict["bgHepatic"];
oFM.antecedentes.presion_alta = (bool)oDict["bgHighPresure"];
oFM.antecedentes.presion_baja = (bool)oDict["bgLowPresure"];
oFM.antecedentes.colesterol_alto = (bool)oDict["bgHighCholesterol"];
oFM.antecedentes.anemia = (bool)oDict["bgAnemia"];
oFM.antecedentes.hernias = (bool)oDict["bgHernia"];
oFM.antecedentes.estrenimiento = (bool)oDict["bgConstipation"];
oFM.antecedentes.no_mencionada = (bool)oDict["bgNotMentioned"];
TraumatologyProblems tp = new TraumatologyProblems();
oFM.problemas_traumatologicos = tp;
oFM.problemas_traumatologicos.dolores_articulares = (bool)oDict["traumaArticulationPain"];
oFM.problemas_traumatologicos.osteoporosis = (bool)oDict["traumaOsteoporosis"];
oFM.problemas_traumatologicos.problemas_columna = (bool)oDict["traumaColumnProblems"];
if (string.IsNullOrEmpty((string)oDict["traumaColumnProblemsText"]))
{
oFM.problemas_traumatologicos.problemas_columna_texto = "";
}
else
{
oFM.problemas_traumatologicos.problemas_columna_texto = (string)oDict["traumaColumnProblemsText"];
}
oFM.problemas_traumatologicos.otras_lesiones = (bool)oDict["traumaOtherInjuries"];
if (string.IsNullOrEmpty((string)oDict["traumaOtherInjuriesText"]))
{
oFM.problemas_traumatologicos.otras_lesiones_texto = "";
}
else
{
oFM.problemas_traumatologicos.otras_lesiones_texto = (string)oDict["traumaOtherInjuriesText"];
}
RespiratoryProblems rp = new RespiratoryProblems();
oFM.problemas_respiratorios = rp;
oFM.problemas_respiratorios.asma_cronica = (bool)oDict["respiratoryChronicAsthma"];
oFM.problemas_respiratorios.tos_cronica = (bool)oDict["respiratoryChronicCough"];
oFM.problemas_respiratorios.resfriados_continuos = (bool)oDict["respiratoryContinuosColds"];
oFM.problemas_respiratorios.bronquitis = (bool)oDict["respiratoryBronquitis"];
oFM.problemas_respiratorios.rinitis_alergica = (bool)oDict["respiratoryRinitis"];
oFM.problemas_respiratorios.sinusitis = (bool)oDict["respiratorySinusitis"];
oFM.problemas_respiratorios.amigdalitis = (bool)oDict["respiratoryAmigdalitis"];
oFM.problemas_respiratorios.otros = (bool)oDict["respiratoryOther"];
GeneralBackground gbg = new GeneralBackground();
oFM.antecedentas_generales = gbg;
oFM.antecedentas_generales.obesidad = (bool)oDict["gbgObesity"];
oFM.antecedentas_generales.hipertension = (bool)oDict["gbgHipertension"];
oFM.antecedentas_generales.diabetes = (bool)oDict["gbgDiabetes"];
oFM.antecedentas_generales.cardiopatias = (bool)oDict["gbgCardiopathy"];
oFM.antecedentas_generales.no_mencionada = (bool)oDict["gbgNotMentioned"];
NutritionalAnamnesis na = new NutritionalAnamnesis();
oFM.anamnesis_nutricional = na;
oFM.anamnesis_nutricional.alimentos_fuera_de_casa = (bool)oDict["anamnesisFoodOutOfHome"];
oFM.anamnesis_nutricional.frecAlimentosFuera = (Frecuencies)(int.Parse((string)oDict["anamnesisFoodOutOfHomeFrec"]));
oFM.anamnesis_nutricional.tipo_alimentos_fuera = (string)oDict["anamnesisFoodOutOfHomeType"];
int waterQty = 0;
int.TryParse((string)oDict["anamnesisWaterGlassQty"], out waterQty);
oFM.anamnesis_nutricional.cantidad_vasos_agua_dia = waterQty;
oFM.anamnesis_nutricional.alimentos_preferencia = (string)oDict["anamnesisPreferredFood"];
oFM.anamnesis_nutricional.alimentos_no_preferencia = (string)oDict["anamnesisNonPreferredFood"];
oFM.anamnesis_nutricional.alimentos_daninos = (string)oDict["anamnesisUnsafeFood"];
#endregion
// C_4
#region C_4
var foodRegimeJArray = (Newtonsoft.Json.Linq.JArray)oDict["foodRegimes"];
var foodRegimeJArrayAsString = foodRegimeJArray.ToString();
List <Dictionary <string, object> > oFoodRegimeLst = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(foodRegimeJArrayAsString);
List <FeedingRegime> foodRegimesLst = new List <FeedingRegime>();
List <FeedingRegime> foodRegimesGuardadosLst = oFM.regimen_alimentacion;
foreach (Dictionary <string, object> f in oFoodRegimeLst)
{
if (f.Count > 0)
{
FeedingRegime fr = new FeedingRegime();
int id = 0;
bool exists = int.TryParse((string)f["id"], out id);
if (exists)
{
fr.id = id;
}
fr.tipo_comida = (FoodTypes)int.Parse((string)f["foodType"]);
fr.hora = TimeSpan.Parse((string)f["hour"]);
fr.detalles = (string)f["detail"];
foodRegimesLst.Add(fr);
}
}
for (int c = 0; c < foodRegimesLst.Count; c++)
{
if (foodRegimesLst[c].id > 0)
{
foodRegimesGuardadosLst[c].id = foodRegimesLst[c].id;
foodRegimesGuardadosLst[c].tipo_comida = foodRegimesLst[c].tipo_comida;
foodRegimesGuardadosLst[c].hora = foodRegimesLst[c].hora;
foodRegimesGuardadosLst[c].detalles = foodRegimesLst[c].detalles;
}
else
{
foodRegimesGuardadosLst.Add(foodRegimesLst[c]);
}
}
oFM.regimen_alimentacion = foodRegimesLst;
#endregion
oFM.updated_at = CurrentDate.getNow();
oFM.updated_by = SessionPersister.UserId;
if (ModelState.IsValid)
{
db.Entry(oFM).State = EntityState.Modified;
await db.SaveChangesAsync();
return("Ok");
}
return("Error al guardar información.");
}
