public string UpdateStudentInfoTable(AddStudentClass addStOb)
{
string ID = null;
connection.Open();
string insertString = "UPDATE Student_Info_Table SET Student_ID='" + addStOb.StudentId + "', St_Name='" + addStOb.StudentName + "',Dept_ID='" + Call_DeptID(addStOb.StudentDept) + "',Year='" + addStOb.StudentYear + "',Semester='" + addStOb.StudentSemester + "', Mobile='" + addStOb.StudentMobile + "',Email='" + addStOb.StudentEmail + "',Password='******' WHERE Student_ID='" + addStOb.StudentId + "'";
SqlCommand command = new SqlCommand(insertString, connection);
command.ExecuteNonQuery();
connection.Close();
connection.Open();
string queryString = "SELECT Student_ID FROM Student_Info_Table WHERE Student_ID='" + addStOb.StudentId + "'";
SqlCommand cmd = new SqlCommand(queryString, connection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ID = reader["Student_ID"].ToString();
}
connection.Close();
return(ID);
}
public int InserIntoStudentInfoTable(AddStudentClass addStudentObj)
{
string ID = null;
connection.Open();
string queryString = "SELECT Student_ID FROM Student_Info_Table WHERE Student_ID=('" + addStudentObj.StudentId + "') ";
SqlCommand cmd = new SqlCommand(queryString, connection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ID = reader["Student_ID"].ToString();
}
connection.Close();
if (ID == addStudentObj.StudentId)
{
return(0);
}
else
{
connection.Open();
string insertString = "INSERT INTO Student_Info_Table VALUES('" + addStudentObj.StudentId + "', '" + addStudentObj.StudentName + "', '" + Call_DeptID(addStudentObj.StudentDept) + "', '" + addStudentObj.StudentYear + "','" + addStudentObj.StudentSemester + "','" + addStudentObj.StudentMobile + "','" + addStudentObj.StudentEmail + "','" + addStudentObj.StudentPassword + "')";
SqlCommand command = new SqlCommand(insertString, connection);
command.ExecuteNonQuery();
connection.Close();
return(1);
}
}
private void stAddButton_Click(object sender, EventArgs e)
{
addStudentObj = new AddStudentClass();
addStudentObj.StudentId = stIdTextBox.Text;
addStudentObj.StudentName = stNameTextBox.Text;
addStudentObj.StudentDept = stDeptComboBox.Text;
addStudentObj.StudentYear = stYearComboBox.Text;
addStudentObj.StudentSemester = stSemesterComboBox.Text;
addStudentObj.StudentMobile = stMobileTextBox.Text;
addStudentObj.StudentEmail = stEmailTextBox.Text;
addStudentObj.StudentPassword = stPassTextBox.Text;
if ((stIdTextBox.Text == "") || (stNameTextBox.Text == "") || (stDeptComboBox.Text == "") || (stYearComboBox.Text == "") || (stSemesterComboBox.Text == " "))
{
MessageBox.Show("Please fill-up all field");
this.Update();
}
else
{
ob = new Gateway();
if (ob.InserIntoStudentInfoTable(addStudentObj) == 1)
{
MessageBox.Show("Information Added Successfully!!!");
stResetButton_Click(sender, e);
}
else
{
MessageBox.Show("Already Added \"" + stNameTextBox.Text + "\"");
}
}
}
private void stUpdateButton_Click(object sender, EventArgs e)
{
addStudentObj = new AddStudentClass();
addStudentObj.StudentId = stIdTextBox.Text;
addStudentObj.StudentName = stNameTextBox.Text;
addStudentObj.StudentDept = stDeptComboBox.Text;
addStudentObj.StudentYear = stYearComboBox.Text;
addStudentObj.StudentSemester = stSemesterComboBox.Text;
addStudentObj.StudentMobile = stMobileTextBox.Text;
addStudentObj.StudentEmail = stEmailTextBox.Text;
addStudentObj.StudentPassword = stPassTextBox.Text;
if (ob.UpdateStudentInfoTable(addStudentObj) == stIdTextBox.Text)
{
MessageBox.Show("Information Updated Successfully!");
ViewStudentProfile_Reset();
}
else
{
MessageBox.Show("Could not Update !");
}
}
