public void CreateBatch(BatchDTO batchDTO, ClassDTO classDTO)
{
try
{
//insertion code
connectionDB.OpenConnection();
string sqlQuery = "insert into Batch values('" + classDTO.CLASSNAME + "','" + classDTO.CLASSCODE + "','" + batchDTO.BATCH + "','" + batchDTO.BATCHSTD + "','0','" + batchDTO.BATCHSTD + "')";
connectionDB.ExecuteQueries(sqlQuery);
connectionDB.CloseConnection();
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
//Violation of primary key. Handle Exception
connectionDB.CloseConnection();
MessageBox.Show("You have already added batch " + batchDTO.BATCH + " under " + classDTO.CLASSNAME + ". Try a new one.", "Error..");
}
}
}
public void CreateClass(ClassDTO classDTO)
{
try
{
//insertion code
connectionDB.OpenConnection();
string sqlQuery = "insert into Class values('" + classDTO.CLASSNAME + "','" + classDTO.CLASSCODE + "','" + classDTO.CLASSFEE + "','0','0','0')";
connectionDB.ExecuteQueries(sqlQuery);
connectionDB.CloseConnection();
}
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 CreateClass(ClassDTO classDTO)
{
try
{
//insertion code
connectionDB.OpenConnection();
string sqlQuery = "insert into Class values('" + classDTO.CLASSNAME + "','" + classDTO.CLASSCODE + "','" + classDTO.CLASSFEE + "','0','0','0')";
connectionDB.ExecuteQueries(sqlQuery);
connectionDB.CloseConnection();
MessageBox.Show(classDTO.CLASSNAME + " added to the database successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (SqlException ex)
{
if (ex.Number > 0)
{
//Violation of primary key. Handle Exception
connectionDB.CloseConnection();
MessageBox.Show("Class Name or Class Code Already Exists!", "Insertion Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
