public bool InsertMockSemesterCheck(MockRecordInfoVO MockRecordInfo) //학년에 학기가 있는지 체크
{
string sql = "SELECT COUNT(*) FROM MockRecords WHERE grade=@grade AND semester=@semester AND std_id=@std_id";
MySqlCommand cmd = new MySqlCommand(sql, conn);
FillParameters_MockRecord(cmd, MockRecordInfo);
if (Convert.ToInt32(cmd.ExecuteScalar()) == 1)
{
return(false);
}
else
{
return(true);
}
}
private void FillParameters_MockRecord(MySqlCommand cmd, MockRecordInfoVO MockRecordInfo)
{
MySqlParameter param1 = new MySqlParameter("grade", MySqlDbType.VarChar, 1);
param1.Value = MockRecordInfo.grade;
cmd.Parameters.Add(param1);
MySqlParameter param2 = new MySqlParameter("semester", MySqlDbType.VarChar, 1);
param2.Value = MockRecordInfo.semester;
cmd.Parameters.Add(param2);
MySqlParameter param3 = new MySqlParameter("korean", MySqlDbType.Double);
param3.Value = MockRecordInfo.korean;
cmd.Parameters.Add(param3);
MySqlParameter param4 = new MySqlParameter("english", MySqlDbType.Double);
param4.Value = MockRecordInfo.english;
cmd.Parameters.Add(param4);
MySqlParameter param5 = new MySqlParameter("math", MySqlDbType.Double);
param5.Value = MockRecordInfo.math;
cmd.Parameters.Add(param5);
MySqlParameter param6 = new MySqlParameter("side_choice1", MySqlDbType.Double);
param6.Value = MockRecordInfo.side_choice1;
cmd.Parameters.Add(param6);
MySqlParameter param7 = new MySqlParameter("side_choice2", MySqlDbType.Double);
param7.Value = MockRecordInfo.side_choice2;
cmd.Parameters.Add(param7);
MySqlParameter param8 = new MySqlParameter("more_foreign", MySqlDbType.Double);
param8.Value = MockRecordInfo.more_foreign;
cmd.Parameters.Add(param8);
MySqlParameter param9 = new MySqlParameter("std_id", MySqlDbType.VarChar, 10);
param9.Value = MockRecordInfo.std_Id;
cmd.Parameters.Add(param9);
}
public void InsertMock(MockRecordInfoVO MockRecordInfo)
{
bool bCheck;
bCheck = InsertMockGradeCheck(MockRecordInfo);
if (!bCheck)
{
throw new Exception("해당 학년의 데이터는 이미 있습니다.");
}
bCheck = InsertMockSemesterCheck(MockRecordInfo);
if (!bCheck)
{
throw new Exception("해당 학기의 데이터는 이미 있습니다.");
}
string sql = "INSERT INTO MockRecords(std_id, grade, semester, korean, english, math, side_choice1, side_choice2, more_foreign) " +
"VALUES(@std_id, @grade, @semester, @korean, @english, @math, @side_choice1, @side_choice2, @more_foreign) ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
FillParameters_MockRecord(cmd, MockRecordInfo);
cmd.ExecuteNonQuery();
}
