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