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