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 Confirm_Click(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
Client c = new Client(user.ProviderUserKey.ToString());
MembershipUser newUser;
if((newUser=c.NovoUser(tuser.Text, tpass.Text)) == null)
{
}
else
{
SQLDatabaseManager db = new SQLDatabaseManager();
Dictionary<String, String> InsertData = new Dictionary<String, String>()
{
{"Nome", tnome.Text},
{"Morada", tmorada.Text},
{"Email", temail.Text},
{"Contacto", tcontactos.Text},
{"UserId", newUser.ProviderUserKey.ToString()}
};
db.Insert("Admin", InsertData);
Roles.AddUserToRole(newUser.UserName, "Admin");
Response.Redirect("~/Admin/AMain.aspx");
}
}
protected void Confirm_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
Dictionary<String, String> InsertData = new Dictionary<String, String>()
{
{"IDCliente", id.ToString()},
{"Nome", tnome.Text},
{"Morada", tmorada.Text},
{"DataNasc", tdata.Text},
{"Contacto", tcontacto.Text},
{"Condicoes",tcondicoes.Text}
};
db.Insert("Idoso", InsertData);
Response.Redirect("~/Clients/MainPage.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 where = String.Format("IDIdoso='{0}'", DropDownList1.SelectedValue);
db.Delete("Idoso", where);
Response.Redirect("~/Clients/ManageIdosos.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");
}
public Boolean checkValid()
{
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT Status, IDVoluntario FROM VOluntario WHERE UserId='{0}'", userID);
DataTable dt;
dt = db.GetDataTable(query);
if (dt.Rows[0]["Status"].ToString().Equals("Aguarda") || dt.Rows[0]["Status"].ToString().Equals("Rejeitado"))
{
return false;
}
return true;
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT [Nome], [Morada], [Email], [DataNasc], [Contactos], [Disponibilidade], [Status], [Habilitacoes] FROM [Voluntario] WHERE UserId='{0}'", user.ProviderUserKey.ToString());
DataTable temp;
temp = db.GetDataTable(query);
FormView1.DataSource = temp;
FormView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT [Email], [Morada], [Nome], [Contacto], [UserId] FROM [Admin] WHERE UserId='{0}'", user.ProviderUserKey.ToString());
DataTable temp;
temp = db.GetDataTable(query);
FormView1.DataSource = temp;
FormView1.DataBind();
}
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 Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT I.Nome, I.Morada, I.Contacto, S.Servico, S.Notas, S.Horario, S.Status, V.Nome AS Vnome, V.Contactos From Idoso I, Servico S, Voluntario V WHERE S.IDCliente=I.IDCliente AND V.IDVoluntario=S.IDVoluntario AND I.IDIdoso=S.IDIdoso AND S.IDCliente='{0}'", id);
DataTable temp;
temp = db.GetDataTable(query);
GridView1.DataSource = temp;
GridView1.DataBind();
}
public int getIDVolunt()
{
int id;
SQLDatabaseManager db = new SQLDatabaseManager();
DataTable dt;
String query = String.Format("SELECT IDVoluntario FROM Voluntario WHERE UserId='{0}'", userID);
dt = db.GetDataTable(query);
id = Convert.ToInt32(dt.Rows[0]["IDVoluntario"].ToString());
return id;
}
public int getIDIdoso(int idc, String nome)
{
int id;
SQLDatabaseManager db = new SQLDatabaseManager();
DataTable dt;
String query = String.Format("SELECT IDIdoso FROM Idoso WHERE (IDCliente='{0}' AND Nome='{1}')", idc, nome);
dt = db.GetDataTable(query);
id = Convert.ToInt32(dt.Rows[0]["IDIdoso"].ToString());
return id;
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT Nome, Morada, Contacto, DataNasc, Condicoes FROM Idoso WHERE IDCliente='{0}'", id);
DataTable temp;
temp = db.GetDataTable(query);
GridView1.DataSource = temp;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT IDVoluntario, Nome, Status From Voluntario WHERE IDVoluntario<>15 AND Status='Aguarda'");
DataTable temp;
temp = db.GetDataTable(query);
DropDownList1.DataValueField = "IDVoluntario";
DropDownList1.DataTextField = "Nome";
DropDownList1.DataSource = temp;
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "Escolha um Voluntário.");
}
}
protected void add_Click(object sender, EventArgs e)
{
if(DropDownList1.SelectedIndex.Equals(0))
{
Label1.Visible = true;
}
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int idcliente = c.getIDCliente();
int ididoso = c.getIDIdoso(idcliente, DropDownList1.SelectedItem.Text);
foreach (ListItem item in CheckBoxList1.Items)
{
if (item.Selected)
{
selected += item.Text + " - ";
}
}
Dictionary<String, String> InsertData = new Dictionary<String, String>()
{
{"IDCliente", idcliente.ToString()},
{"IDIdoso", ididoso.ToString()},
{"Servico", selected},
{"Notas", tnotas.Text},
{"Horario", thorario.Text},
{"Status", "Não Aceite"},
{"IDVoluntario", "15"}
};
if (!db.Insert("dbo.Servico", InsertData))
{
Response.Redirect("Erro ao criar entrada");
}
else
{
Response.Redirect("~/Clients/VerServico.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT Nome, Morada, Email, Contacto FROM Admin WHERE UserID='{0}'", user.ProviderUserKey.ToString());
DataTable temp;
temp = db.GetDataTable(query);
tnome.Text = temp.Rows[0]["Nome"].ToString();
tmorada.Text = temp.Rows[0]["Morada"].ToString();
temail.Text = temp.Rows[0]["Email"].ToString();
tcontactos.Text = temp.Rows[0]["Contacto"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT IDIdoso, Nome From Idoso WHERE IDCliente='{0}'", id);
DataTable temp;
temp = db.GetDataTable(query);
DropDownList1.DataValueField = "IDIdoso";
DropDownList1.DataTextField = "Nome";
DropDownList1.DataSource = temp;
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "Escolha um idoso.");
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Confirm.Enabled = true;
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT Nome, Morada, DataNasc, Contacto, Condicoes FROM Idoso WHERE IDIdoso='{0}'", DropDownList1.SelectedValue);
DataTable temp;
temp = db.GetDataTable(query);
tnome.Text = temp.Rows[0]["Nome"].ToString();
tmorada.Text = temp.Rows[0]["Morada"].ToString();
tdata.Text = temp.Rows[0]["DataNasc"].ToString();
tcondicoes.Text = temp.Rows[0]["condicoes"].ToString();
tcontacto.Text = temp.Rows[0]["Contacto"].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT Nome, Morada, DataNasc, Email, Contactos, Disponibilidade, Habilitacoes FROM Voluntario WHERE UserID='{0}'", user.ProviderUserKey.ToString());
DataTable temp;
temp = db.GetDataTable(query);
tnome.Text = temp.Rows[0]["Nome"].ToString();
tmorada.Text = temp.Rows[0]["Morada"].ToString();
tdata.Text = temp.Rows[0]["DataNasc"].ToString();
temail.Text = temp.Rows[0]["Email"].ToString();
tcontactos.Text = temp.Rows[0]["Contactos"].ToString();
tdisp.Text = temp.Rows[0]["Disponibilidade"].ToString();
thabil.Text = temp.Rows[0]["Habilitacoes"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
int id = c.getIDCliente();
String query = String.Format("SELECT S.IDServico, S.Servico, I.Nome From Servico S, Idoso I WHERE I.IDIdoso=S.IDIdoso AND S.IDCliente='{0}'", id);
DataTable temp;
temp = db.GetDataTable(query);
temp.Columns.Add("NomeServico", typeof(string), "Nome + ' - ' + Servico");
DropDownList1.DataValueField = "IDServico";
DropDownList1.DataTextField = "NomeServico";
DropDownList1.DataSource = temp;
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "Escolha o serviço a alterar.");
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedIndex.Equals(0))
{
FormView1.DataSource = null;
FormView1.DataBind();
}
else
{
SQLDatabaseManager db = new SQLDatabaseManager();
String query = String.Format("SELECT [Nome], [Morada], [Email], [DataNasc], [Contactos], [Disponibilidade], [Status], [Habilitacoes] FROM [Voluntario] WHERE IDVoluntario='{0}'", DropDownList1.SelectedValue);
DataTable temp;
temp = db.GetDataTable(query);
FormView1.DataSource = temp;
FormView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MembershipUser user = Membership.GetUser();
SQLDatabaseManager db = new SQLDatabaseManager();
Client c = new Client(user.ProviderUserKey.ToString());
if (!c.checkValid())
{
Response.Redirect("~/Volunts/Offlimits.aspx");
}
int id = c.getIDVolunt();
String query = String.Format("Select I.Nome, I.Morada, I.Contacto, I.Condicoes, S.Servico, S.Notas, S.Horario, S.Status, S.IDServico, S.IDVoluntario FROM Idoso I, Servico S, Voluntario V WHERE S.IDIdoso=I.IDIdoso AND S.IDVoluntario=V.IDVoluntario AND (S.IDVoluntario='15' OR S.IDVoluntario='{0}')", id);
DataTable temp;
temp = db.GetDataTable(query);
GridView1.DataSource = temp;
GridView1.DataBind();
}
}
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;
}
}
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
if (RadioButtonList1.SelectedIndex.Equals(0))
{
//fill dos parametros da query com dados inseridos na textbox
String user = CreateUserWizard1.UserName;
String pass = CreateUserWizard1.Password;
String email = CreateUserWizard1.Email;
String nome = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Tnome")).Text;
String morada = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Tmorada")).Text;
String tlf = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Tcontactos")).Text;
String data = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Tdata")).Text;
String uid = Membership.GetUser(CreateUserWizard1.UserName).ProviderUserKey.ToString();
//operação de insert
SQLDatabaseManager db = new SQLDatabaseManager();
Dictionary<String, String> InsertData = new Dictionary<String, String>()
{
{"Username", user},
{"Nome", nome},
{"Morada", morada},
{"DataNasc", data},
{"Email", email},
{"Contactos", tlf},
{"UserId",uid},
};
if(!db.Insert("dbo.Cliente", InsertData))
{
Response.Redirect("Erro ao criar entrada");
}
Roles.AddUserToRole(CreateUserWizard1.UserName.ToString(), "Cliente");
}
else
{
String user = CreateUserWizard1.UserName;
String pass = CreateUserWizard1.Password;
String email = CreateUserWizard1.Email;
String nome = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Tnome")).Text;
String morada = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Tmorada")).Text;
String tlf = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Tcontactos")).Text;
String data = ((TextBox)CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Tdata")).Text;
String uid = Membership.GetUser(CreateUserWizard1.UserName).ProviderUserKey.ToString();
//Response.Redirect(uid);
SQLDatabaseManager db = new SQLDatabaseManager();
Dictionary<String, String> InsertData = new Dictionary<String, String>()
{
{"Nome", nome},
{"Morada", morada},
{"Email", email},
{"DataNasc", data},
{"Contactos", tlf},
{"UserId",uid},
{"Username", user},
{"Disponibilidade", "Nao definida"},
{"Habilitacoes", "Nao definidas"},
{"Status", "Aguarda"}
};
if (!db.Insert("dbo.Voluntario", InsertData))
{
Response.Redirect("Erro ao criar entrada");
}
Roles.AddUserToRole(CreateUserWizard1.UserName.ToString(), "Voluntario");
}
}