예제 #1
0
 public ActionResult Create(Assignment assignment)
 {
     if (!User.IsInRole("admin"))
     {
         return RedirectToAction("UserProfile", "UserPages", new { UserName = User.Identity.Name });
     }
     if (ModelState.IsValid)
     {
         Assignment.AddAssignment(assignment);
         return RedirectToAction("Index");
     }
     ViewBag.subjects = Assignment.GetSubjects();
     return View(assignment);
 }
예제 #2
0
 public ActionResult CreateSubject(Assignment assign)
 {
     if (!User.IsInRole("admin"))
     {
         return RedirectToAction("UserProfile", "UserPages", new { UserName = User.Identity.Name });
     }
     using (MySqlConnection con = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MySqlConnection"].ConnectionString))
     {
         con.Open();
         var cmd = new MySqlCommand("INSERT INTO subjects VALUES(null, @subject)", con);
         cmd.Parameters.AddWithValue("@subject", assign.SubjectId);
         cmd.ExecuteNonQuery();
     }
     return RedirectToAction("Index", "AdminAssignments");
 }
예제 #3
0
 public static Assignment GetSpecificAssignment(int id)
 {
     using (MySqlConnection con = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MySqlConnection"].ConnectionString))
     {
         con.Open();
         var cmd = new MySqlCommand("SELECT ID, subject, Text, mText, Option1, Option2, Option3, Option4, trueOption, fText, fOption1, fOption2, fOption3, fOption4, truefOption, tText, tOption1, tOption2, tOption3, tOption4, truetOption FROM assignments WHERE ID = ?", con);
         cmd.Parameters.AddWithValue("?", id);
         using (var r = cmd.ExecuteReader())
         {
             var SpecificAssignment = new Assignment();
             if (r.Read())
             {
                 SpecificAssignment.ID          = r.GetInt32(0);
                 SpecificAssignment.SubjectId   = r.GetString(1);
                 SpecificAssignment.Text        = r.GetString(2);
                 SpecificAssignment.mText       = r.GetString(3);
                 SpecificAssignment.Option1     = r.GetString(4);
                 SpecificAssignment.Option2     = r.GetString(5);
                 SpecificAssignment.Option3     = r.GetString(6);
                 SpecificAssignment.Option4     = r.GetString(7);
                 SpecificAssignment.TrueOption  = r.GetInt32(8);
                 SpecificAssignment.fText       = r.GetString(9);
                 SpecificAssignment.fOption1    = r.GetString(10);
                 SpecificAssignment.fOption2    = r.GetString(11);
                 SpecificAssignment.fOption3    = r.GetString(12);
                 SpecificAssignment.fOption4    = r.GetString(13);
                 SpecificAssignment.TruefOption = r.GetInt32(14);
                 SpecificAssignment.tText       = r.GetString(15);
                 SpecificAssignment.tOption1    = r.GetString(16);
                 SpecificAssignment.tOption2    = r.GetString(17);
                 SpecificAssignment.tOption3    = r.GetString(18);
                 SpecificAssignment.tOption4    = r.GetString(19);
                 SpecificAssignment.TruetOption = r.GetInt32(20);
             }
             return SpecificAssignment;
         }
     }
 }
예제 #4
0
 public static Assignment GetAssignment(string UserName)
 {
     using (MySqlConnection con = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MySqlConnection"].ConnectionString))
     {
         con.Open();
         var cmd = new MySqlCommand("SELECT a.ID, subject, Text, mText, Option1, Option2, Option3, Option4, TrueOption, fText, fOption1, fOption2, fOption3, fOption4, TruefOption, tText, tOption1, tOption2, tOption3, tOption4, TruetOption FROM assignments AS a LEFT OUTER JOIN (SELECT * FROM studentassignment WHERE UserName = ?) AS o ON a.id = o.id WHERE o.id IS null ORDER BY rand() limit 1", con);
         cmd.Parameters.AddWithValue("?", UserName);
         using (var r = cmd.ExecuteReader())
         {
             if (r.Read())
             {
                 var RandomAssignment = new Assignment();
                 RandomAssignment.ID          = r.GetInt32(0);
                 RandomAssignment.SubjectId   = r.GetString(1);
                 RandomAssignment.Text        = r.GetString(2);
                 RandomAssignment.mText       = r.GetString(3);
                 RandomAssignment.Option1     = r.GetString(4);
                 RandomAssignment.Option2     = r.GetString(5);
                 RandomAssignment.Option3     = r.GetString(6);
                 RandomAssignment.Option4     = r.GetString(7);
                 RandomAssignment.TrueOption  = r.GetInt32(8);
                 RandomAssignment.fText       = r.GetString(9);
                 RandomAssignment.fOption1    = r.GetString(10);
                 RandomAssignment.fOption2    = r.GetString(11);
                 RandomAssignment.fOption3    = r.GetString(12);
                 RandomAssignment.fOption4    = r.GetString(13);
                 RandomAssignment.TruefOption = r.GetInt32(14);
                 RandomAssignment.tText       = r.GetString(15);
                 RandomAssignment.tOption1    = r.GetString(16);
                 RandomAssignment.tOption2    = r.GetString(17);
                 RandomAssignment.tOption3    = r.GetString(18);
                 RandomAssignment.tOption4    = r.GetString(19);
                 RandomAssignment.TruetOption = r.GetInt32(20);
                 return RandomAssignment;
             }
             Assignment assign = new Assignment();
             return assign;
         }
     }
 }
예제 #5
0
 public static List<Assignment> GetAllAssignments()
 {
     List<Assignment> assignmentList = new List<Assignment>();
     using (MySqlConnection con = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MySqlConnection"].ConnectionString))
     {
         con.Open();
         var cmd = new MySqlCommand("SELECT ID, subject, Text, mText, Option1, Option2, Option3, Option4, trueOption, fText, fOption1, fOption2, fOption3, fOption4, truefOption, tText, tOption1, tOption2, tOption3, tOption4, truetOption FROM assignments", con);
         using (var r = cmd.ExecuteReader())
         {
             while (r.Read())
             {
                 var RandomAssignment = new Assignment();
                 RandomAssignment.ID = r.GetInt32(0);
                 RandomAssignment.SubjectId   = r.GetString(1);
                 RandomAssignment.Text        = r.GetString(2);
                 RandomAssignment.mText       = r.GetString(3);
                 RandomAssignment.Option1     = r.GetString(4);
                 RandomAssignment.Option2     = r.GetString(5);
                 RandomAssignment.Option3     = r.GetString(6);
                 RandomAssignment.Option4     = r.GetString(7);
                 RandomAssignment.TrueOption  = r.GetInt32(8);
                 RandomAssignment.fText       = r.GetString(9);
                 RandomAssignment.fOption1    = r.GetString(10);
                 RandomAssignment.fOption2    = r.GetString(11);
                 RandomAssignment.fOption3    = r.GetString(12);
                 RandomAssignment.fOption4    = r.GetString(13);
                 RandomAssignment.TruefOption = r.GetInt32(14);
                 RandomAssignment.tText       = r.GetString(15);
                 RandomAssignment.tOption1    = r.GetString(16);
                 RandomAssignment.tOption2    = r.GetString(17);
                 RandomAssignment.tOption3    = r.GetString(18);
                 RandomAssignment.tOption4    = r.GetString(19);
                 RandomAssignment.TruetOption = r.GetInt32(20);
                 assignmentList.Add(RandomAssignment);
             }
             return assignmentList;
         }
     }
 }
예제 #6
0
 public static void EditAssignment(Assignment assignment)
 {
     assignment = Assignment.checkAssignment(assignment);
     using (MySqlConnection con = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MySqlConnection"].ConnectionString))
     {
         con.Open();
         var cmd = new MySqlCommand("UPDATE assignments SET subject=@subject, Text=@Text, mText=@mText, Option1=@Option1, Option2=@Option2, Option3=@Option3, Option4=@Option4, trueOption=@trueOption, fText=@fText, fOption1=@fOption1, fOption2=@fOption2, fOption3=@fOption3, fOption4=@fOption4, truefOption=@truefOption, tText=@tText, tOption1=@tOption1, tOption2=@tOption2, tOption3=@tOption3, tOption4=@tOption4, truetOption=@truetOption WHERE ID=@ID", con);
         cmd.Parameters.AddWithValue("@ID",          assignment.ID);
         cmd.Parameters.AddWithValue("@subject",     assignment.SubjectId);
         cmd.Parameters.AddWithValue("@Text",        assignment.Text);
         cmd.Parameters.AddWithValue("@mText",       assignment.mText);
         cmd.Parameters.AddWithValue("@Option1",     assignment.Option1);
         cmd.Parameters.AddWithValue("@Option2",     assignment.Option2);
         cmd.Parameters.AddWithValue("@Option3",     assignment.Option3);
         cmd.Parameters.AddWithValue("@Option4",     assignment.Option4);
         cmd.Parameters.AddWithValue("@trueOption",  assignment.TrueOption);
         cmd.Parameters.AddWithValue("@fText",       assignment.fText);
         cmd.Parameters.AddWithValue("@fOption1",    assignment.fOption1);
         cmd.Parameters.AddWithValue("@fOption2",    assignment.fOption2);
         cmd.Parameters.AddWithValue("@fOption3",    assignment.fOption3);
         cmd.Parameters.AddWithValue("@fOption4",    assignment.fOption4);
         cmd.Parameters.AddWithValue("@truefOption", assignment.TruefOption);
         cmd.Parameters.AddWithValue("@tText",       assignment.tText);
         cmd.Parameters.AddWithValue("@tOption1",    assignment.tOption1);
         cmd.Parameters.AddWithValue("@tOption2",    assignment.tOption2);
         cmd.Parameters.AddWithValue("@tOption3",    assignment.tOption3);
         cmd.Parameters.AddWithValue("@tOption4",    assignment.tOption4);
         cmd.Parameters.AddWithValue("@truetOption", assignment.TruetOption);
         cmd.ExecuteNonQuery();
     }
 }
예제 #7
0
 public static Assignment checkAssignment(Assignment assignment)
 {
     if (assignment.Text      == null){ assignment.Text      = ""; }
     if (assignment.SubjectId == null){ assignment.SubjectId = ""; }
     if (assignment.mText     == null){ assignment.mText     = ""; }
     if (assignment.Option1   == null){ assignment.Option1   = ""; }
     if (assignment.Option2   == null){ assignment.Option2   = ""; }
     if (assignment.Option3   == null){ assignment.Option3   = ""; }
     if (assignment.Option4   == null){ assignment.Option4   = ""; }
     if (assignment.fText     == null){ assignment.fText     = ""; }
     if (assignment.fOption1  == null){ assignment.fOption1  = ""; }
     if (assignment.fOption2  == null){ assignment.fOption2  = ""; }
     if (assignment.fOption3  == null){ assignment.fOption3  = ""; }
     if (assignment.fOption4  == null){ assignment.fOption4  = ""; }
     if (assignment.tText     == null){ assignment.tText     = ""; }
     if (assignment.tOption1  == null){ assignment.tOption1  = ""; }
     if (assignment.tOption2  == null){ assignment.tOption2  = ""; }
     if (assignment.tOption3  == null){ assignment.tOption3  = ""; }
     if (assignment.tOption4  == null){ assignment.tOption4  = ""; }
     return assignment;
 }
예제 #8
0
 public static void AddAssignment(Assignment assignment)
 {
     assignment = Assignment.checkAssignment(assignment);
     using (MySqlConnection con = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MySqlConnection"].ConnectionString))
     {
         con.Open();
         var cmd = new MySqlCommand("INSERT INTO assignments VALUES (null, @subject, @Text, @mText, @Option1, @Option2, @Option3, @Option4, @trueOption, @fText, @fOption1, @fOption2, @fOption3, @fOption4, @truefOption, @tText, @tOption1, @tOption2, @tOption3, @tOption4, @truetOption)", con);
         cmd.Parameters.AddWithValue("@ID",          assignment.ID);
         cmd.Parameters.AddWithValue("@subject",     assignment.SubjectId);
         cmd.Parameters.AddWithValue("@Text",        assignment.Text);
         cmd.Parameters.AddWithValue("@mText",       assignment.mText);
         cmd.Parameters.AddWithValue("@Option1",     assignment.Option1);
         cmd.Parameters.AddWithValue("@Option2",     assignment.Option2);
         cmd.Parameters.AddWithValue("@Option3",     assignment.Option3);
         cmd.Parameters.AddWithValue("@Option4",     assignment.Option4);
         cmd.Parameters.AddWithValue("@trueOption",  assignment.TrueOption);
         cmd.Parameters.AddWithValue("@fText",       assignment.fText);
         cmd.Parameters.AddWithValue("@fOption1",    assignment.fOption1);
         cmd.Parameters.AddWithValue("@fOption2",    assignment.fOption2);
         cmd.Parameters.AddWithValue("@fOption3",    assignment.fOption3);
         cmd.Parameters.AddWithValue("@fOption4",    assignment.fOption4);
         cmd.Parameters.AddWithValue("@truefOption", assignment.TruefOption);
         cmd.Parameters.AddWithValue("@tText",       assignment.tText);
         cmd.Parameters.AddWithValue("@tOption1",    assignment.tOption1);
         cmd.Parameters.AddWithValue("@tOption2",    assignment.tOption2);
         cmd.Parameters.AddWithValue("@tOption3",    assignment.tOption3);
         cmd.Parameters.AddWithValue("@tOption4",    assignment.tOption4);
         cmd.Parameters.AddWithValue("@truetOption", assignment.TruetOption);
         cmd.ExecuteNonQuery();
     }
 }