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