protected void btnPostReply_Click(object sender, EventArgs e) { sc.Open(); SqlCommand login = new SqlCommand(); login.Connection = sc; login.CommandText = "SELECT PersonID from Account where Username = '******'"; int accountID = (int)login.ExecuteScalar(); sc.Close(); GridViewRow row = (sender as Button).NamingContainer as GridViewRow; Label lblchildCommentid = (Label)row.FindControl("lblPostId"); TextBox txtCommentParent = (TextBox)row.FindControl("txtCommentReply"); SqlCommand cmd = new SqlCommand("Insert into Comment(CommentDescription, DateCreated, PostID, PersonID) values (@Description, @DateCreated, @PostID, @PersonID)", sc); cmd.Parameters.Add(new SqlParameter("@Description", txtCommentParent.Text)); cmd.Parameters.Add(new SqlParameter("@DateCreated", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@PostID", lblchildCommentid.Text)); cmd.Parameters.Add(new SqlParameter("@PersonID", accountID)); // cmd.Parameters.AddWithValue("@UserName", Request.QueryString["User_name"].ToString()); sc.Open(); cmd.ExecuteNonQuery(); sc.Close(); // Binds the Comments to the Post int selectedSort = SortDropDown.SelectedIndex; GridViewPosts.DataSource = Post.getAllPostInfo(selectedSort); GridViewPosts.DataBind(); }
// Binds current comments from the database to the page //public void bindComments() //{ // String connection = "Data Source=localhost;Initial Catalog=Cued-In;Integrated Security=True"; // SqlConnection sc = new SqlConnection(connection); // SqlDataAdapter sqlDA = new SqlDataAdapter("Select * from Comment", sc); // DataSet commentSet = new DataSet(); // sqlDA.Fill(commentSet); // GridViewPosts.DataSource = commentSet; // GridViewPosts.DataBind(); //} // Allows user to publish posts and have them added to the timeline protected void btnPublishPost_Click(object sender, EventArgs e) { Post newPost = new Post(txtNewPost.Text); SqlCommand cmd = new SqlCommand("Insert into Post(PostDescription,DateCreated,Deadline,PersonID,OpportunityID,ModifiedDate) values(@Description,@DateCreated,@Deadline,@PersonID,@OpportunityID,@ModifiedDate)", sc); cmd.Parameters.Add(new SqlParameter("@Description", newPost.getPostDesc())); cmd.Parameters.Add(new SqlParameter("@DateCreated", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@Deadline", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@PersonID", 14)); cmd.Parameters.Add(new SqlParameter("@OpportunityID", 1)); cmd.Parameters.Add(new SqlParameter("@ModifiedDate", DateTime.Now)); sc.Open(); cmd.ExecuteNonQuery(); sc.Close(); GridViewPosts.DataSource = Post.getAllPostInfo(); GridViewPosts.DataBind(); txtNewPost.Text = ""; }
// Allows user to publish posts and have them added to the timeline protected void btnPublishPost_Click(object sender, EventArgs e) { Post newPost = new Post(txtNewPost.Text); sc.Open(); System.Data.SqlClient.SqlCommand getdbPersonID = new System.Data.SqlClient.SqlCommand(); getdbPersonID.Connection = sc; //Gets the personid for the username getdbPersonID.CommandText = "SELECT PersonID from Account where Username = '******'"; int accountID = (int)getdbPersonID.ExecuteScalar(); sc.Close(); //Display current name sc.Open(); SqlCommand getEmpID = new SqlCommand(); getEmpID.Connection = sc; getEmpID.CommandText = "Select EmployerID from Person where PersonID = " + accountID; Int32 EmpID = Convert.ToInt32(getEmpID.ExecuteScalar()); sc.Close(); sc.Open(); SqlCommand cmd = new SqlCommand("Insert into Post(PostDescription, DateCreated, Deadline, PersonID, EmployerID, OpportunityID,ModifiedDate) values(@Description,@DateCreated,@Deadline,@PersonID, @EmployerID, @OpportunityID,@ModifiedDate)", sc); cmd.Parameters.Add(new SqlParameter("@Description", newPost.getPostDesc())); cmd.Parameters.Add(new SqlParameter("@DateCreated", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@Deadline", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@PersonID", accountID)); cmd.Parameters.Add(new SqlParameter("@EmployerID", EmpID)); cmd.Parameters.Add(new SqlParameter("@OpportunityID", 1)); cmd.Parameters.Add(new SqlParameter("@ModifiedDate", DateTime.Now)); cmd.ExecuteNonQuery(); sc.Close(); int selectedSort = SortDropDown.SelectedIndex; GridViewPosts.DataSource = Post.getAllPostInfo(selectedSort); GridViewPosts.DataBind(); txtNewPost.Text = ""; }
protected void btnPostReply_Click(object sender, EventArgs e) { GridViewRow row = (sender as Button).NamingContainer as GridViewRow; Label lblchildCommentid = (Label)row.FindControl("lblPostId"); TextBox txtCommentParent = (TextBox)row.FindControl("txtCommentReply"); SqlCommand cmd = new SqlCommand("Insert into Comment(CommentDescription, DateCreated, PostID, PersonID) values (@Description, @DateCreated, @PostID, @PersonID)", sc); cmd.Parameters.Add(new SqlParameter("@Description", txtCommentParent.Text)); cmd.Parameters.Add(new SqlParameter("@DateCreated", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@PostID", lblchildCommentid.Text)); cmd.Parameters.Add(new SqlParameter("@PersonID", 14)); // cmd.Parameters.AddWithValue("@UserName", Request.QueryString["User_name"].ToString()); sc.Open(); cmd.ExecuteNonQuery(); sc.Close(); // Binds the Comments to the Post GridViewPosts.DataSource = Post.getAllPostInfo(); GridViewPosts.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { int selectedSort = SortDropDown.SelectedIndex; // Bind current posts from the database to the page GridViewPosts.DataSource = Post.getAllPostInfo(selectedSort); GridViewPosts.DataBind(); sc.Open(); System.Data.SqlClient.SqlCommand getdbPersonID = new System.Data.SqlClient.SqlCommand(); getdbPersonID.Connection = sc; //Gets the personid for the username getdbPersonID.CommandText = "SELECT PersonID from Account where Username = '******'"; int accountID = (int)getdbPersonID.ExecuteScalar(); sc.Close(); //lblDisplayName.Text = accountID.ToString(); sc.Open(); System.Data.SqlClient.SqlCommand getFName = new System.Data.SqlClient.SqlCommand(); getFName.Connection = sc; //gets the firstname for the user //getFName.CommandText = "select Person.FirstName FROM Person INNER JOIN Account ON Person.PersonID = Account.PersonID where Person.PersonID = @AccountPersonID"; getFName.CommandText = "Select FirstName from Person where Email = @FirstNamePerson"; getFName.Parameters.Add(new SqlParameter("@FirstNamePerson", (string)(Session)["loginUser"])); // getdbPersonID.ExecuteNonQuery(); string accountFName = (string)getFName.ExecuteScalar(); sc.Close(); sc.Open(); System.Data.SqlClient.SqlCommand getLName = new System.Data.SqlClient.SqlCommand(); getLName.Connection = sc; //gets the lastname for the user getLName.CommandText = "Select LastName FROM Person where Email = @AccountPersonName"; getLName.Parameters.Add(new SqlParameter("@AccountPersonName", (string)(Session)["loginUser"])); string accountLName = (string)getLName.ExecuteScalar(); sc.Close(); LoginName.Text = accountFName + " " + accountLName; //Display current employer's username/email UserName.Text = (string)(Session)["loginUser"]; sc.Open(); System.Data.SqlClient.SqlCommand getCompName = new System.Data.SqlClient.SqlCommand(); getCompName.Connection = sc; getCompName.CommandText = "Select EmployerName from Employer Inner Join Person on Employer.EmployerID = Person.PersonID where PersonID = @EmployerID"; getCompName.Parameters.Add(new SqlParameter("@EmployerID", Session["employerID"])); String Company = (String)getCompName.ExecuteScalar(); CompanyName.Text = Company; sc.Close(); sc.Open(); System.Data.SqlClient.SqlCommand getSummary = new System.Data.SqlClient.SqlCommand(); getSummary.Connection = sc; getSummary.CommandText = "Select PersonalSummary from Person where Email = @Email"; getSummary.Parameters.Add(new SqlParameter("@Email", (string)(Session)["loginUser"])); String Summary = (String)getSummary.ExecuteScalar(); SumLblDesc.Text = Summary; sc.Close(); sc.Open(); System.Data.SqlClient.SqlCommand getLocation = new System.Data.SqlClient.SqlCommand(); getLocation.Connection = sc; getLocation.CommandText = "Select City from Address INNER JOIN Person on Address.AddressID = Person.AddressID where Person.Email = @PersonEmail"; getLocation.Parameters.Add(new SqlParameter("@PersonEmail", (string)(Session)["loginUser"])); String Location = (String)getLocation.ExecuteScalar(); LocLblResult.Text = Location; sc.Close(); GridViewPosts.CellPadding = 0; GridViewPosts.CellSpacing = 0; }
//Localhost Connection // System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["LocalhostConnectionString"].ToString()); protected void Page_Load(object sender, EventArgs e) { // Bind current posts from the database to the page GridViewPosts.DataSource = Post.getAllPostInfo(); GridViewPosts.DataBind(); }