public void InsertInActiveSubject(InactiveSubject InactiveSubject)
{
using (OracleConnection con = new OracleConnection(OracleUtility.conString))
{
con.Open();
var cmd = con.CreateCommand();
cmd.CommandText = $"INSERT INTO {OracleDbTableName.InactiveSubject} " +
$"VALUES(:Id,:SubjectCode,:SubjectName,:CreateDateTime,:IsEReadiness,:ContentLanguage,:SiteId," +
$":ExamSuiteCount,:QuestionCount,:ExamSuiteAcceptCount,:ExamSuiteRejectCount)";
cmd.Parameters.Add("Id", InactiveSubject._id);
cmd.Parameters.Add("SubjectCode", InactiveSubject.SubjectCode);
cmd.Parameters.Add("SubjectName", InactiveSubject.SubjectName);
cmd.Parameters.Add("CreateDateTime", InactiveSubject.CreateDateTime);
cmd.Parameters.Add("IsEReadiness", InactiveSubject.IsEReadiness.ToString());
cmd.Parameters.Add("ContentLanguage", InactiveSubject.ContentLanguage);
cmd.Parameters.Add("SiteId", InactiveSubject.SiteId);
cmd.Parameters.Add("ExamSuiteCount", InactiveSubject.ExamSuiteCount);
cmd.Parameters.Add("QuestionCount", InactiveSubject.QuestionCount);
cmd.Parameters.Add("ExamSuiteAcceptCount", InactiveSubject.ExamSuiteAcceptCount);
cmd.Parameters.Add("ExamSuiteRejectCount", InactiveSubject.ExamSuiteRejectCount);
cmd.ExecuteNonQuery();
}
}
public void UpsertInactiveSubject(InactiveSubject inactiveSubject)
{
throw new NotImplementedException();
}
