protected void accao_Click(object sender, EventArgs e) { MembershipUser user = Membership.GetUser(); SQLDatabaseManager db = new SQLDatabaseManager(); Button btn = (Button)sender; String texto = btn.Text; GridViewRow gvr = (GridViewRow)btn.NamingContainer; Client c = new Client(user.ProviderUserKey.ToString()); int idv = c.getIDVolunt(); if(texto.Equals("Aceitar")) { Label lblServ = (Label)GridView1.Rows[gvr.RowIndex].FindControl("IDS"); String query = String.Format("UPDATE Servico SET IDVoluntario='{0}', Status='{1}' WHERE IDServico='{2}'", idv, "Aceite", lblServ.Text); db.ExecuteNonQuery(query); Response.Redirect("~/Volunts/ManageServicos.aspx"); } else { Label lblServ = (Label)GridView1.Rows[gvr.RowIndex].FindControl("IDS"); String query = String.Format("UPDATE Servico SET IDVoluntario='{0}', Status='{1}' WHERE IDServico='{2}'", "15", "Nao Aceite", lblServ.Text); db.ExecuteNonQuery(query); Response.Redirect("~/Volunts/ManageServicos.aspx"); } }
protected void reject_Click(object sender, EventArgs e) { SQLDatabaseManager db = new SQLDatabaseManager(); String query = String.Format("UPDATE Voluntario SET Status='Rejeitado' WHERE IDVoluntario='{0}'", DropDownList1.SelectedValue); db.ExecuteNonQuery(query); Response.Redirect("~/Admin/Accept.aspx"); }
protected void Confirm_Click(object sender, EventArgs e) { MembershipUser user = Membership.GetUser(); SQLDatabaseManager db = new SQLDatabaseManager(); String upquery = String.Format("UPDATE Cliente SET Nome='{0}', Morada='{1}', DataNasc='{2}', Email='{3}', Contactos='{4}' WHERE UserId='{5}'", tnome.Text, tmorada.Text, tdata.Text, temail.Text, tcontactos.Text, user.ProviderUserKey.ToString()); db.ExecuteNonQuery(upquery); Response.Redirect("~/Clients/MainPage.aspx"); }
protected void Confirm_Click(object sender, EventArgs e) { MembershipUser user = Membership.GetUser(); Client c = new Client(user.ProviderUserKey.ToString()); SQLDatabaseManager db = new SQLDatabaseManager(); String upquery = String.Format("UPDATE Idoso SET Nome='{0}', Morada='{1}', DataNasc='{2}', Contacto='{3}', Condicoes='{4}' WHERE IDIdoso='{5}'", tnome.Text, tmorada.Text, tdata.Text, tcontacto.Text, tcondicoes.Text, DropDownList1.SelectedValue); int r= db.ExecuteNonQuery(upquery); Response.Redirect("~/Clients/ManageIdosos.aspx"); }
protected void Confirm_Click(object sender, EventArgs e) { MembershipUser user = Membership.GetUser(); SQLDatabaseManager db = new SQLDatabaseManager(); foreach (ListItem item in CheckBoxList1.Items) { if (item.Selected) { selected += item.Text + " - "; } } if (!selected.Equals(null)) { String query = String.Format("UPDATE Servico SET Servico='{0}' WHERE IDServico='{1}'", selected, DropDownList1.SelectedValue); db.ExecuteNonQuery(query); Response.Redirect("~/Clients/VerServico.aspx"); } else { Label1.Visible = true; } }