private void studentFeeCollection_Load(object sender, EventArgs e)
{
textBox1.Enabled = false;
dataGridView1.DataSource = sd.tableData("select * from studentFees");
rl = new radioLoad();
comboBox3.DataSource = rl.mydt("select * from monthNames");
comboBox3.DisplayMember = "title";
comboBox3.ValueMember = "ID";
comboBox1.DataSource = rl.mydt("select * from studentDetails");
comboBox1.DisplayMember = "registrationNo";
comboBox1.ValueMember = "registrationNo";
}
private void feeUpdationBox_Load(object sender, EventArgs e)
{
rad = new radioLoad();
comboBox1.DataSource = rad.mydt("select * from monthNames");
comboBox1.DisplayMember = "title";
comboBox1.ValueMember = "ID";
}
private void humanResources_Load(object sender, EventArgs e)
{
radioLoad rad = new radioLoad();
comboBox2.DataSource = rad.mydt("select * from categoriesFields");
comboBox2.DisplayMember = "title";
comboBox2.ValueMember = "ID";
comboBox1.DataSource = rad.mydt("select * from qualification");
comboBox1.DisplayMember = "title";
comboBox1.ValueMember = "ID";
comboBox4.DataSource = rad.mydt("select * from payScales");
comboBox4.DisplayMember = "title";
comboBox4.ValueMember = "ID";
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox5.Text != "")
{
rad = new radioLoad();
rbc = new returnBookClass();
string query = "select studentID,studentName, titleBook,authorBook,placeLibrary,conditionBook from IssueBooks INNER JOIN addingBooks on addingBooks.serialNo = IssueBooks.bookID where studentID = " + textBox5.Text;
dataGridView1.DataSource = dv.goFill(query).Tables[0];
textBox1.Enabled = true;
textBox2.Enabled = true;
comboBox2.Enabled = true;
comboBox3.Enabled = true;
comboBox2.DataSource = rad.mydt("select * from IssueBooks where studentID = " + textBox5.Text);
comboBox2.DisplayMember = "bookID";
comboBox2.ValueMember = "studentID";
rbc.bookD = comboBox2.Text;
rbc.studentD = textBox5.Text;
}
else
{
MessageBox.Show("Enter Student ID", "Alert!!");
}
textBox2.Text = DateTime.Now.ToString();
}
private void employeeBox_Load(object sender, EventArgs e)
{
qc = new QueriesClass();
string strSQL = "SELECT MAX(Id) as 'LastID' FROM employeeBoxData";
textBox1.Text = qc.GetLastID(strSQL).ToString();
radioLoad rad = new radioLoad();
comboBox1.DataSource = rad.mydt("select * from workCategories");
comboBox1.DisplayMember = "title";
comboBox1.ValueMember = "ID";
comboBox2.DataSource = rad.mydt("select * from payScales");
comboBox2.DisplayMember = "gradeNo";
comboBox2.ValueMember = "ID";
}
private void loginAuthentication_Load(object sender, EventArgs e)
{
radioLoad rl = new radioLoad();
comboBox1.DataSource = rl.mydt("select * from workCategories");
comboBox1.DisplayMember = "title";
comboBox1.ValueMember = "ID";
}
private void employeeSalaries_Load(object sender, EventArgs e)
{
radioLoad rad = new radioLoad();
comboBox1.DataSource = rad.mydt("select * from employeeBoxData");
comboBox1.DisplayMember = "Id";
comboBox1.ValueMember = "Id";
comboBox2.DataSource = rad.mydt("select * from monthNames");
comboBox2.DisplayMember = "title";
comboBox2.ValueMember = "ID";
textBox1.Enabled = false;
textBox2.Enabled = false;
textBox2.Text = DateTime.Now.ToShortDateString();
dg.query = "SELECT * from employeePayments";
dataGridView1.DataSource = dg.goFill().Tables[0];
}
private void checkingStudentFees_Load(object sender, EventArgs e)
{
rl = new radioLoad();
comboBox1.DataSource = rl.mydt("select * from monthNames");
comboBox1.DisplayMember = "title";
comboBox1.ValueMember = "ID";
}
private void renewBook_Load(object sender, EventArgs e)
{
radioLoad rad = new radioLoad();
comboBox1.DataSource = rad.mydt("select * from libraryMembershipForm");
comboBox1.DisplayMember = "registrationNo";
comboBox1.ValueMember = "registrationNo";
}
private void addmisionDepart_Load(object sender, EventArgs e)
{
textBox1.Enabled = false;
textBox3.Enabled = false;
qc = new QueriesClass();
textBox1.Text = qc.returnRollNumber().ToString();
rad = new radioLoad();
aq = new AdmissionQueries();
textBox3.Text = aq.limitSeats();
comboBox1.DataSource = rad.mydt("select * from categoriesFields");
comboBox1.DisplayMember = "title";
comboBox1.ValueMember = "ID";
comboBox4.DataSource = rad.mydt("select * from bloodGroups");
comboBox4.DisplayMember = "title";
comboBox4.ValueMember = "ID";
}
private void libraryMemberShip_Load(object sender, EventArgs e)
{
radioLoad rad = new radioLoad();
comboBox1.DataSource = rad.mydt("select * from studentDetails");
comboBox1.DisplayMember = "registrationNo";
comboBox1.ValueMember = "registrationNo";
textBox2.Text = booksTaken.ToString();
textBox3.Text = maxAllowed.ToString();
}
private void issueBook_Load(object sender, EventArgs e)
{
// dataGridView1.DataSource = dg.goFill().Tables[0];
radioLoad rad = new radioLoad();
comboBox1.DataSource = rad.mydt("select * from libraryMembershipForm");
comboBox1.DisplayMember = "registrationNo";
comboBox1.ValueMember = "registrationNo";
comboBox2.DataSource = rad.mydt("select * from addingBooks");
comboBox2.DisplayMember = "serialNo";
comboBox2.ValueMember = "serialNo";
li = new library();
textBox3.Text = limit.ToString();
textBox4.Text = DateTime.Now.ToShortDateString();
textBox5.Text = DateTime.Now.AddDays(15).ToShortDateString();
}
private void employeeSalaryInformation_Load(object sender, EventArgs e)
{
radioLoad rad = new radioLoad();
comboBox1.DataSource = rad.mydt("select * from employeeBoxData");
comboBox1.DisplayMember = "Id";
comboBox1.ValueMember = "Id";
dg.query = "select * from employeePayments";
dataGridView1.DataSource = dg.goFill().Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
dg = new datagridVeiwWorking();
rb = new returnBookClass();
radioLoad rad = new radioLoad();
dg.query = "SELECT studentID,studentName,serialNo,titleBook,authorBook FROM addingBooks INNER JOIN IssueBooks ON addingBooks.serialNo = IssueBooks.bookID where studentID=" + comboBox1.Text;
dataGridView1.DataSource = dg.goFill().Tables[0];
comboBox2.DataSource = rad.mydt("select * from IssueBooks where studentID = " + comboBox1.Text);
comboBox2.DisplayMember = "bookID";
comboBox2.ValueMember = "studentID";
}
private void addingNewBook_Load(object sender, EventArgs e)
{
textBox1.Enabled = false;
dataGridView1.DataSource = goFill().Tables[0];
qc = new QueriesClass();
string strSQL = "SELECT MAX(serialNo) as 'LastID' FROM addingBooks";
textBox1.Text = qc.GetLastID(strSQL).ToString();
radioLoad rl = new radioLoad();
comboBox1.DataSource = rl.mydt("select * from shelvesLibrary");
comboBox1.DisplayMember = "titleShelves";
comboBox1.ValueMember = "ID";
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox2.SelectedIndex == 0)
{
radioLoad rad = new radioLoad();
comboBox3.DataSource = rad.mydt("select * from artsCourses");
comboBox3.DisplayMember = "title";
comboBox3.ValueMember = "ID";
}
else if (comboBox2.SelectedIndex == 1)
{
radioLoad rad = new radioLoad();
comboBox3.DataSource = rad.mydt("select * from businessCourses");
comboBox3.DisplayMember = "title";
comboBox3.ValueMember = "ID";
}
else if (comboBox2.SelectedIndex == 2)
{
radioLoad rad = new radioLoad();
comboBox3.DataSource = rad.mydt("select * from engeneringCourses");
comboBox3.DisplayMember = "title";
comboBox3.ValueMember = "ID";
}
else if (comboBox2.SelectedIndex == 3)
{
radioLoad rad = new radioLoad();
comboBox3.DataSource = rad.mydt("select * from medicalCourses");
comboBox3.DisplayMember = "title";
comboBox3.ValueMember = "ID";
}
else if (comboBox2.SelectedIndex == 4)
{
radioLoad rad = new radioLoad();
comboBox3.DataSource = rad.mydt("select * from compulsoryCourses");
comboBox3.DisplayMember = "title";
comboBox3.ValueMember = "ID";
}
}