protected void btn_pesquisar_Click(object sender, EventArgs e) { try { try { try { Class_cardapio card = new Class_cardapio(); card.id_usuario = usuario.id; GridView1.DataSource = card.Visualizar_porusuario(); GridView1.DataBind(); Class_alimento Ali = new Class_alimento(); Ali.id = usuario.id; GridView1.DataSource = Ali.visualizar(); GridView1.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } } catch (Exception ex) { Response.Write(ex.Message); } } catch (Exception ex) { Response.Write(ex.Message); } }
protected void GridVerMet_RowEditing(object sender, GridViewEditEventArgs e) { try { Class_alimento Ali = new Class_alimento(); GridVerMet.EditIndex = e.NewEditIndex; GridVerMet.DataSource = Ali.visualizar(); GridVerMet.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } }
protected void btnCadastrar_Click(object sender, EventArgs e) { try { Class_alimento ali = new Class_alimento(); ali.id = int.Parse(txtid.Text); ali.nome = txtnome.Text; ali.calorias = double.Parse(txtcalorias.Text); ali.porcao_gramas = int.Parse(txtporcaogramas.Text); ali.cadastrar(); } catch (Exception ex) { Response.Write(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["perfil"] == null)//logado { Response.Redirect("Login.aspx"); } else { usuario = (Class_usuario)Session["perfil"]; } if (!IsPostBack) { //carrega o gridview Class_cardapio card = new Class_cardapio(); Class_alimento Ali = new Class_alimento(); Class_Meta meta = new Class_Meta(); Class_Meta_Usuario metaUsu = new Class_Meta_Usuario(); Class_Perfil_Alimentar Perfilali = new Class_Perfil_Alimentar(); Class_Perfil_Atividades PerfilAtiv = new Class_Perfil_Atividades(); Class_tipo_refeicao tiporefe = new Class_tipo_refeicao(); card.id_usuario = usuario.id; GridView1.DataSource = card.FeedCaloriasTotais(); meta.id = int.Parse(meta.descricao); GridView1.DataSource = meta.Visualizar(); metaUsu.id = metaUsu.id_meta; GridView1.DataSource = metaUsu.visualizar(); Perfilali.id = Perfilali.qtde_refeicoes_dia; GridView1.DataSource = Perfilali.Visualizar_porusuario(); PerfilAtiv.id = PerfilAtiv.media_queima_calorias_semana; GridView1.DataSource = PerfilAtiv.visualizar(); tiporefe.id = int.Parse(tiporefe.descricao); GridView1.DataSource = tiporefe.visualizar(); GridView1.DataBind(); } } catch (Exception ex) { Response.Write(ex.Message); } }
protected void GridVerMet_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { Class_alimento Ali = new Class_alimento(); Ali.id = Convert.ToInt32(e.Values[0]); GridVerMet.EditIndex = -1; GridVerMet.DataSource = Ali.visualizar(); GridVerMet.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } }
protected void GridVerMet_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { Class_alimento Ali = new Class_alimento(); Ali.id = Convert.ToInt32(e.NewValues[0]); Ali.nome = e.NewValues[1].ToString(); Ali.porcao_gramas = Convert.ToInt32(e.NewValues[2]); Ali.alterar_dados(); GridVerMet.EditIndex = -1; GridVerMet.DataSource = Ali.visualizar(); GridVerMet.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } }