public bool saveTeacherGrade(DataSet.DsPSMS.ST_TEACHER_GRADERow dr, out string msg)
{
bool isOk = true;
if (dr == null)
{
msg = "data is empty ";
return(false);
}
try
{
timedb.Open();
int result = timedb.insertTeacherGrade(dr);
msg = "insert complete";
}
catch
{
msg = "error occurs when inserting data to ST_TEACHER_GRADE table";
return(false);
}
finally
{
timedb.Close();
}
return(isOk);
}
public int insertTeacherGrade(DataSet.DsPSMS.ST_TEACHER_GRADERow dr)
{
int result;
if (dr == null)
{
return(-1);
}
int currentYear = DateTime.Now.Year;
string query = "INSERT INTO ST_TEACHER_GRADE (EDU_YEAR, TEACHER_ID,TEACH_GRADE,TEACH_SUBJECT,DEL_FLG) VALUES (" + currentYear + ",'" + dr.TEACHER_ID + "','" + dr.TEACH_GRADE + "','" + dr.TEACH_SUBJECT + "'," + dr.DEL_FLG + ")";
string sqlQuery = query;
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
return(result);
}
