07-05-2011, 02:51 PM
Set ExamForm.cs
Code:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace SchoolManagementSystem
{
public partial class SetExamForm : Form
{
OleDbConnection cn = new OleDbConnection(ConnectionStringForSMS.MyConnectionString());
int classid = 0;
int classid1 = 0;
int examid = 0;
string[] val = new string[15];
public SetExamForm()
{
InitializeComponent();
}
private void btnsave_Click(object sender, EventArgs e)
{
try
{
if (cbMedium.SelectedIndex ==-1||cbMedium.SelectedIndex ==0)
{
MessageBox.Show("Select Medium", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbMedium.Focus();
}
else if (cbxclass.SelectedIndex==-1||cbxclass.SelectedIndex==0)
{
MessageBox.Show("Select Class", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxclass.Focus();
}
else if (txtexam.Text.Trim() == "")
{
MessageBox.Show("Enter Examination Name", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtexam.Focus();
}
else
{
cn.Open();
OleDbDataAdapter daclassid = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "' and Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
DataSet dsclassid = new DataSet();
daclassid.Fill(dsclassid);
classid = Convert.ToInt32(dsclassid.Tables[0].Rows[0]["ClassID"].ToString());
OleDbDataAdapter daClassExam = new OleDbDataAdapter("select ClassID,ExamName from Exam where ClassID=" + classid + " and ExamName='" + txtexam.Text + "'and Medium='"+cbMedium.SelectedItem.ToString()+"'", cn);
DataSet dsClassExam = new DataSet();
daClassExam.Fill(dsClassExam);
if (dsClassExam.Tables[0].Rows.Count != 0)
{
MessageBox.Show("Already Exists with same Name");
}
else
{
OleDbDataAdapter daExamID = new OleDbDataAdapter("select max(ExamID) as ExamID from Exam", cn);
DataSet dsExamID = new DataSet();
daExamID.Fill(dsExamID);
if (dsExamID.Tables[0].Rows.Count != 0)
{
string data = dsExamID.Tables[0].Rows[0]["ExamID"].ToString();
if (data == "")
{
examid = 1;
}
else
{
int no = Convert.ToInt32(dsExamID.Tables[0].Rows[0]["ExamID"].ToString());
no = no + 1;
examid = no;
}
}
else
{
examid = 1;
}
OleDbCommand cmd = new OleDbCommand("insert into Exam values(" + examid + ",'" + txtexam.Text.Trim() + "'," + classid + ",'"+cbMedium.SelectedItem.ToString()+"')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Inserted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
pnldisplay.Visible = true;
DataDisplay();
txtexam.Text = "";
txtexam.Focus();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cn.Close();
}
private void ExamEntryForm_Load(object sender, EventArgs e)
{
OleDbDataAdapter da23 = new OleDbDataAdapter("select schooltitle,Address from schooltitle", cn);
DataSet ds23 = new DataSet();
da23.Fill(ds23);
string schooltitle = ds23.Tables[0].Rows[0].ItemArray[0].ToString();
string address = ds23.Tables[0].Rows[0].ItemArray[1].ToString();
this.Text = schooltitle + "-Add ExamName And Marks ";
label4.Text = "";
label4.Text = schooltitle;
cbMedium.SelectedIndex = 0;
lblDelTitle.Visible = false;
pnlDelexam.Visible = false;
pnldisplay.Visible = false;
label7.Visible = false;
pnlmodify.Visible = false;
Munvisiable();
}
public void clear()
{
cbxclass.Text = "-- Select --";
cbMedium.Text = "-- Select --";
txtexam.Text = "";
lblDelTitle.Visible = false;
pnlDelexam.Visible = false;
pnlmodify.Visible = false;
pnldisplay.Visible = false;
txtexam.Enabled = true;
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
cbMedium.SelectedIndex = 0;
cbxclass.SelectedIndex = -1;
}
private void btnmodify_Click(object sender, EventArgs e)
{
try
{
btnsave.Enabled = false;
btnmodify.Enabled = false;
btndelete.Enabled = false;
if (cbMedium.SelectedIndex == -1 || cbMedium.SelectedIndex == 0)
{
MessageBox.Show("Select Medium", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbMedium.Focus();
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
}
else if (cbxclass.SelectedIndex == -1 || cbxclass.SelectedIndex == 0)
{
MessageBox.Show("Select Class", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxclass.Focus();
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
}
else
{
txtexam.Enabled = false;
MtxtClear();
Munvisiable();
pnlmodify.Visible = true;
OleDbDataAdapter daclassid = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "'", cn);
DataSet dsclassid = new DataSet();
daclassid.Fill(dsclassid);
classid = Convert.ToInt32(dsclassid.Tables[0].Rows[0]["ClassID"].ToString());
if (classid != 0)
{
OleDbDataAdapter dasub1 = new OleDbDataAdapter("select ExamName from Exam where ClassID=" + classid + "", cn);
DataSet dssub1 = new DataSet();
dasub1.Fill(dssub1);
int count=dssub1.Tables[0].Rows.Count;
if (count != 0)
{
pnlmodify.Visible = true;
pnldisplay.Visible = false;
pnlDelexam.Visible = false;
btnupdate.Visible = true;
lblMtitle.Text = "";
lblMtitleList.Text = "";
lblMtitle.Text = "Modification of ExamNames in " + cbxclass.SelectedItem.ToString();
lblMtitleList.Text = "ExamName";
if (count == 1)
{
txtMexam1.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
val[0] = txtMexam1.Text;
}
else if (count == 2)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
}
else if (count == 3)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
}
else if (count == 4)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
}
else if (count == 5)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
}
else if (count == 6)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
}
else if (count == 7)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam7.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
txtMexam7.Text = dssub1.Tables[0].Rows[6]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
val[6] = txtMexam7.Text;
}
else if (count == 8)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam7.Visible = true;
txtMexam8.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
txtMexam7.Text = dssub1.Tables[0].Rows[6]["ExamName"].ToString();
txtMexam8.Text = dssub1.Tables[0].Rows[7]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
val[6] = txtMexam7.Text;
val[7] = txtMexam8.Text;
}
else if (count == 9)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam7.Visible = true;
txtMexam8.Visible = true;
txtMexam9.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
txtMexam7.Text = dssub1.Tables[0].Rows[6]["ExamName"].ToString();
txtMexam8.Text = dssub1.Tables[0].Rows[7]["ExamName"].ToString();
txtMexam9.Text = dssub1.Tables[0].Rows[8]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
val[6] = txtMexam7.Text;
val[7] = txtMexam8.Text;
val[8] = txtMexam9.Text;
}
else if (count == 10)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam7.Visible = true;
txtMexam8.Visible = true;
txtMexam9.Visible = true;
txtMexam10.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
txtMexam7.Text = dssub1.Tables[0].Rows[6]["ExamName"].ToString();
txtMexam8.Text = dssub1.Tables[0].Rows[7]["ExamName"].ToString();
txtMexam9.Text = dssub1.Tables[0].Rows[8]["ExamName"].ToString();
txtMexam10.Text = dssub1.Tables[0].Rows[9]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
val[6] = txtMexam7.Text;
val[7] = txtMexam8.Text;
val[8] = txtMexam9.Text;
val[9] = txtMexam10.Text;
}
else if (count == 11)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam7.Visible = true;
txtMexam8.Visible = true;
txtMexam9.Visible = true;
txtMexam10.Visible = true;
txtMexam11.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
txtMexam7.Text = dssub1.Tables[0].Rows[6]["ExamName"].ToString();
txtMexam8.Text = dssub1.Tables[0].Rows[7]["ExamName"].ToString();
txtMexam9.Text = dssub1.Tables[0].Rows[8]["ExamName"].ToString();
txtMexam10.Text = dssub1.Tables[0].Rows[9]["ExamName"].ToString();
txtMexam11.Text = dssub1.Tables[0].Rows[10]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
val[6] = txtMexam7.Text;
val[7] = txtMexam8.Text;
val[8] = txtMexam9.Text;
val[9] = txtMexam10.Text;
val[10] = txtMexam11.Text;
}
else if (count == 12)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam7.Visible = true;
txtMexam8.Visible = true;
txtMexam9.Visible = true;
txtMexam10.Visible = true;
txtMexam11.Visible = true;
txtMexam12.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
txtMexam7.Text = dssub1.Tables[0].Rows[6]["ExamName"].ToString();
txtMexam8.Text = dssub1.Tables[0].Rows[7]["ExamName"].ToString();
txtMexam9.Text = dssub1.Tables[0].Rows[8]["ExamName"].ToString();
txtMexam10.Text = dssub1.Tables[0].Rows[9]["ExamName"].ToString();
txtMexam11.Text = dssub1.Tables[0].Rows[10]["ExamName"].ToString();
txtMexam12.Text = dssub1.Tables[0].Rows[11]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
val[6] = txtMexam7.Text;
val[7] = txtMexam8.Text;
val[8] = txtMexam9.Text;
val[9] = txtMexam10.Text;
val[10] = txtMexam11.Text;
val[11] = txtMexam12.Text;
}
else if (count == 13)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam7.Visible = true;
txtMexam8.Visible = true;
txtMexam9.Visible = true;
txtMexam10.Visible = true;
txtMexam11.Visible = true;
txtMexam12.Visible = true;
txtMexam13.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
txtMexam7.Text = dssub1.Tables[0].Rows[6]["ExamName"].ToString();
txtMexam8.Text = dssub1.Tables[0].Rows[7]["ExamName"].ToString();
txtMexam9.Text = dssub1.Tables[0].Rows[8]["ExamName"].ToString();
txtMexam10.Text = dssub1.Tables[0].Rows[9]["ExamName"].ToString();
txtMexam11.Text = dssub1.Tables[0].Rows[10]["ExamName"].ToString();
txtMexam12.Text = dssub1.Tables[0].Rows[11]["ExamName"].ToString();
txtMexam13.Text = dssub1.Tables[0].Rows[12]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
val[6] = txtMexam7.Text;
val[7] = txtMexam8.Text;
val[8] = txtMexam9.Text;
val[9] = txtMexam10.Text;
val[10] = txtMexam11.Text;
val[11] = txtMexam12.Text;
val[12] = txtMexam13.Text;
}
else if (count == 14)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam7.Visible = true;
txtMexam8.Visible = true;
txtMexam9.Visible = true;
txtMexam10.Visible = true;
txtMexam11.Visible = true;
txtMexam12.Visible = true;
txtMexam13.Visible = true;
txtMexam14.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
txtMexam7.Text = dssub1.Tables[0].Rows[6]["ExamName"].ToString();
txtMexam8.Text = dssub1.Tables[0].Rows[7]["ExamName"].ToString();
txtMexam9.Text = dssub1.Tables[0].Rows[8]["ExamName"].ToString();
txtMexam10.Text = dssub1.Tables[0].Rows[9]["ExamName"].ToString();
txtMexam11.Text = dssub1.Tables[0].Rows[10]["ExamName"].ToString();
txtMexam12.Text = dssub1.Tables[0].Rows[11]["ExamName"].ToString();
txtMexam13.Text = dssub1.Tables[0].Rows[12]["ExamName"].ToString();
txtMexam14.Text = dssub1.Tables[0].Rows[13]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
val[6] = txtMexam7.Text;
val[7] = txtMexam8.Text;
val[8] = txtMexam9.Text;
val[9] = txtMexam10.Text;
val[10] = txtMexam11.Text;
val[11] = txtMexam12.Text;
val[12] = txtMexam13.Text;
val[13] = txtMexam14.Text;
}
else if (count == 15)
{
txtMexam1.Visible = true;
txtMexam2.Visible = true;
txtMexam3.Visible = true;
txtMexam4.Visible = true;
txtMexam5.Visible = true;
txtMexam6.Visible = true;
txtMexam7.Visible = true;
txtMexam8.Visible = true;
txtMexam9.Visible = true;
txtMexam10.Visible = true;
txtMexam11.Visible = true;
txtMexam12.Visible = true;
txtMexam13.Visible = true;
txtMexam14.Visible = true;
txtMexam15.Visible = true;
txtMexam1.Text = dssub1.Tables[0].Rows[0]["ExamName"].ToString();
txtMexam2.Text = dssub1.Tables[0].Rows[1]["ExamName"].ToString();
txtMexam3.Text = dssub1.Tables[0].Rows[2]["ExamName"].ToString();
txtMexam4.Text = dssub1.Tables[0].Rows[3]["ExamName"].ToString();
txtMexam5.Text = dssub1.Tables[0].Rows[4]["ExamName"].ToString();
txtMexam6.Text = dssub1.Tables[0].Rows[5]["ExamName"].ToString();
txtMexam7.Text = dssub1.Tables[0].Rows[6]["ExamName"].ToString();
txtMexam8.Text = dssub1.Tables[0].Rows[7]["ExamName"].ToString();
txtMexam9.Text = dssub1.Tables[0].Rows[8]["ExamName"].ToString();
txtMexam10.Text = dssub1.Tables[0].Rows[9]["ExamName"].ToString();
txtMexam11.Text = dssub1.Tables[0].Rows[10]["ExamName"].ToString();
txtMexam12.Text = dssub1.Tables[0].Rows[11]["ExamName"].ToString();
txtMexam13.Text = dssub1.Tables[0].Rows[12]["ExamName"].ToString();
txtMexam14.Text = dssub1.Tables[0].Rows[13]["ExamName"].ToString();
txtMexam15.Text = dssub1.Tables[0].Rows[14]["ExamName"].ToString();
val[0] = txtMexam1.Text;
val[1] = txtMexam2.Text;
val[2] = txtMexam3.Text;
val[3] = txtMexam4.Text;
val[4] = txtMexam5.Text;
val[5] = txtMexam6.Text;
val[6] = txtMexam7.Text;
val[7] = txtMexam8.Text;
val[8] = txtMexam9.Text;
val[9] = txtMexam10.Text;
val[10] = txtMexam11.Text;
val[11] = txtMexam12.Text;
val[12] = txtMexam13.Text;
val[13] = txtMexam14.Text;
val[14] = txtMexam15.Text;
}
else
{
MessageBox.Show("Your Exam Names more than 15", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
pnlmodify.Visible = false;
pnldisplay.Visible = false;
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
}
//}
}
else
{
MessageBox.Show("No Data Found", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
pnlmodify.Visible = false;
pnldisplay.Visible = false;
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
txtexam.Enabled = true ;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
btnsave.Enabled = true ;
btnmodify.Enabled = true ;
btndelete.Enabled = true;
}
}
private void btndelete_Click(object sender, EventArgs e)
{
try
{
pnlmodify.Visible = false;
pnldisplay.Visible = false;
btnsave.Enabled = false;
btnmodify.Enabled = false;
btndelete.Enabled = false;
if (cbMedium.SelectedIndex == -1 || cbMedium.SelectedIndex == 0)
{
MessageBox.Show("Select Medium", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbMedium.Focus();
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
}
else if (cbxclass.SelectedIndex == -1 || cbxclass.SelectedIndex == 0)
{
MessageBox.Show("Select Class", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbxclass.Focus();
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
}
else
{
txtexam.Enabled = false;
cn.Open();
OleDbDataAdapter daclassid = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "' and Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
DataSet dsclassid = new DataSet();
daclassid.Fill(dsclassid);
classid = Convert.ToInt32(dsclassid.Tables[0].Rows[0]["ClassID"].ToString());
OleDbDataAdapter dasub = new OleDbDataAdapter("select ExamName from Exam where ClassID=" + classid + " and Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
if (dssub.Tables[0].Rows.Count != 0)
{
lblDelTitle.Text = "";
lblDelTitle.Text = "Exam Names in " + cbxclass.SelectedItem.ToString() + " for Deletion.";
checkedListBox1.Visible = true;
checkedListBox1.Items.Clear();
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
checkedListBox1.Items.Add(dssub.Tables[0].Rows[s].ItemArray[0].ToString());
}
btndel.Visible = true;
lblDelTitle.Visible = true;
pnlDelexam.Visible = true;
}
else
{
MessageBox.Show("No Exam Name Found", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
lblDelTitle.Visible = false;
pnlDelexam.Visible = false;
txtexam.Enabled = true;
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
}
cn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Error);
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
txtexam.Enabled = true;
}
}
private void btndel_Click(object sender, EventArgs e)
{
cn.Open();
if (checkedListBox1.CheckedItems.Count != 0)
{
for (int i = 0; i < checkedListBox1.CheckedItems.Count; i++)
{
OleDbDataAdapter daclassid = new OleDbDataAdapter("select ClassID from Exam where ExamName='" + checkedListBox1.CheckedItems[i].ToString() + "' and Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
DataSet dsclassid = new DataSet();
daclassid.Fill(dsclassid);
classid = Convert.ToInt32(dsclassid.Tables[0].Rows[0]["ClassID"].ToString());
OleDbCommand cmd = new OleDbCommand("Delete from Exam where ExamName='" + checkedListBox1.CheckedItems[i].ToString() + "' and ClassID=" + classid + " and Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
cmd.ExecuteNonQuery();
}
MessageBox.Show("Successfully Deleted", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
//clear();
DataDisplay();
}
else
{
MessageBox.Show("Select Any Exam Name", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
cn.Close();
}
private void btnclose_Click(object sender, EventArgs e)
{
this.Close();
}
private void btnclear_Click(object sender, EventArgs e)
{
clear();
lblDelTitle.Visible = false;
pnlDelexam.Visible = false;
pnlmodify.Visible = false;
pnldisplay.Visible = false;
}
private void cbxclass_SelectedIndexChanged(object sender, EventArgs e)
{
lblDelTitle.Visible = false;
pnlDelexam.Visible = false;
pnlmodify.Visible = false;
btnupdate.Visible = false;
btnmodify.Enabled = true;
btnsave.Enabled = true;
DataDisplay();
}
public void DataDisplay()
{
if (cbxclass.SelectedIndex== 0 || cbMedium.SelectedIndex == 0)
{
}
else
{
OleDbDataAdapter daclassid = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "' and Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
DataSet dsclassid = new DataSet();
daclassid.Fill(dsclassid);
if (dsclassid.Tables[0].Rows.Count != 0)
{
classid = Convert.ToInt32(dsclassid.Tables[0].Rows[0]["ClassID"].ToString());
}
btnsave.Enabled = true;
btnmodify.Enabled = true;
btndelete.Enabled = true;
if (classid != 0)
{
txtexam.Enabled = true;
OleDbDataAdapter dasub = new OleDbDataAdapter("select ExamName from Exam where ClassID=" + classid + " and Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
DataSet dssub = new DataSet();
dasub.Fill(dssub);
if (dssub.Tables[0].Rows.Count != 0)
{
pnldisplay.Visible = true;
pnlDelexam.Visible = false;
pnlmodify.Visible = false;
lblExamList.Text = "";
lblList.Text = "";
lblListTitle.Text = "";
lblListTitle.Text = "Exam Names in " + cbxclass.SelectedItem.ToString();
lblList.Text = "";
for (int s = 0; s < dssub.Tables[0].Rows.Count; s++)
{
lblExamList.Text += dssub.Tables[0].Rows[s]["ExamName"].ToString() + "\n";
}
}
else
{
pnldisplay.Visible = false;
pnlDelexam.Visible = false;
pnlmodify.Visible = false;
}
}
}
}
private bool nonNumberEntered = false;
private void txtexam_Leave(object sender, EventArgs e)
{
txtexam.Text = ConnectionStringForSMS.AllCapitalize(txtexam.Text);
}
private void Munvisiable()
{
txtMexam1.Visible = false;
txtMexam2.Visible = false;
txtMexam3.Visible = false;
txtMexam4.Visible = false;
txtMexam5.Visible = false;
txtMexam6.Visible = false;
txtMexam7.Visible = false;
txtMexam8.Visible = false;
txtMexam9.Visible = false;
txtMexam10.Visible = false;
txtMexam11.Visible = false;
txtMexam12.Visible = false;
txtMexam13.Visible = false;
txtMexam14.Visible = false;
txtMexam15.Visible = false;
}
private void MtxtClear()
{
txtMexam1.Text ="";
txtMexam2.Text = "";
txtMexam3.Text = "";
txtMexam4.Text = "";
txtMexam5.Text = "";
txtMexam6.Text = "";
txtMexam7.Text = "";
txtMexam8.Text = "";
txtMexam9.Text = "";
txtMexam10.Text = "";
txtMexam11.Text = "";
txtMexam12.Text = "";
txtMexam13.Text = "";
txtMexam14.Text = "";
txtMexam15.Text = "";
}
private void txtMmin1_KeyDown(object sender, KeyEventArgs e)
{
nonNumberEntered = false;
if (e.KeyCode < Keys.NumPad0 || e.KeyCode > Keys.NumPad9)
{
if (e.KeyCode < Keys.D0 || e.KeyCode > Keys.D9)
{
if (e.KeyCode != Keys.Back)
{
nonNumberEntered = true;
}
}
}
}
private void txtMmin1_KeyPress(object sender, KeyPressEventArgs e)
{
if (nonNumberEntered == true)
{
e.Handled = true;
}
}
private void txtMexam1_Leave(object sender, EventArgs e)
{
txtMexam1.Text = ConnectionStringForSMS.AllCapitalize(txtMexam1.Text);
OleDbDataAdapter daclassid = new OleDbDataAdapter("select ClassID from Class where ClassName='" + cbxclass.SelectedItem.ToString() + "' and Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
DataSet dsclassid = new DataSet();
daclassid.Fill(dsclassid);
classid = Convert.ToInt32(dsclassid.Tables[0].Rows[0]["ClassID"].ToString());
OleDbDataAdapter dd1 = new OleDbDataAdapter("select ExamName from Exam where ClassID="+classid+" and ExamName='" + txtMexam1.Text + "' and Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
DataSet dt1 = new DataSet();
dd1.Fill(dt1);
if (dt1.Tables[0].Rows.Count != 0 && val[0] != txtMexam1.Text)
{
MessageBox.Show("Already Exists with same Class Name in " + cbMedium.SelectedItem.ToString() + " Medium.", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMexam1.Focus();
}
else
{
btnupdate.Focus();
}
}
Note : Same for All Exams like txtMexam2_Leave, txtMexam3_Leave..
private void cbMedium_SelectedIndexChanged(object sender, EventArgs e)
{
OleDbDataAdapter daclass = new OleDbDataAdapter("select ClassName from Class where Medium='" + cbMedium.SelectedItem.ToString() + "'", cn);
DataSet dsclass = new DataSet();
daclass.Fill(dsclass);
cbxclass.Items.Clear();
cbxclass.Items.Add("--Select--");
for (int i = 0; i < dsclass.Tables[0].Rows.Count; i++)
{
cbxclass.Items.Add(dsclass.Tables[0].Rows[i].ItemArray[0].ToString());
}
cbxclass.SelectedIndex = 0;
}
private void pictureBox1_Click(object sender, EventArgs e)
{
this.Close();
SettringsForm s = new SettringsForm();
s.Show();
}
private void pictureBox2_Click(object sender, EventArgs e)
{
this.Close();
SMSMainForm a = new SMSMainForm();
a.Show();
}
}
}