protected void Page_Load(object sender, EventArgs e) { test_date = DateTime.Now.ToString("dd.MM.yyy"); DateTime dt = DateTime.Now; test_time = dt.ToShortTimeString(); Label19.Text = "Welcome" + " " + Login_page.getChildNameFromDatabase(); lblUsername.Text = " " + totalPonits.ToString(); lbltime.Text = "Time :" + " " + test_time; lbldate.Text = "Date :" + " " + test_date; }
protected void Button2_Click(object sender, EventArgs e) { if (TextBox1.Text == "5") { txt6.Text = ".10"; } else { txt6.Text = "0"; txt6.ForeColor = System.Drawing.Color.Red; } if (TextBox2.Text == "14") { txt7.Text = ".10"; } else { txt7.Text = "0"; txt7.ForeColor = System.Drawing.Color.Red; } if (TextBox3.Text == "9") { txt8.Text = ".10"; } else { txt8.Text = "0"; txt8.ForeColor = System.Drawing.Color.Red; } if (TextBox4.Text == "11") { txt9.Text = ".10"; } else { txt9.Text = "0"; txt9.ForeColor = System.Drawing.Color.Red; } if (TextBox5.Text == "7") { txt10.Text = ".10"; } else { txt10.Text = "0"; txt10.ForeColor = System.Drawing.Color.Red; } point6 = Convert.ToDouble(txt6.Text); point7 = Convert.ToDouble(txt7.Text); point8 = Convert.ToDouble(txt8.Text); point9 = Convert.ToDouble(txt9.Text); point10 = Convert.ToDouble(txt10.Text); totalResult2 = point6 + point7 + point8 + point9 + point10; total2.Text = totalResult2.ToString(); totalPonits = Convert.ToDouble(total1.Text) + Convert.ToDouble(total2.Text); lblUsername.Text = " " + totalPonits.ToString(); PointsColor(); try { child_id = int.Parse(Login_page.child_username); total_points = totalPonits.ToString("P", CultureInfo.InvariantCulture); parent_id = GetParentIDFromChildTable(); child_Name = Login_page.getChildNameFromDatabase(); Parent_Name = GetParentNameFromPointsTable(); SqlConnection conn = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\tumi\source\repos\LearnOnlineSystem\LearnOnlineSystem\App_Data\Learn_Online_System.mdf; Integrated Security = True"); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT into points (child_id,child_Name,test_date,test_time,total_points,parent_id,Parent_Name)values (@child_id,@child_Name,@test_date,@test_time,@total_points,@parent_id,@Parent_Name)"); cmd.Parameters.AddWithValue("@child_id", child_id); cmd.Parameters.AddWithValue("@child_Name", child_Name); cmd.Parameters.AddWithValue("@test_date", test_date); cmd.Parameters.AddWithValue("@test_time", test_time); cmd.Parameters.AddWithValue("@total_points", total_points); cmd.Parameters.AddWithValue("@parent_id", parent_id); cmd.Parameters.AddWithValue("@Parent_Name", Parent_Name); cmd.Connection = conn; cmd.ExecuteNonQuery(); conn.Close(); ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + " Test is Completed Thank you " + Login_page.getChildNameFromDatabase() + "'); ", true); TextBox1.Enabled = false; TextBox2.Enabled = false; TextBox3.Enabled = false; TextBox4.Enabled = false; TextBox5.Enabled = false; } catch (FormatException) { ClientScript.RegisterStartupScript(this.GetType(), "Alert1", "alert('" + "Please Key in all details " + "'); ", true); //alert shown. } }
protected void Page_Load(object sender, EventArgs e) { Child_Name.Text = Login_page.getChildNameFromDatabase(); Parent_Name.Text = AssignParentNameIntoChildProfile(); Image1.ImageUrl = SetImageProfile(); }