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