protected void Page_Load(object sender, EventArgs e) { String x = Request.QueryString["name"]; DataTable data = Database.Query.ExecuteReturnCommand("Select ID from Accounts WHERE Name = '" + x + "';"); String ID = data.Rows[0].ItemArray[0].ToString(); Database.HelloWorldQueryMethods.Account acc = Database.HelloWorldQueryMethods.GetAccountFromID(ID); name.InnerText = acc.Name; email.Value = acc.Email; Year.Value = Database.HelloWorldQueryMethods.YearfromInt(acc.Year); description.Value = acc.Desc; }
protected void CreateEve_ServerClick(object sender, EventArgs e) { String sportsBox = SportName.Value; String profeciencyBox = proficiency.Value; String genderBox = Gender.Value; int reqPeopleBox = Int32.Parse(ReqPeople.Value); if (reqPeopleBox <= 0) { failedMessage.Visible = true; failedMessage.InnerText = "The Number of people MUST be greater than 0"; } else { reqPeopleBox++;//this is to accomodate the host as one participant String locationBox = Location.Value; String sportDescriptionBox = SportDescription.Value; String dateBox = Calendar.SelectedDate.ToString("yyyy-MM-dd"); String timeBox = appt.Value; String dateTimeBox = dateBox + " " + timeBox + ":00"; Database.HelloWorldQueryMethods.Posts posts = new Database.HelloWorldQueryMethods.Posts(); posts.Title = sportsBox; Database.HelloWorldQueryMethods.Account acc = new Database.HelloWorldQueryMethods.Account(); //Cookies.WriteCookie("10001", this.Response); // To be removed when sites are connected acc = Database.HelloWorldQueryMethods.GetAccountFromCookie(this.Request, this.Response); posts.Posts_Name = acc.Name; posts.Gender = genderBox; posts.Desc = sportDescriptionBox; posts.Location = locationBox; posts.NumberNeeded = reqPeopleBox; posts.Proficiency = profeciencyBox; posts.DateTime = DateTime.Parse(dateTimeBox); try { string postID = Database.HelloWorldQueryMethods.CreatePostInDataBase(posts); Database.HelloWorldQueryMethods.Involvement involvement = new Database.HelloWorldQueryMethods.Involvement(); involvement.AccountsID = acc.ID; involvement.Posts_PostID = postID; involvement.IsHost = true; Database.HelloWorldQueryMethods.InsertInvolvement(involvement); Response.Redirect("MainPage.aspx"); } catch { } } }
protected void SubmitChanges_ServerClick(object sender, EventArgs e) { acc = Database.HelloWorldQueryMethods.GetAccountFromCookie(this.Request, this.Response); acc.Name = ProfileName.Value.ToString(); Console.WriteLine(acc.Name); acc.Phone = Profile_PhoneNumber.Value.ToString(); acc.Year = Database.HelloWorldQueryMethods.IntfromYear(Profile_Year.Value.ToString()); acc.Desc = Profile_Description.Value.ToString(); acc.Email = ProfileEmail.Value.ToString(); if (Profile_Password.Value != null) { if (Profile_Password.Value.ToString().Equals(Profile_Password1.Value.ToString())) { acc.Password = Profile_Password.Value.ToString(); Success.Visible = true; } else { Error_Flag.Visible = true; } } else { Success.Visible = true; } Database.HelloWorldQueryMethods.UpdateAccount(acc); Edit.Visible = true; SubmitChanges.Visible = false; label1.Visible = false; label2.Visible = false; Profile_Password1.Visible = false; Profile_Password.Visible = false; ProfileName.Attributes.Add("readonly", "readonly"); ProfileEmail.Attributes.Add("readonly", "readonly"); Profile_Description.Attributes.Add("readonly", "readonly"); Profile_PhoneNumber.Attributes.Add("readonly", "readonly"); Profile_Year.Attributes.Add("readonly", "readonly"); Profile_Password.Attributes.Add("readonly", "readonly"); Profile_Password1.Attributes.Add("readonly", "readonly"); }
protected void Page_Load(object sender, EventArgs e) { Error_Flag.Visible = false; Success.Visible = false; profileBtn.Enabled = false; if (!IsPostBack) { //Cookies.WriteCookie("10001", this.Response); string x = Cookies.ReadCookie(this.Request, this.Response); if (String.IsNullOrWhiteSpace(x)) { Response.Redirect("LoginPage.aspx"); } acc = Database.HelloWorldQueryMethods.GetAccountFromCookie(this.Request, this.Response); Edit.Visible = true; SubmitChanges.Visible = false; label1.Visible = false; label2.Visible = false; Profile_Password1.Visible = false; Profile_Password.Visible = false; //Filling in textboxes ProfileName.Value = acc.Name; ProfileEmail.Value = acc.Email; Profile_Description.Value = acc.Desc; Profile_PhoneNumber.Value = acc.Phone; Profile_Year.Value = Database.HelloWorldQueryMethods.YearfromInt(acc.Year); //Making Readonly ProfileName.Attributes.Add("readonly", "readonly"); ProfileEmail.Attributes.Add("readonly", "readonly"); Profile_Description.Attributes.Add("readonly", "readonly"); Profile_PhoneNumber.Attributes.Add("readonly", "readonly"); Profile_Year.Attributes.Add("readonly", "readonly"); Profile_Password.Attributes.Add("readonly", "readonly"); Profile_Password1.Attributes.Add("readonly", "readonly"); } }