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