public ActionResult Save(Link[] links, String mapName, String LevelID, String MapID, String ConceptID) { //String userName = Session["UserName"].ToString(); String userName = "******"; int mapID = int.Parse(MapID); MapOfUser mu = db.MapOfUsers.First(m => m.MapID.Equals(mapID)); mu.MapName = mapName; mu.UserName = userName; mu.ConceptID = ConceptID; mu.LevelID = LevelID; var lms = from l in db.LinkOfMaps where l.MapID.Equals(mapID) select l; foreach (LinkOfMap lm in lms.ToList()) { db.LinkOfMaps.Remove(lm); } for (int i = 0; i < links.Length; i++) { Link li = links[i]; li.Text = db.Links.Find(li.LinkID).Text; if ((li = CheckLink(li)) != null) { LinkOfMap lm = new LinkOfMap(); lm.LinkID = li.LinkID; lm.MapID = mapID; db.LinkOfMaps.Add(lm); } } db.SaveChanges(); return(View()); }
public ActionResult Save(Link[] links, String mapName, String LevelID, String ConceptID) { //String userName = Session["UserName"].ToString(); String userName = "******"; MapOfUser mu = new MapOfUser(); mu.MapName = mapName; mu.UserName = userName; mu.LevelID = LevelID; mu.ConceptID = ConceptID; db.MapOfUsers.Add(mu); db.SaveChanges(); int mapID = db.MapOfUsers.ToList().Last().MapID; for (int i = 0; i < links.Length; i++) { Link li = links[i]; li.Text = db.Links.Find(li.LinkID).Text; if ((li = CheckLink(li)) != null) { LinkOfMap lm = new LinkOfMap(); lm.LinkID = li.LinkID; lm.MapID = mapID; db.LinkOfMaps.Add(lm); } } db.SaveChanges(); return(View()); }
public ActionResult Load(int MapID) { String data = ""; var lis = from lm in db.LinkOfMaps join li in db.Links on lm.LinkID equals li.LinkID join c1 in db.ConceptAlls on li.ConceptID1 equals c1.ConceptID join c2 in db.ConceptAlls on li.ConceptID2 equals c2.ConceptID where lm.MapID.Equals(MapID) select new { ccID1 = li.ConceptID1, cc1 = c1.ConceptName, ccID2 = li.ConceptID2, cc2 = c2.ConceptName, li.LinkID, li.Text }; foreach (var l in lis) { data += l.cc1 + "|" + l.Text + "|" + l.cc2 + "|" + l.ccID1 + "|" + l.LinkID + "|" + l.ccID2 + "__"; } ViewBag.data = data; ViewBag.MapID = MapID; MapOfUser mapOfUser = db.MapOfUsers.FirstOrDefault(mu => mu.MapID.Equals(MapID)); Map m = getMap(mapOfUser.LevelID, mapOfUser.ConceptID); ViewBag.levelID2 = mapOfUser.LevelID; ViewBag.conceptID = mapOfUser.ConceptID; ViewBag.UserName = Session["UserName"]; ViewBag.mapName = mapOfUser.MapName; return(View(m)); }