private void courseAddButton_Click(object sender, EventArgs e)
{
addTeacherObj = new AddTeacherClass();
addTeacherObj.TeacherId = teacherIdTextBox.Text;
addTeacherObj.TeacherName = teacherNameTextBox.Text;
addTeacherObj.TeacherDesign = designationTextBox.Text;
addTeacherObj.DeptName = dNameComboBox.Text;
addTeacherObj.Password = passwordTextBox.Text;
if ((teacherIdTextBox.Text == "") || (teacherNameTextBox.Text == "") || (designationTextBox.Text == "") || (dNameComboBox.Text == "") || (passwordTextBox.Text == ""))
{
MessageBox.Show("Please Fill-Up all field");
this.Update();
}
else
{
gateways = new Gateway();
if (gateways.InserIntoTeacherInfoTable(addTeacherObj) == 1)
{
MessageBox.Show("Information Added Successfully!!!");
teacherResetButton_Click(sender, e);
}
else
{
MessageBox.Show("Already Added \"" + teacherNameTextBox.Text + "\"");
}
}
}
public int InserIntoTeacherInfoTable(AddTeacherClass addTeacherObj)
{
string ID = null;
connection.Open();
string queryString = "SELECT Teacher_ID FROM Teacher_Info_Table WHERE Teacher_ID=('" + addTeacherObj.TeacherId + "') ";
SqlCommand cmd = new SqlCommand(queryString, connection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ID = reader["Teacher_ID"].ToString();
}
connection.Close();
if (ID == addTeacherObj.TeacherId)
{
return(0);
}
else
{
connection.Open();
string insertString = "INSERT INTO Teacher_Info_Table VALUES('" + addTeacherObj.TeacherId + "', '" + addTeacherObj.TeacherName + "', '" + addTeacherObj.TeacherDesign + "', '" + Call_DeptID(addTeacherObj.DeptName) + "', '" + addTeacherObj.Password + "')";
SqlCommand command = new SqlCommand(insertString, connection);
command.ExecuteNonQuery();
connection.Close();
return(1);
}
}
public void UpdateTeacherInfoTable(AddTeacherClass addTeacherOb)
{
connection.Open();
string insertString = "UPDATE Teacher_Info_Table SET Teacher_Name='" + addTeacherOb.TeacherName + "', Designation='" + addTeacherOb.TeacherDesign + "',Dept_ID='" + Call_DeptID(addTeacherOb.DeptName) + "',Password='******' WHERE Teacher_ID='" + addTeacherOb.TeacherId + "'";
SqlCommand command = new SqlCommand(insertString, connection);
command.ExecuteNonQuery();
connection.Close();
}
private void teacherUpdateButton_Click(object sender, EventArgs e)
{
addTeacherObj = new AddTeacherClass();
addTeacherObj.TeacherId = teacherIdTextBox.Text;
addTeacherObj.TeacherName = teacherNameTextBox.Text;
addTeacherObj.TeacherDesign = designationTextBox.Text;
addTeacherObj.DeptName = dNameComboBox.Text;
if (teacherIdTextBox.Text == "" || teacherNameTextBox.Text == "" || designationTextBox.Text == "")
{
MessageBox.Show("Could not Update!");
}
else
{
gateways.UpdateTeacherInfoTable(addTeacherObj);
MessageBox.Show("Information Updated Successfully!");
}
}