public JsonResult AddSTypePortfolio(int id, string name)
 {
     _typePortf = db.TypePortfolioНабор.Find(id);
     _stypePortf.Name = name;
     _stypePortf.Stype = true;
     listPortfolio.Add(_stypePortf);
     _typePortf.TypePortfolio2 = listPortfolio;
     db.TypePortfolioНабор.Add(_stypePortf);
     db.SaveChanges();
     return Json(_portfUsing.GetLocalTypePortfolio());
 }
 public IList<Portfolio> GetPorfolioListFromItem(int id = 0)
 {
     if (id == 0)
         return db.PortfolioНабор.ToList();
     IList<Portfolio> por = new List<Portfolio>();
     _typePortf = db.TypePortfolioНабор.Find(id);
     if (!_typePortf.Stype)
     {
         foreach (var porftolio in _typePortf.TypePortfolio2.Select(element => (from item in db.PortfolioНабор
                                                                                where item.TypePortfolio.ID == element.ID
                                                                                select item)))
         {
             por.AddRange(porftolio.ToList());
         }
     }
     else
     {
         var select = from a in db.PortfolioНабор
                      where a.TypePortfolio.ID == _typePortf.ID
                      select a;
         por = select.ToList();
     }
     return por;
 }
 public ActionResult EditPortfolio(int id = 0)
 {
     portfolio = db.PortfolioНабор.Find(id);
     #region вытаскиваем dropdownlist
     //ViewBag.typePortf = new SelectList(_portfUsing.GetLocalTypePortfolio(), "ID", "Name",portfolio.TypePortfolio.Name);
     List<TypePortfolio> list = new List<TypePortfolio>();
     ViewBag.stypePortf = new SelectList(list, "ID", "Name");
     if (portfolio.TypePortfolio.Stype)
     {
         foreach (var item in from item in db.TypePortfolioНабор where !item.Stype from sitem in item.TypePortfolio2 where sitem.ID == portfolio.TypePortfolio.ID select item)
         {
             _typePortf = item;
         }
         _stypePortf = portfolio.TypePortfolio;
     }
     else
     {
         _typePortf = portfolio.TypePortfolio;
     }
     // TypeDropDownList(_typePortf.ID);
     listPortfolio.AddRange(_typePortf.TypePortfolio2);
     ViewBag.typePortf = new SelectList(_portfUsing.GetLocalTypePortfolio(), "ID", "Name", _typePortf.ID);
     ViewBag.stypePortf = new SelectList(listPortfolio, "ID", "Name", _stypePortf.ID);
     Session["IDportfolio"] = portfolio.ID;
     #endregion
     if (portfolio == null)
     {
         return HttpNotFound();
     }
     return View(portfolio);
 }
 public ActionResult DelTypePortfolio(int id)
 {
     if (id != 0)
     {
         _typePortf = db.TypePortfolioНабор.Find(id);
         if (_typePortf != null)
         {
             if (_typePortf.TypePortfolio2 != null)
             {
                 IEnumerable<TypePortfolio> listStype = _typePortf.TypePortfolio2.ToList();
                 foreach (var port in listStype)
                 {
                     db.TypePortfolioНабор.Remove(port);
                 }
             }
             db.TypePortfolioНабор.Remove(_typePortf);
             db.SaveChanges();
         }
     }
     return null;
 }