Object Oriented System Design Assignment

This assignment showcases the development of a system named LOLSYSTEM using object-oriented programming concepts in C# and ASP.NET. It highlights the implementation of classes, polymorphism, searching children by age group, and a payment functionality with VAT computation. The code includes examples of database interaction using OleDbConnection and demonstrates data retrieval and manipulation through GridView controls.

JUSTIFICATION OF USING.
1.OBJECT ORINTED PRORAMMING.
2.IMPLEMENTING SEARCHING OF CHILDREN AGE GROUPS.
3.IMPLEMETING THE PAYMENT METHODS.

i. Object oriented programming.
The system was developed using the object oriented programming using the C# and asp.net
where class and polymorphism has been used as below.
i. Classes.
The system has used the classes which are the constructs that allows user to have custom
class which is made of collection of the variables methods and the events.
Below is a sample class used in the system.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Data.OleDb;
namespace LOLSYSTEM
{
public partial class parents : System.Web.UI.Page {//the parents class
{//this is the method for loading the data from the data table and display it on a gridview.
protected void Page_Load(object sender, EventArgs e)
{
string con2 = "";
con2 = ConfigurationManager.ConnectionStrings["Conn"].ToString();
OleDbConnection scon = new OleDbConnection(con2);
scon.Open();
OleDbCommand scmd = new OleDbCommand("Select * from PARENTSDETAILS",
scon);

GridView1.DataSource = scmd.ExecuteReader();
GridView1.DataBind();
}
ii. Polymorphism.
The polymorphism is the situation where there is abilities of holding or using multiple forms
of codes and the below is sample code used to implement it.
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// deleting the record from the database
int index = Convert.ToInt32(e.RowIndex);
int index1 = Convert.ToInt32(GridView1.Rows[index].Cells[1].Text);
string conn = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;
using (OleDbConnection scon = new OleDbConnection(conn))
{
using (OleDbCommand scmd = new OleDbCommand("DELETE FROM
PARENTSDETAILS WHERE PARENTSID = @PARENTSID"))
{
scmd.Parameters.AddWithValue("@PARENTSID", index1);
scmd.Connection = scon;
scon.Open();
scmd.ExecuteNonQuery();
scon.Close();
}
}
string con2 = "";
con2 = ConfigurationManager.ConnectionStrings["Conn"].ToString();
OleDbConnection scon2 = new OleDbConnection(con2);
scon2.Open();
OleDbCommand scmd1 = new OleDbCommand("Select * from PARENTSDETAILS",
scon2);
GridView1.DataSource = scmd1.ExecuteReader();

GridView1.DataBind();
}
ii. Searching the children according to age group.
Range 6-10
Range 11-13
Range 13-16

iii. Payments functionarity.
Home page
Parents login

Payment page displays.
Enter the payment details
Enter the payments records.
Compute the VAT by clicking the COMPUTE VAT button.
Click save to get this confirmation message.