internal static int AddWorkset(Worksets sets)
{
string sql = $"INSERT INTO worksets (WorksetName, GroupID, SetType, ExamStyle, RandomOrdering, Time_Allowed, SetBy, Date_Due. Date_Set)" +
$" VALUES ('{sets.WorksetName}', {sets.GroupID}, {sets.SetType}, {sets.ExamStyle}, {sets.RandomOrdering}, {sets.Time_Allowed}, {sets.SetBy}, '{sets.Date_Due.ToString(MYSQL_DATE_FORMAT)}', '{sets.Date_Set.ToString(MYSQL_DATE_FORMAT)}');";
return(ExecuteSql(sql));
}
internal static Worksets GetWorkset(int worksetID)
{
string sql = $"SELECT * FROM worksets WHERE WorksetID={worksetID};";
var rdr = GetReader(sql);
Worksets ret = null;
if (rdr.Read())
{
ret = new Worksets()
{
WorksetID = rdr.GetInt32("WorksetID"),
WorksetName = rdr.GetString("WorksetName"),
Date_Due = rdr.GetDateTime("Date_Due"),
Date_Set = rdr.GetDateTime("Date_Set"),
ExamStyle = rdr.GetBoolean("ExamStyle"),
RandomOrdering = rdr.GetBoolean("RandomOrdering"),
SetBy = rdr.GetInt32("SetBy"),
SetType = rdr.GetInt32("SetType"),
GroupID = rdr.GetInt32("GroupID"),
Time_Allowed = rdr.GetInt32("Time_Allowed")
};
}
rdr.Close();
return(ret);
}