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); }