Example #1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Label1.Text       = "Mr:" + " " + Login_page.getParentNameFromDatabase();
     Label_QChild.Text = "Quantity Of Children : " + " " + GetChildQuantity().ToString();
     Label2.Text       = "Total Amount :" + " " + GetTotalAmount().ToString() + " " + "£";
     date           = DateTime.Now.ToString("dd.MM.yyy");
     LabelDate.Text = date;
     TextBox3.Text  = CurrencyConvertor().ToString();
 }
        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 Page_Load(object sender, EventArgs e)
 {
     Label19.Text = "Welcome " + " " + Login_page.getParentNameFromDatabase();
     if (GetDataFromGridView().Rows.Count == 0)
     {
         Label20.Text = "No Child Record Found!!";
     }
     else
     {
         GetDataFromGridView();
     }
 }
Example #4
0
        protected void Button1_payment(object sender, EventArgs e)
        {
            try
            {
                Parent_ID       = Login_page.getParentIDFromDatabase();
                Parent_name     = Label1.Text;
                ChildrenQ       = GetChildQuantity().ToString();
                Total_Amount    = GetTotalAmount().ToString();
                payment_date    = LabelDate.Text;
                inserted_amount = TextBox3.Text;



                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 payment (Parent_ID,Parent_name,ChildrenQ,Total_Amount,payment_date,inserted_amount)values (@Parent_ID,@Parent_name,@ChildrenQ,@Total_Amount,@payment_date,@inserted_amount)");

                cmd.Parameters.AddWithValue("@Parent_ID", Parent_ID);
                cmd.Parameters.AddWithValue("@Parent_name", Parent_name);
                cmd.Parameters.AddWithValue("@ChildrenQ", ChildrenQ);
                cmd.Parameters.AddWithValue("@Total_Amount", Total_Amount);
                cmd.Parameters.AddWithValue("@payment_date", payment_date);
                cmd.Parameters.AddWithValue("@inserted_amount", inserted_amount);



                cmd.Connection = conn;
                cmd.ExecuteNonQuery();

                conn.Close();



                Response.Redirect("ConfirmationPayment.aspx");

                ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Thank you payment completed" + "'); ", true); //alert shown.
            }
            catch (FormatException)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "you already Paid " + "'); ", true); //alert shown.
            }
        }
        public int GetPaymentIDFromDatabaseTable()
        {
            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();

            string        selectQuery = "SELECT * FROM payment WHERE Parent_ID =" + Login_page.getParentIDFromDatabase();
            SqlCommand    comm        = new SqlCommand(selectQuery, conn);
            SqlDataReader mdr         = comm.ExecuteReader();

            if (mdr.Read())
            {
                paymentId = (mdr["payment_id"].ToString());
            }

            conn.Close();

            return(int.Parse(paymentId));
        }
        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.
            }
        }
        public GridView GetDataFromGridView()
        {
            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("select * from points where parent_id ='" + Login_page.boxid + "' AND Parent_Name = '" + Login_page.getParentNameFromDatabase() + "'", conn);

            GridView1.DataSource = cmd.ExecuteReader();
            GridView1.DataBind();

            return(GridView1);
        }
Example #8
0
        public static int GetChildQuantity()
        {
            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();

            string selectQuery = "SELECT COUNT(parentID) FROM child WHERE parentID='" + Login_page.getParentIDFromDatabase() + "';";

            SqlCommand comm  = new SqlCommand(selectQuery, conn);
            Int32      count = Convert.ToInt32(comm.ExecuteScalar());

            if (count > 0)
            {
                AVG = count.ToString();
            }
            else
            {
                AVG = "0";
            }

            conn.Close();

            return(int.Parse(AVG));
        }
Example #9
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Child_Name.Text  = Login_page.getChildNameFromDatabase();
     Parent_Name.Text = AssignParentNameIntoChildProfile();
     Image1.ImageUrl  = SetImageProfile();
 }