Splash Page Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace School_Management_System
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
int Startpoint = 0;
private void Timer1_Tick(object sender, EventArgs e)
{
Startpoint += 1;
ProgressBar1.Value = Startpoint;
Percentage.Text = Startpoint + “%”;
if (ProgressBar1.Value == 100)
{
ProgressBar1.Value = 0;
Timer1.Stop();
Login Obj = new Login();
this.Hide();
Obj.Show();
}
}
private void Form1_Load(object sender, EventArgs e)
{
Timer1.Start();
}
private void btnClose_Click(object sender, EventArgs e)
{
Application.Exit();
}
}}
Login Page Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace School_Management_System
{
public partial class Login : Form
{
public Login()
{
InitializeComponent();
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (txtUsername.Text == "" || txtPassword.Text == "")
{
MessageBox.Show("Enter Username and Password");
}
else if (txtUsername.Text == "Admin" && txtPassword.Text == "Password")
{
Dashboard Obj = new Dashboard();
Obj.Show();
this.Hide();
}
else
{
MessageBox.Show("Wrong Username and Password");
txtUsername.Text = "";
txtPassword.Text = "";
}
}
private void lblReset_Click(object sender, EventArgs e)
{
txtUsername.Text = "";
txtPassword.Text = "";
}
private void btnExit_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void btnClose_Click(object sender, EventArgs e)
{
Application.Exit();
}
}}
Students Page Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace School_Management_System
{
public partial class Students : Form
{
public Students()
{
InitializeComponent();
DisplayStudent();
}
SqlConnection Con = new SqlConnection(@”Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Pacify Technology\documents\visual studio 2015\Projects\School Management System\School Management System\SchoolDb.mdf;Integrated Security=True”);
private void DisplayStudent()
{
Con.Open();
string Query = “Select * from StudentsTble”;
SqlDataAdapter sda = new SqlDataAdapter(Query, Con);
SqlCommandBuilder Builder = new SqlCommandBuilder(sda);
var ds = new DataSet();
sda.Fill(ds);
DGVStudents.DataSource = ds.Tables[0];
Con.Close();
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtStudentName.Text == “” || txtFatherName.Text == “” || CbGender.SelectedIndex == -1 || CbStandard.SelectedIndex == -1 || txtFees.Text == “” || txtAddress.Text == “”)
{
MessageBox.Show(“Missing Information”);
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand(“Insert into StudentsTble(StName,StFatherName,StGender,StDOB,StStandard,StFees,StAddress) values (@Sname,@SFatherName,@SGender,@SDOB,@SStandard,@SFees,@SAddress)”, Con);
cmd.Parameters.AddWithValue(“@Sname”, txtStudentName.Text);
cmd.Parameters.AddWithValue(“@SFatherName”, txtFatherName.Text);
cmd.Parameters.AddWithValue(“@SGender”, CbGender.SelectedItem.ToString());
cmd.Parameters.AddWithValue(“@SDOB”, DateofBirth.Value.Date);
cmd.Parameters.AddWithValue(“@SStandard”, CbStandard.SelectedItem.ToString());
cmd.Parameters.AddWithValue(“@SFees”, txtFees.Text);
cmd.Parameters.AddWithValue(“@SAddress”, txtAddress.Text);
cmd.ExecuteNonQuery();
MessageBox.Show(“Student Added Successfully”);
Con.Close();
DisplayStudent();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void Reset()
{
Key = 0;
txtStudentName.Text = "";
txtFatherName.Text = "";
txtFees.Text = "";
txtAddress.Text = "";
CbGender.SelectedIndex = 0;
CbStandard.SelectedIndex = 0;
}
int Key = 0;
private void DGVStudents_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
txtStudentName.Text = DGVStudents.SelectedRows[0].Cells[1].Value.ToString();
txtFatherName.Text = DGVStudents.SelectedRows[0].Cells[2].Value.ToString();
CbGender.SelectedItem = DGVStudents.SelectedRows[0].Cells[3].Value.ToString();
DateofBirth.Text = DGVStudents.SelectedRows[0].Cells[4].Value.ToString();
CbStandard.SelectedItem = DGVStudents.SelectedRows[0].Cells[5].Value.ToString();
txtFees.Text = DGVStudents.SelectedRows[0].Cells[6].Value.ToString();
txtAddress.Text = DGVStudents.SelectedRows[0].Cells[7].Value.ToString();
if (txtStudentName.Text == "")
{
Key = 0;
}
else
{
Key = Convert.ToInt32(DGVStudents.SelectedRows[0].Cells[0].Value.ToString());
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtStudentName.Text == "" || txtFatherName.Text == "" || CbGender.SelectedIndex == -1 || CbStandard.SelectedIndex == -1 || txtFees.Text == "" || txtAddress.Text == "")
{
MessageBox.Show("Missing Information");
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand("Update StudentsTble set StName=@Sname,StFatherName=@SFatherName,StGender=@SGender,StDOB=@SDOB,StStandard=@SStandard,StFees=@SFees,StAddress=@SAddress where StId=@StKey", Con);
cmd.Parameters.AddWithValue("@Sname", txtStudentName.Text);
cmd.Parameters.AddWithValue("@SFatherName", txtFatherName.Text);
cmd.Parameters.AddWithValue("@SGender", CbGender.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@SDOB", DateofBirth.Value.Date);
cmd.Parameters.AddWithValue("@SStandard", CbStandard.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@SFees", txtFees.Text);
cmd.Parameters.AddWithValue("@SAddress", txtAddress.Text);
cmd.Parameters.AddWithValue("@StKey", Key);
cmd.ExecuteNonQuery();
MessageBox.Show("Student Updated Successfully");
Con.Close();
DisplayStudent();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (Key == 0)
{
MessageBox.Show("Please Select Student");
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand("delete from StudentsTble where StId=@StKey", Con);
cmd.Parameters.AddWithValue("@StKey", Key);
cmd.ExecuteNonQuery();
MessageBox.Show("Student has been deleted successfully");
Con.Close();
DisplayStudent();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void btnClose_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void btnTeachers_Click(object sender, EventArgs e)
{
Teachers Obj = new Teachers();
Obj.Show();
this.Hide();
}
private void btnAttendance_Click(object sender, EventArgs e)
{
Attendance Obj = new Attendance();
Obj.Show();
this.Hide();
}
private void btnFees_Click(object sender, EventArgs e)
{
Fees Obj = new Fees();
Obj.Show();
this.Hide();
}
private void btnEvents_Click(object sender, EventArgs e)
{
Events Obj = new Events();
Obj.Show();
this.Hide();
}
private void btnDashboard_Click(object sender, EventArgs e)
{
Dashboard Obj = new Dashboard();
Obj.Show();
this.Hide();
}
private void btnLogout_Click(object sender, EventArgs e)
{
Login Obj = new Login();
Obj.Show();
this.Hide();
}
}}
Teachers Page Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace School_Management_System
{
public partial class Teachers : Form
{
public Teachers()
{
InitializeComponent();
DisplayTeachers();
}
SqlConnection Con = new SqlConnection(@”Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Pacify Technology\documents\visual studio 2015\Projects\School Management System\School Management System\SchoolDb.mdf;Integrated Security=True”);
private void DisplayTeachers()
{
Con.Open();
string Query = “Select * from TeachersTble”;
SqlDataAdapter sda = new SqlDataAdapter(Query, Con);
SqlCommandBuilder Builder = new SqlCommandBuilder(sda);
var ds = new DataSet();
sda.Fill(ds);
DGVTeachers.DataSource = ds.Tables[0];
Con.Close();
}
private void Reset()
{
txtTeacherName.Text = “”;
txtFatherName.Text = “”;
CbGender.SelectedIndex = 0;
CbSubject.SelectedIndex = 0;
txtMobileNo.Text = “”;
txtAddress.Text = “”;
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtTeacherName.Text == “” || txtFatherName.Text == “” || txtMobileNo.Text == “” || txtAddress.Text == “” || CbGender.SelectedIndex == -1 || CbSubject.SelectedIndex == -1)
{
MessageBox.Show(“Missing Information”);
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand(“Insert into TeachersTble(TName,TFatherName,TGender,TDOB,TSubject,TMobileNo,TAddress) values (@TName,@TFatherName,@TGender,@TDOB,@TSubject,@TMobileNo,@TAddress)”, Con);
cmd.Parameters.AddWithValue(“@TName”, txtTeacherName.Text);
cmd.Parameters.AddWithValue(“@TFatherName”, txtFatherName.Text);
cmd.Parameters.AddWithValue(“@TGender”, CbGender.SelectedItem.ToString());
cmd.Parameters.AddWithValue(“@TDOB”, DateofBirth.Value.Date);
cmd.Parameters.AddWithValue(“@TSubject”, CbSubject.SelectedItem.ToString());
cmd.Parameters.AddWithValue(“@TMobileNo”, txtMobileNo.Text);
cmd.Parameters.AddWithValue(“@TAddress”, txtAddress.Text);
cmd.ExecuteNonQuery();
MessageBox.Show(“Teacher Added Successfully”);
Con.Close();
DisplayTeachers();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtTeacherName.Text == "" || txtFatherName.Text == "" || txtMobileNo.Text == "" || txtAddress.Text == "" || CbGender.SelectedIndex == -1 || CbSubject.SelectedIndex == -1)
{
MessageBox.Show("Missing Information");
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand("Update TeachersTble set TName=@TName,TFatherName=@TFatherName,TGender=@TGender,TDOB=@TDOB,TSubject=@TSubject,TMobileNo=@TMobileNo,TAddress=@TAddress where TId=@TKey", Con);
cmd.Parameters.AddWithValue("@TName", txtTeacherName.Text);
cmd.Parameters.AddWithValue("@TFatherName", txtFatherName.Text);
cmd.Parameters.AddWithValue("@TGender", CbGender.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@TDOB", DateofBirth.Value.Date);
cmd.Parameters.AddWithValue("@TSubject", CbSubject.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@TMobileNo", txtMobileNo.Text);
cmd.Parameters.AddWithValue("@TAddress", txtAddress.Text);
cmd.Parameters.AddWithValue("@TKey", Key);
cmd.ExecuteNonQuery();
MessageBox.Show("Teacher Updated Successfully");
Con.Close();
DisplayTeachers();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (Key == 0)
{
MessageBox.Show("Please Select Teacher");
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand("delete from TeachersTble where TId=@TKey", Con);
cmd.Parameters.AddWithValue("@TKey", Key);
cmd.ExecuteNonQuery();
MessageBox.Show("Teacher has been deleted successfully");
Con.Close();
DisplayTeachers();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
int Key = 0;
private void DGVTeachers_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
txtTeacherName.Text = DGVTeachers.SelectedRows[0].Cells[1].Value.ToString();
txtFatherName.Text = DGVTeachers.SelectedRows[0].Cells[2].Value.ToString();
CbGender.SelectedItem = DGVTeachers.SelectedRows[0].Cells[3].Value.ToString();
DateofBirth.Text = DGVTeachers.SelectedRows[0].Cells[4].Value.ToString();
CbSubject.SelectedItem = DGVTeachers.SelectedRows[0].Cells[5].Value.ToString();
txtMobileNo.Text = DGVTeachers.SelectedRows[0].Cells[6].Value.ToString();
txtAddress.Text = DGVTeachers.SelectedRows[0].Cells[7].Value.ToString();
if (txtTeacherName.Text == "")
{
Key = 0;
}
else
{
Key = Convert.ToInt32(DGVTeachers.SelectedRows[0].Cells[0].Value.ToString());
}
}
private void btnStudnts_Click(object sender, EventArgs e)
{
Students Obj = new Students();
Obj.Show();
this.Hide();
}
private void btnAttendance_Click(object sender, EventArgs e)
{
Attendance Obj = new Attendance();
Obj.Show();
this.Hide();
}
private void btnFees_Click(object sender, EventArgs e)
{
Fees Obj = new Fees();
Obj.Show();
this.Hide();
}
private void btnEvents_Click(object sender, EventArgs e)
{
Events Obj = new Events();
Obj.Show();
this.Hide();
}
private void btnDashboard_Click(object sender, EventArgs e)
{
Dashboard Obj = new Dashboard();
Obj.Show();
this.Hide();
}
private void btnLogout_Click(object sender, EventArgs e)
{
Login Obj = new Login();
Obj.Show();
this.Hide();
}
private void btnClose_Click(object sender, EventArgs e)
{
Application.Exit();
}
}}
Attendance Page Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace School_Management_System
{
public partial class Attendance : Form
{
public Attendance()
{
InitializeComponent();
DisplayAttendance();
FillStuId();
}
SqlConnection Con = new SqlConnection(@”Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Pacify Technology\documents\visual studio 2015\Projects\School Management System\School Management System\SchoolDb.mdf;Integrated Security=True”);
private void FillStuId()
{
Con.Open();
SqlCommand cmd = new SqlCommand(“select StId from StudentsTble”, Con);
SqlDataReader rdr;
rdr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Columns.Add(“StId”, typeof(int));
dt.Load(rdr);
CbStudentID.ValueMember = “StId”;
CbStudentID.DataSource = dt;
Con.Close();
}
private void GetStudName()
{
Con.Open();
SqlCommand Cmd = new SqlCommand(“select * from StudentsTble where StId=@SID”, Con);
Cmd.Parameters.AddWithValue(“@SID”, CbStudentID.SelectedValue.ToString());
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(Cmd);
sda.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
txtStudentName.Text = dr[“StName”].ToString();
}
Con.Close();
}
private void DisplayAttendance()
{
Con.Open();
string Query = “Select * from AttendanceTble”;
SqlDataAdapter sda = new SqlDataAdapter(Query, Con);
SqlCommandBuilder Builder = new SqlCommandBuilder(sda);
var ds = new DataSet();
sda.Fill(ds);
DGVAttendance.DataSource = ds.Tables[0];
Con.Close();
}
private void Reset()
{
CbAttendanceStatus.SelectedIndex = -1;
txtStudentName.Text = “”;
CbStudentID.SelectedIndex = -1;
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtStudentName.Text == “” || CbAttendanceStatus.SelectedIndex == -1)
{
MessageBox.Show(“Missing Information”);
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand(“Insert into AttendanceTble(AttStId,AttStName,AttDate,AttStatus) values (@StId,@StName,@AttDate,@AttStatus)”, Con);
cmd.Parameters.AddWithValue(“@StId”, CbStudentID.SelectedValue.ToString());
cmd.Parameters.AddWithValue(“@StName”, txtStudentName.Text);
cmd.Parameters.AddWithValue(“@AttDate”, DateofAttendance.Value.Date);
cmd.Parameters.AddWithValue(“@AttStatus”, CbAttendanceStatus.SelectedItem.ToString());
cmd.ExecuteNonQuery();
MessageBox.Show(“Attendance has been taken successfully”);
Con.Close();
DisplayAttendance();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void CbStudentID_SelectionChangeCommitted(object sender, EventArgs e)
{
GetStudName();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtStudentName.Text == "" || CbAttendanceStatus.SelectedIndex == -1)
{
MessageBox.Show("Missing Information");
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand("Update AttendanceTble set AttStId=@StId,AttStName=@StName,AttDate=@AttDate,AttStatus=@AttStatus where AttNum=@AttNum", Con);
cmd.Parameters.AddWithValue("@StId", CbStudentID.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@StName", txtStudentName.Text);
cmd.Parameters.AddWithValue("@AttDate", DateofAttendance.Value.Date);
cmd.Parameters.AddWithValue("@AttStatus", CbAttendanceStatus.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@AttNum", Key);
cmd.ExecuteNonQuery();
MessageBox.Show("Attendance Updated Successfully");
Con.Close();
DisplayAttendance();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
int Key = 0;
private void DGVAttendance_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
CbStudentID.SelectedValue = DGVAttendance.SelectedRows[0].Cells[1].Value.ToString();
txtStudentName.Text = DGVAttendance.SelectedRows[0].Cells[2].Value.ToString();
DateofAttendance.Text = DGVAttendance.SelectedRows[0].Cells[3].Value.ToString();
CbAttendanceStatus.SelectedItem = DGVAttendance.SelectedRows[0].Cells[4].Value.ToString();
if (txtStudentName.Text == "")
{
Key = 0;
}
else
{
Key = Convert.ToInt32(DGVAttendance.SelectedRows[0].Cells[0].Value.ToString());
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
Reset();
}
private void btnStudnts_Click(object sender, EventArgs e)
{
Students Obj = new Students();
Obj.Show();
this.Hide();
}
private void btnTeachers_Click(object sender, EventArgs e)
{
Teachers Obj = new Teachers();
Obj.Show();
this.Hide();
}
private void btnFees_Click(object sender, EventArgs e)
{
Fees Obj = new Fees();
Obj.Show();
this.Hide();
}
private void btnEvents_Click(object sender, EventArgs e)
{
Events Obj = new Events();
Obj.Show();
this.Hide();
}
private void btnDashboard_Click(object sender, EventArgs e)
{
Dashboard Obj = new Dashboard();
Obj.Show();
this.Hide();
}
private void btnLogout_Click(object sender, EventArgs e)
{
Login Obj = new Login();
Obj.Show();
this.Hide();
}
private void btnClose_Click(object sender, EventArgs e)
{
Application.Exit();
}
}}
Fees Page Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace School_Management_System
{
public partial class Fees : Form
{
public Fees()
{
InitializeComponent();
DisplayFees();
FillStuId();
}
SqlConnection Con = new SqlConnection(@”Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Pacify Technology\documents\visual studio 2015\Projects\School Management System\School Management System\SchoolDb.mdf;Integrated Security=True”);
private void DisplayFees()
{
Con.Open();
string Query = “Select * from FeesTble”;
SqlDataAdapter sda = new SqlDataAdapter(Query, Con);
SqlCommandBuilder Builder = new SqlCommandBuilder(sda);
var ds = new DataSet();
sda.Fill(ds);
DGVFees.DataSource = ds.Tables[0];
Con.Close();
}
private void FillStuId()
{
Con.Open();
SqlCommand cmd = new SqlCommand(“select StId from StudentsTble”, Con);
SqlDataReader rdr;
rdr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Columns.Add(“StId”, typeof(int));
dt.Load(rdr);
CbStudentID.ValueMember = “StId”;
CbStudentID.DataSource = dt;
Con.Close();
}
private void GetStudName()
{
Con.Open();
SqlCommand Cmd = new SqlCommand(“select * from StudentsTble where StId=@SID”, Con);
Cmd.Parameters.AddWithValue(“@SID”, CbStudentID.SelectedValue.ToString());
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(Cmd);
sda.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
txtStudentName.Text = dr[“StName”].ToString();
}
Con.Close();
}
private void Reset()
{
txtAmount.Text = “”;
txtStudentName.Text = “”;
CbStudentID.SelectedIndex = -1;
}
private void btnAdd_Click(object sender, EventArgs e)
{
if(txtStudentName.Text == “” || txtAmount.Text == “”)
{
MessageBox.Show(“Missing Information”);
}
else
{
string paymentperiode;
paymentperiode = DateofFees.Value.Month.ToString() + “/” + DateofFees.Value.Year.ToString();
Con.Open();
SqlDataAdapter sda = new SqlDataAdapter(“select COUNT(*) from FeesTble where StId = ‘” + CbStudentID.SelectedValue.ToString() + “‘ and Month = ‘” + paymentperiode.ToString() + “‘”, Con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows[0][0].ToString() == “1”)
{
MessageBox.Show(“There is no due for this Month”);
}
else
{
// Con.Open();
SqlCommand cmd = new SqlCommand(“insert into FeesTble(StId,StName,Month,Amt) values (@SId,@SName,@SMonth,@SAmt)”, Con);
cmd.Parameters.AddWithValue(“@SId”, CbStudentID.SelectedValue.ToString());
cmd.Parameters.AddWithValue(“@SName”, txtStudentName.Text);
cmd.Parameters.AddWithValue(“@SMonth”, paymentperiode);
cmd.Parameters.AddWithValue(“@SAmt”, txtAmount.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Fees Successfully Paid");
}
Con.Close();
DisplayFees();
Reset();
}
}
private void CbStudentID_SelectionChangeCommitted(object sender, EventArgs e)
{
GetStudName();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
}
private void btnDelete_Click(object sender, EventArgs e)
{
Reset();
}
private void btnStudnts_Click(object sender, EventArgs e)
{
Students Obj = new Students();
Obj.Show();
this.Hide();
}
private void btnTeachers_Click(object sender, EventArgs e)
{
Teachers Obj = new Teachers();
Obj.Show();
this.Hide();
}
private void btnAttendance_Click(object sender, EventArgs e)
{
Attendance Obj = new Attendance();
Obj.Show();
this.Hide();
}
private void btnEvents_Click(object sender, EventArgs e)
{
Events Obj = new Events();
Obj.Show();
this.Hide();
}
private void btnDashboard_Click(object sender, EventArgs e)
{
Dashboard Obj = new Dashboard();
Obj.Show();
this.Hide();
}
private void btnLogout_Click(object sender, EventArgs e)
{
Login Obj = new Login();
Obj.Show();
this.Hide();
}
private void btnClose_Click(object sender, EventArgs e)
{
Application.Exit();
}
}}
Events Page Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace School_Management_System
{
public partial class Events : Form
{
public Events()
{
InitializeComponent();
DisplayEvents();
}
SqlConnection Con = new SqlConnection(@”Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Pacify Technology\documents\visual studio 2015\Projects\School Management System\School Management System\SchoolDb.mdf;Integrated Security=True”);
private void DisplayEvents()
{
Con.Open();
string Query = “Select * from EventsTble”;
SqlDataAdapter sda = new SqlDataAdapter(Query, Con);
SqlCommandBuilder Builder = new SqlCommandBuilder(sda);
var ds = new DataSet();
sda.Fill(ds);
DGVEvents.DataSource = ds.Tables[0];
Con.Close();
}
private void Reset()
{
txtEventsName.Text = “”;
txtDuration.Text = “”;
txtAddress.Text = “”;
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtEventsName.Text == “” || txtDuration.Text == “”)
{
MessageBox.Show(“Missing Information”);
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand(“Insert into EventsTble(EDesc,EDate,EDuration,EAddress) values (@EventsDescription,@EventsDate,@EventsDuration,@EventsAddress)”, Con);
cmd.Parameters.AddWithValue(“@EventsDescription”, txtEventsName.Text);
cmd.Parameters.AddWithValue(“@EventsDate”, DateofEvents.Value.Date);
cmd.Parameters.AddWithValue(“@EventsDuration”, txtDuration.Text);
cmd.Parameters.AddWithValue(“@EventsAddress”, txtAddress.Text);
cmd.ExecuteNonQuery();
MessageBox.Show(“Events Added Successfully”);
Con.Close();
DisplayEvents();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtEventsName.Text == "" || txtDuration.Text == "" || txtAddress.Text == "")
{
MessageBox.Show("Missing Information");
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand("Update EventsTble set EDesc=@EDesc,EDate=@EDate,EDuration=@EDuration,EAddress=@EAddress where EId=@EID", Con);
cmd.Parameters.AddWithValue("@EDesc", txtEventsName.Text);
cmd.Parameters.AddWithValue("@EDate", DateofEvents.Value.Date);
cmd.Parameters.AddWithValue("@EDuration", txtDuration.Text);
cmd.Parameters.AddWithValue("@EAddress", txtAddress.Text);
cmd.Parameters.AddWithValue("@EID", Key);
cmd.ExecuteNonQuery();
MessageBox.Show("Event Updated Successfully");
Con.Close();
DisplayEvents();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (Key == 0)
{
MessageBox.Show("Please Select Events");
}
else
{
try
{
Con.Open();
SqlCommand cmd = new SqlCommand("delete from EventsTble where EId=@EKey", Con);
cmd.Parameters.AddWithValue("@EKey", Key);
cmd.ExecuteNonQuery();
MessageBox.Show("Event has been deleted successfully");
Con.Close();
DisplayEvents();
Reset();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
int Key = 0;
private void DGVEvents_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
txtEventsName.Text = DGVEvents.SelectedRows[0].Cells[1].Value.ToString();
DateofEvents.Text = DGVEvents.SelectedRows[0].Cells[2].Value.ToString();
txtDuration.Text = DGVEvents.SelectedRows[0].Cells[3].Value.ToString();
txtAddress.Text = DGVEvents.SelectedRows[0].Cells[4].Value.ToString();
if (txtEventsName.Text == "")
{
Key = 0;
}
else
{
Key = Convert.ToInt32(DGVEvents.SelectedRows[0].Cells[0].Value.ToString());
}
}
private void btnClose_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void btnStudnts_Click(object sender, EventArgs e)
{
Students Obj = new Students();
Obj.Show();
this.Hide();
}
private void btnTeachers_Click(object sender, EventArgs e)
{
Teachers Obj = new Teachers();
Obj.Show();
this.Hide();
}
private void btnAttendance_Click(object sender, EventArgs e)
{
Attendance Obj = new Attendance();
Obj.Show();
this.Hide();
}
private void btnFees_Click(object sender, EventArgs e)
{
Fees Obj = new Fees();
Obj.Show();
this.Hide();
}
private void btnDashboard_Click(object sender, EventArgs e)
{
Dashboard Obj = new Dashboard();
Obj.Show();
this.Hide();
}
private void btnLogout_Click(object sender, EventArgs e)
{
Login Obj = new Login();
Obj.Show();
this.Hide();
}
}}
Dashboard Page Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace School_Management_System
{
public partial class Dashboard : Form
{
public Dashboard()
{
InitializeComponent();
}
SqlConnection Con = new SqlConnection(@”Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Pacify Technology\documents\visual studio 2015\Projects\School Management System\School Management System\SchoolDb.mdf;Integrated Security=True”);
private void CountStudent()
{
Con.Open();
SqlDataAdapter sda = new SqlDataAdapter(“select Count() from StudentsTble”, Con); DataTable dt = new DataTable(); sda.Fill(dt); noofStudents.Text = dt.Rows[0][0].ToString(); Con.Close(); } private void CountTeachers() { Con.Open(); SqlDataAdapter sda = new SqlDataAdapter(“select Count() from TeachersTble”, Con);
DataTable dt = new DataTable();
sda.Fill(dt);
noofTeachers.Text = dt.Rows[0][0].ToString();
Con.Close();
}
private void CountEvents()
{
Con.Open();
SqlDataAdapter sda = new SqlDataAdapter(“select Count(*) from EventsTble”, Con);
DataTable dt = new DataTable();
sda.Fill(dt);
noofEvents.Text = dt.Rows[0][0].ToString();
Con.Close();
}
private void Sumfees()
{
Con.Open();
SqlDataAdapter sda = new SqlDataAdapter(“select Sum(Amt) from FeesTble”, Con);
DataTable dt = new DataTable();
sda.Fill(dt);
lblSumofRupees.Text = dt.Rows[0][0].ToString();
Con.Close();
}
private void Dashboard_Load(object sender, EventArgs e)
{
CountStudent();
CountTeachers();
CountEvents();
Sumfees();
}
private void btnLogout_Click(object sender, EventArgs e)
{
Login Obj = new Login();
Obj.Show();
this.Hide();
}
private void btnStudnts_Click(object sender, EventArgs e)
{
Students Obj = new Students();
Obj.Show();
this.Hide();
}
private void btnTeachers_Click(object sender, EventArgs e)
{
Teachers Obj = new Teachers();
Obj.Show();
this.Hide();
}
private void btnAttendance_Click(object sender, EventArgs e)
{
Attendance Obj = new Attendance();
Obj.Show();
this.Hide();
}
private void btnFees_Click(object sender, EventArgs e)
{
Fees Obj = new Fees();
Obj.Show();
this.Hide();
}
private void btnEvents_Click(object sender, EventArgs e)
{
Events Obj = new Events();
Obj.Show();
this.Hide();
}
private void btnClose_Click(object sender, EventArgs e)
{
Application.Exit();
}
}}