public ActionResult DeleteRoom(int roomId, int sequencenumber) { if (IsUserLoggedIn()) { Models.MoveToLondon mtl = new Models.MoveToLondon(); List <Room> rooms = mtl.Rooms.Where(o => o.RoomSequence == sequencenumber).ToList(); List <int> roomids = new List <int>(); List <int> photoids = new List <int>(); List <string> photopaths = new List <string>(); foreach (Room room in rooms) { if (!roomids.Contains(room.ID)) { roomids.Add(room.ID); } List <RoomsPhotosBridge> bridges = room.RoomsPhotosBridges.ToList(); foreach (RoomsPhotosBridge bridge in bridges) { if (!photoids.Contains(bridge.PhotoId)) { photoids.Add(bridge.PhotoId); photopaths.Add(bridge.RoomPhoto.Path); } mtl.Entry(bridge).State = System.Data.Entity.EntityState.Deleted; } } mtl.SaveChanges(); mtl = null; mtl = new Models.MoveToLondon(); foreach (int id in roomids) { Room r = new Room(); r.ID = id; mtl.Entry(r).State = System.Data.Entity.EntityState.Deleted; } foreach (int id in photoids) { RoomPhoto rf = new RoomPhoto(); rf.ID = id; mtl.Entry(rf).State = System.Data.Entity.EntityState.Deleted; } //string serverpath = Server.MapPath(@"/"); //foreach (string path in photopaths) //{ //} mtl.SaveChanges(); return(RedirectToAction("roomslist")); } else { return(RedirectToAction("index")); } }
public ActionResult DeleteRoom(int roomId, int sequencenumber) { if (IsUserLoggedIn()) { Models.MoveToLondon mtl = new Models.MoveToLondon(); List<Room> rooms = mtl.Rooms.Where(o => o.RoomSequence == sequencenumber).ToList(); List<int> roomids = new List<int>(); List<int> photoids = new List<int>(); List<string> photopaths = new List<string>(); foreach (Room room in rooms) { if (!roomids.Contains(room.ID)) roomids.Add(room.ID); List<RoomsPhotosBridge> bridges = room.RoomsPhotosBridges.ToList(); foreach (RoomsPhotosBridge bridge in bridges) { if (!photoids.Contains(bridge.PhotoId)) { photoids.Add(bridge.PhotoId); photopaths.Add(bridge.RoomPhoto.Path); } mtl.Entry(bridge).State = System.Data.Entity.EntityState.Deleted; } } mtl.SaveChanges(); mtl = null; mtl = new Models.MoveToLondon(); foreach (int id in roomids) { Room r = new Room(); r.ID = id; mtl.Entry(r).State = System.Data.Entity.EntityState.Deleted; } foreach (int id in photoids) { RoomPhoto rf = new RoomPhoto(); rf.ID = id; mtl.Entry(rf).State = System.Data.Entity.EntityState.Deleted; } //string serverpath = Server.MapPath(@"/"); //foreach (string path in photopaths) //{ //} mtl.SaveChanges(); return RedirectToAction("roomslist"); } else { return RedirectToAction("index"); } }
public ActionResult SaveAd() { if (IsUserLoggedIn()) { try { RoomData rd = Session["RoomsData"] as RoomData; if (rd == null) { return RedirectToAction("index", "admin"); } Models.MoveToLondon mtl = new Models.MoveToLondon(); for (int i = 0; i < rd.Rooms.Count; i++) { for (int j = 0; j < rd.RoomPhotos.Count; j++) { RoomsPhotosBridge rpb = new RoomsPhotosBridge(); rpb.Room = rd.Rooms[i]; rpb.RoomPhoto = rd.RoomPhotos[j]; mtl.Set<RoomsPhotosBridge>().Add(rpb); //rd.Rooms[i].RoomsPhotosBridges.Clear(); //rd.RoomPhotos[j].RoomsPhotosBridges.Clear(); rd.Rooms[i].RoomsPhotosBridges.Add(rpb); rd.RoomPhotos[j].RoomsPhotosBridges.Add(rpb); } } Room r = mtl.Rooms.ToList().Last(); if (r != null) { rd.Rooms[0].RoomSequence = r.ID + 1; rd.Rooms[1].RoomSequence = r.ID + 1; } else { rd.Rooms[0].RoomSequence = 0; rd.Rooms[1].RoomSequence = 0; } foreach (Room room in rd.Rooms) { mtl.Set<Room>().Add(room); } foreach (RoomPhoto photo in rd.RoomPhotos) { mtl.Set<RoomPhoto>().Add(photo); } mtl.SaveChanges(); } catch (Exception ex) { throw; } return RedirectToAction("roomslist"); } else { return RedirectToAction("index"); } }
public ActionResult SaveAd() { if (IsUserLoggedIn()) { try { RoomData rd = Session["RoomsData"] as RoomData; if (rd == null) { return(RedirectToAction("index", "admin")); } Models.MoveToLondon mtl = new Models.MoveToLondon(); for (int i = 0; i < rd.Rooms.Count; i++) { for (int j = 0; j < rd.RoomPhotos.Count; j++) { RoomsPhotosBridge rpb = new RoomsPhotosBridge(); rpb.Room = rd.Rooms[i]; rpb.RoomPhoto = rd.RoomPhotos[j]; mtl.Set <RoomsPhotosBridge>().Add(rpb); //rd.Rooms[i].RoomsPhotosBridges.Clear(); //rd.RoomPhotos[j].RoomsPhotosBridges.Clear(); rd.Rooms[i].RoomsPhotosBridges.Add(rpb); rd.RoomPhotos[j].RoomsPhotosBridges.Add(rpb); } } Room r = mtl.Rooms.ToList().Last(); if (r != null) { rd.Rooms[0].RoomSequence = r.ID + 1; rd.Rooms[1].RoomSequence = r.ID + 1; } else { rd.Rooms[0].RoomSequence = 0; rd.Rooms[1].RoomSequence = 0; } foreach (Room room in rd.Rooms) { mtl.Set <Room>().Add(room); } foreach (RoomPhoto photo in rd.RoomPhotos) { mtl.Set <RoomPhoto>().Add(photo); } mtl.SaveChanges(); } catch (Exception ex) { throw; } return(RedirectToAction("roomslist")); } else { return(RedirectToAction("index")); } }