public ActionResult scriptmanager() { string loginUser = User.Identity.Name; var webmaster = StoreDb.Webmasters.Single(m=>m.Username == loginUser); var website = from w in StoreDb.Websites where (w.WebmasterId == webmaster.Id) select w; List<Script> listscript = new List<Script>(); foreach (var ws in website) { var scritpt = from s in StoreDb.Scripts where s.WebsiteId == ws.Id orderby s.DateGet descending select s; foreach (var sc in scritpt) listscript.Add(sc); } var phonenumber = StoreDb.Parameters.Single(s => s.Name == "PhoneNumber").Value; ViewData["phone"] = phonenumber.ToString(); ScriptViewModel model = new ScriptViewModel() { list = listscript }; TransactionLogViewModel.AddLog("Webmaster: " + User.Identity.Name + " has just gone to the Script Manager!", DateTime.Now); return View(model); }
public ActionResult scriptmanager() { string loginUser = User.Identity.Name; var webmaster = StoreDb.Webmasters.Single(m=>m.Username == loginUser); var website = from w in StoreDb.Websites where (w.WebmasterId == webmaster.Id) select w; List<Script> listscript = new List<Script>(); foreach (var ws in website) { var scritpt = from s in StoreDb.Scripts where s.WebsiteId == ws.Id select s; foreach (var sc in scritpt) listscript.Add(sc); } ScriptViewModel model = new ScriptViewModel() { list = listscript }; return View(model); }