private void button3_Click(object sender, EventArgs e)
{
string TheCommand = "";
if (textBox1.Text == "" )
{
MessageBox.Show("Roll No cannot be Empty!!!");
}
else
{
TheCommand = "SELECT FullName,ClassCode FROM Student WHERE RollNo = '" + textBox1.Text+"'";
ExcSQL pv = new ExcSQL(2, TheCommand);
textBox2.Text = pv.FullName;
comboBox1.Text = pv.ClassCode;
}
}
private void button1_Click(object sender, EventArgs e)
{
string TheCommand = "";
if(textBox1.Text=="" || this.dateTimePicker1.ToString().Equals(this.dateTimePicker2.ToString()))
{
MessageBox.Show("Please enter valid details");
}
else
{
TheCommand = " IF EXISTS (SELECT * FROM Class WHERE Semester='" + textBox1.Text + "') "
+ "SELECT SemesterId From Class where SemesterId='" + textBox1.Text + "'"
+" ELSE INSERT INTO Semester(SemesterId,Name,StartDate,EndDate) VALUES('" + textBox1.Text.ToString() + "','" + textBox1.Text.ToString() + "','" + Convert.ToDateTime(this.dateTimePicker1.Text) + "','" + Convert.ToDateTime(this.dateTimePicker2.Text) + "')";
ExcSQL pv = new ExcSQL(1,TheCommand);
}
}
private void button3_Click(object sender, EventArgs e)
{
string TheCommand = "";
if (textBox1.Text == "")
{
MessageBox.Show("Roll No cannot be Empty!!!");
}
else
{
TheCommand = "SELECT SemesterId,SemesterNo,Status_ FROM StudentStatus WHERE RollNo = '" + textBox1.Text + "'";
ExcSQL pv = new ExcSQL(3, TheCommand);
comboBox1.Text = pv.SemesterName;
textBox2.Text = pv.SemesterNo;
comboBox2.Text = pv.Status;
}
}
private void button1_Click(object sender, EventArgs e)
{
string TheCommand = "";
if (textBox1.Text == "" || textBox2.Text == "" || comboBox1.SelectedIndex < 0 || comboBox2.SelectedIndex < 0)
{
MessageBox.Show("All fields must be filled!!!");
}
else
{
TheCommand = " IF EXISTS (SELECT * FROM StudentStatus WHERE RollNo='" + textBox1.Text+"') "
+"SELECT RollNo From StudentStatus where RollNo='" + textBox1.Text+"'"
+" ELSE INSERT INTO StudentStatus(RollNo,SemesterId,SemesterNo,Status_) Values ('"
+ textBox1.Text +"','" + comboBox1.SelectedItem.ToString() +"','"+ textBox2.Text + "','" + comboBox2.SelectedItem.ToString() + "')";
ExcSQL pv = new ExcSQL(4,TheCommand);
}
}
private void button1_Click(object sender, EventArgs e)
{
string TheCommand = "";
if (textBox1.Text == "" )
{
MessageBox.Show("You must Enter a rollno!!!");
}
else
{
TheCommand = "update StudentStatus set "
+"SemesterId = '"+comboBox2.Text+"', SemesterNo = "
+textBox3.Text+ ", Status_ = '"+comboBox3.Text+ "' WHERE ROllNo = '"
+textBox1.Text+"'";
ExcSQL pv = new ExcSQL(1,TheCommand);
}
}
private void button1_Click(object sender, EventArgs e)
{
string TheCommand="";
if(textBox1.Text=="" || textBox2.Text=="" || comboBox1.SelectedIndex<0 )
{
MessageBox.Show("All fields must be filled!!!");
}
else
{
TheCommand = " IF EXISTS (SELECT * FROM Class WHERE ClassCode='" + textBox1.Text+"') "
+"SELECT ClassCode From Class where ClassCode='" + textBox1.Text+"'"
+" ELSE INSERT INTO Class(ClassCode,Batch,Major) Values "+
"('" + textBox1.Text +
"'," + "'" + textBox2.Text + "','" + comboBox1.SelectedItem.ToString()+"')";
ExcSQL pv = new ExcSQL(4,TheCommand);
}
}
private void button1_Click(object sender, EventArgs e)
{
string TheCommand = "";
if (textBox1.Text == "" || textBox2.Text == "" || comboBox1.SelectedIndex < 0 || comboBox2.SelectedIndex < 0)
{
MessageBox.Show("All fields must be filled!!!");
}
else
{
TheCommand = " IF EXISTS (SELECT * FROM Class WHERE Student='" + textBox1.Text+"') "
+"SELECT RollNo From Class where RollNo='" + textBox1.Text+"'"
+" ELSE INSERT INTO Student(RollNo,ClassCode,FullName,Nationality) Values " +
"('" + textBox1.Text + "','" + comboBox2.SelectedItem.ToString() +
"'," + "'" + textBox2.Text + "','" + comboBox1.SelectedItem.ToString() + "')";
ExcSQL pv = new ExcSQL(4,TheCommand);
}
}