public void AddSubject(SubjectDTO subjectDTO)
{
try
{
//insertion code
connectionDB.OpenConnection();
string sqlQuery = "insert into Subjects values('" + subjectDTO.CLASSNAME + "','" + subjectDTO.CLASSCODE + "','" + subjectDTO.SUBNAME + "','" + subjectDTO.SUBCODE + "')";
connectionDB.ExecuteQueries(sqlQuery);
connectionDB.CloseConnection();
MessageBox.Show(" added Successfully!!");
}
catch (SqlException ex)
{
if (ex.Number > 0)
{
//Violation of primary key. Handle Exception
connectionDB.CloseConnection();
MessageBox.Show("Class Name or Class Code already exits. Try new one!", "Error..");
}
}
}
public void AddSubject(SubjectDTO subjectDTO)
{
try
{
//insertion code
connectionDB.OpenConnection();
string sqlQuery = "insert into Subjects values('" + subjectDTO.CLASSNAME + "','" + subjectDTO.CLASSCODE + "','" + subjectDTO.SUBNAME + "','" + subjectDTO.SUBCODE + "')";
connectionDB.ExecuteQueries(sqlQuery);
connectionDB.CloseConnection();
MessageBox.Show("Subject added successfully to the database", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (SqlException ex)
{
if (ex.Number > 0)
{
//Violation of primary key. Handle Exception
connectionDB.CloseConnection();
MessageBox.Show("Subject Code already exists. \n Try a new code.", "Insertion Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}