// GET: Exposure/Create
        public ActionResult Create()
        {
            #region Initialisation
            ExposureModel     ExpoM = new ExposureModel();
            ShowroomdbContext ctx   = new ShowroomdbContext();
            var z = serviceA.GetArtworkByIdArtist((int)@Session["LogedUserid"]);
            ExpoM.ArtworksOfArtist = z;
            foreach (var x in ExpoM.ArtworksOfArtist)
            {
                Debug.WriteLine("aaaaaaaaaaaaa" + x.name);
            }
            // ExpoM.Spaces = ServiceS.GetAllSpaves.ToSelectListItems();

            //ViewBag.Spaces = ServiceS.GetMany().Select(x => new SelectListItem {Text = x.name,Value = x.id.ToString()});
            List <space> listSpace = new List <space>();

            #endregion



            return(View(ExpoM));
        }
        // GET: Exposure
        public ActionResult Index()
        {
            IEnumerable <exposure> ListExposure        = service.GetMany();
            List <ExposureModel>   ListExpositionModel = new List <ExposureModel>();
            //service.Archiver();
            ShowroomdbContext cnx = new ShowroomdbContext();


            foreach (exposure ex in cnx.exposures)
            {
                ExposureModel em = new ExposureModel();
                em.id        = ex.id;
                em.startDate = ex.SDate;
                em.endDate   = ex.EDate;
                em.name      = ex.name;
                if (!ex.Archiver)
                {
                    ListExpositionModel.Add(em);
                }
            }

            return(View(ListExpositionModel));
        }
        public ActionResult Create(ExposureModel exM)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    #region Intialisation
                    ShowroomdbContext ctx  = new ShowroomdbContext();
                    exposure          Expo = new exposure();
                    List <artwork>    la   = new List <artwork>();

                    List <ArtworkForExposureModel> ArtForExpo = new List <ArtworkForExposureModel>();
                    ExpositionArtwork ar = new ExpositionArtwork();
                    #endregion
                    #region PopulateExposition
                    Expo.id       = exM.id;
                    Expo.SDate    = exM.startDate;
                    Expo.EDate    = exM.endDate;
                    Expo.name     = exM.name;
                    Expo.Archiver = false;
                    service.Add(Expo);
                    service.Commit();
                    #endregion
                    #region PopulateExposureArtworks

                    var a = exM.Order;

                    Debug.WriteLine(a);

                    int IdEpo = (service.GetIdByName(Expo.name));

                    Debug.WriteLine(IdEpo);
                    DateTime DatePriority = DateTime.Now;
                    Debug.WriteLine(DatePriority);
                    int      FkSpace    = 1;
                    String[] Priorities = a.Split(',');
                    for (int i = 0; i < Priorities.Length; i++)
                    {
                        Debug.WriteLine("idddddddddds" + Priorities[i]);
                        Debug.WriteLine("priiiiiiot" + (i + 1));
                    }

                    for (int i = 0; i < Priorities.Length; i++)
                    {
                        ExpositionArtwork EA = new ExpositionArtwork();
                        EA.exposureId       = IdEpo;
                        EA.DateExpoPriority = DatePriority;
                        EA.fk_space         = FkSpace;
                        EA.artworkId        = Convert.ToInt32(Priorities[i]);
                        EA.Priority         = i + 1;
                        ServiceArt.Add(EA);
                        ServiceArt.Commit();
                    }



                    #endregion

                    return(RedirectToAction("Index"));
                }

                return(View());
            }
            catch
            {
                return(View());
            }
        }