public TODistribucionPorciones TraerDistribucion(string ced)
{
string qry = "select * from DistribucionPorcion where Cedula = " + ced;
SqlCommand cmd = new SqlCommand(qry, conexion);
SqlDataReader lector;
try
{
if (conexion.State != ConnectionState.Open)
{
conexion.Open();
}
lector = cmd.ExecuteReader();
if (lector.HasRows)
{
lector.Read();
TODistribucionPorciones distrib = new TODistribucionPorciones(lector["Cedula"].ToString(), lector["Ayunas"].ToString(),
lector["Desayuno"].ToString(), lector["MediaMañana"].ToString(), lector["Almuerzo"].ToString(),
lector["MediaTarde"].ToString(), lector["Cena"].ToString(), lector["ColacionNocturna"].ToString());
conexion.Close();
return(distrib);
}
else
{
conexion.Close();
return(null);
}
}
catch (SqlException)
{
conexion.Close();
return(null);
}
}
public bool AgregarAntropometria(Antropometria antrop, Porciones porcion, DistribucionPorciones distrib)
{
TOAntropometria antropom = new TOAntropometria();
antropom.Cedula = antrop.Cedula; antropom.Talla = antrop.Talla; antropom.PesoIdeal = antrop.PesoIdeal;
antropom.Edad = antrop.Edad; antropom.PMB = antrop.PMB; antropom.Peso = antrop.Peso; antropom.PesoMaxTeoria = antrop.PesoMaxTeoria;
antropom.IMC = antrop.IMC; antropom.PorcGrasaAnalizador = antrop.PorcGrasaAnalizador; antropom.PorcGr_Bascula = antrop.PorcGr_Bascula;
antropom.GB_BI = antrop.GB_BI; antropom.GB_BD = antrop.GB_BD; antropom.GB_PI = antrop.GB_PI;
antropom.GB_PD = antrop.GB_PD; antropom.GB_Tronco = antrop.GB_Tronco; antropom.AguaCorporal = antrop.AguaCorporal;
antropom.MasaOsea = antrop.MasaOsea; antropom.Complexión = antrop.Complexión; antropom.EdadMetabolica = antrop.EdadMetabolica;
antropom.Cintura = antrop.Cintura; antropom.Abdomen = antrop.Abdomen; antropom.Cadera = antrop.Cadera;
antropom.Muslo = antrop.Muslo; antropom.CBM = antrop.CBM; antropom.CircunfMunneca = antrop.CircunfMunneca;
antropom.PorcentMusculo = antrop.PorcentMusculo; antropom.PM_BI = antrop.PM_BI; antropom.PM_PD = antrop.PM_PD; antropom.PM_BD = antrop.PM_BD;
antropom.PM_PI = antrop.PM_PI; antropom.PM_Tronco = antrop.PM_Tronco; antropom.Observaciones = antrop.Observaciones;
antropom.GEB = antrop.GEB; antropom.GET = antrop.GET; antropom.CHOPorc = antrop.CHOPorc;
antropom.CHOGram = antrop.CHOGram; antropom.CHO_kcal = antrop.CHO_kcal; antropom.ProteinaPorc = antrop.ProteinaPorc;
antropom.ProteinaGram = antrop.ProteinaGram; antropom.Proteinakcal = antrop.Proteinakcal; antropom.GrasaPorc = antrop.GrasaPorc;
antropom.GrasaGram = antrop.GrasaGram; antropom.Grasakcal = antrop.Grasakcal;
TOPorciones porci = new TOPorciones(porcion.Cedula, porcion.Leche, porcion.Carne, porcion.Vegetales, porcion.Grasa,
porcion.Fruta, porcion.Azucar, porcion.Harina, porcion.Suplemento);
TODistribucionPorciones distribuc = new TODistribucionPorciones(distrib.Cedula, distrib.Ayunas, distrib.Desayuno,
distrib.MediaMañana, distrib.Almuerzo, distrib.MediaTarde, distrib.Cena, distrib.ColacionNocturna);
return(daoClienteNutricion.GuardarAntropometria(antropom, porci, distribuc));
}
public DistribucionPorciones TraerDistribPorc(string ced)
{
TODistribucionPorciones distribuc = daoClienteNutricion.TraerDistribucion(ced);
if (distribuc != null)
{
return(new DistribucionPorciones(distribuc.Cedula, distribuc.Ayunas, distribuc.Desayuno, distribuc.MediaMañana, distribuc.Almuerzo,
distribuc.MediaTarde, distribuc.Cena, distribuc.ColacionNocturna));
}
else
{
return(null);
}
}
public bool GuardarAntropometria(TOAntropometria antropom, TOPorciones porcion, TODistribucionPorciones distrib)
{
String query1 = "Insert into Antropometria values(@ced, @talla, @pesIdeal, @edad,@pmb, @peso,@pesmax,@imc, @gAnaliz, @grbascu, @gbbi,@gbbd, @gbpi, @gbpd," +
"@gbtronc, @aguacorp, @masaOsea, @complex,@edadMetab,@cint,@abdomn,@cader,@muslo,@cbm,@circunf,@grviser,@pormuscul,@pmbi,@pmpd,@pmbd," +
"@pmpi,@pmtronco,@observ,@geb,@get,@chopor,@chogram,@chokcal,@protpor,@protgram,@protkcal,@grporc,@grgram,@grkcal)";
String query2 = "Insert into Porciones values( @pced,@pleche,@pcarne,@pveget,@pgrasa,@pfruta,@pazuc,@pharina, @psuplem)";
String query3 = "Insert into DistribucionPorcion values(@diCed, @diAyun, @diDesay, @diMedMan,@diAlmuer, @dimedTard,@diCena,@dicolNoc)";
SqlCommand cmd = new SqlCommand(query1, conexion);
SqlCommand cmd2 = new SqlCommand(query2, conexion);
SqlCommand cmd3 = new SqlCommand(query3, conexion);
try
{
cmd.Parameters.AddWithValue("@ced", antropom.Cedula); cmd.Parameters.AddWithValue("@talla", antropom.Talla);
cmd.Parameters.AddWithValue("@pesIdeal", antropom.PesoIdeal); cmd.Parameters.AddWithValue("@edad", antropom.Edad);
cmd.Parameters.AddWithValue("@pmb", antropom.PMB); cmd.Parameters.AddWithValue("@peso", antropom.Peso);
cmd.Parameters.AddWithValue("@pesmax", antropom.PesoMaxTeoria); cmd.Parameters.AddWithValue("@imc", antropom.IMC);
cmd.Parameters.AddWithValue("@gAnaliz", antropom.PorcGrasaAnalizador); cmd.Parameters.AddWithValue("@grbascu", antropom.PorcGr_Bascula);
cmd.Parameters.AddWithValue("@gbbi", antropom.GB_BI); cmd.Parameters.AddWithValue("@gbbd", antropom.GB_BD);
cmd.Parameters.AddWithValue("@gbpi", antropom.GB_PI); cmd.Parameters.AddWithValue("@gbpd", antropom.GB_PD);
cmd.Parameters.AddWithValue("@gbtronc", antropom.GB_Tronco); cmd.Parameters.AddWithValue("@aguacorp", antropom.AguaCorporal);
cmd.Parameters.AddWithValue("@masaOsea", antropom.MasaOsea); cmd.Parameters.AddWithValue("@complex", antropom.Complexión);
cmd.Parameters.AddWithValue("@edadMetab", antropom.EdadMetabolica); cmd.Parameters.AddWithValue("@cint", antropom.Cintura);
cmd.Parameters.AddWithValue("@abdomn", antropom.Abdomen); cmd.Parameters.AddWithValue("@cader", antropom.Cadera);
cmd.Parameters.AddWithValue("@muslo", antropom.Muslo); cmd.Parameters.AddWithValue("@cbm", antropom.CBM);
cmd.Parameters.AddWithValue("@circunf", antropom.CircunfMunneca); cmd.Parameters.AddWithValue("@grviser", antropom.PorcentGViceral);
cmd.Parameters.AddWithValue("@pormuscul", antropom.PorcentMusculo); cmd.Parameters.AddWithValue("@pmbi", antropom.PM_BI);
cmd.Parameters.AddWithValue("@pmpd", antropom.PM_PD); cmd.Parameters.AddWithValue("@pmbd", antropom.PM_BD);
cmd.Parameters.AddWithValue("@pmpi", antropom.PM_PI); cmd.Parameters.AddWithValue("@pmtronco", antropom.PM_Tronco);
cmd.Parameters.AddWithValue("@observ", antropom.Observaciones); cmd.Parameters.AddWithValue("@geb", antropom.GEB);
cmd.Parameters.AddWithValue("@get", antropom.GET); cmd.Parameters.AddWithValue("@chopor", antropom.CHOPorc);
cmd.Parameters.AddWithValue("@chogram", antropom.CHOGram); cmd.Parameters.AddWithValue("@chokcal", antropom.CHO_kcal);
cmd.Parameters.AddWithValue("@protpor", antropom.ProteinaPorc); cmd.Parameters.AddWithValue("@protgram", antropom.ProteinaGram);
cmd.Parameters.AddWithValue("@protkcal", antropom.Proteinakcal); cmd.Parameters.AddWithValue("@grporc", antropom.GrasaPorc);
cmd.Parameters.AddWithValue("@grgram", antropom.GrasaGram); cmd.Parameters.AddWithValue("@grkcal", antropom.Grasakcal);
cmd2.Parameters.AddWithValue("@pced", porcion.Cedula); cmd2.Parameters.AddWithValue("@pleche", porcion.Leche);
cmd2.Parameters.AddWithValue("@pcarne", porcion.Carne); cmd2.Parameters.AddWithValue("@pveget", porcion.Vegetales);
cmd2.Parameters.AddWithValue("@pgrasa", porcion.Grasa); cmd2.Parameters.AddWithValue("@pfruta", porcion.Fruta);
cmd2.Parameters.AddWithValue("@pazuc", porcion.Azucar); cmd2.Parameters.AddWithValue("@pharina", porcion.Harina);
cmd2.Parameters.AddWithValue("@psuplem", porcion.Suplemento);
cmd3.Parameters.AddWithValue("@diCed", distrib.Cedula); cmd3.Parameters.AddWithValue("@diAyun", distrib.Ayunas);
cmd3.Parameters.AddWithValue("@diDesay", distrib.Desayuno); cmd3.Parameters.AddWithValue("@diMedMan", distrib.MediaMañana);
cmd3.Parameters.AddWithValue("@diAlmuer", distrib.Almuerzo); cmd3.Parameters.AddWithValue("@dimedTard", distrib.MediaTarde);
cmd3.Parameters.AddWithValue("@diCena", distrib.Cena); cmd3.Parameters.AddWithValue("@dicolNoc", distrib.ColacionNocturna);
if (conexion.State != ConnectionState.Open)
{
conexion.Open();
}
//insertar
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
cmd3.ExecuteNonQuery();
conexion.Close();
return(true);
}
catch (SqlException)
{
return(false);
}
}
