// GET: Team public ActionResult Index(int SeasonID = 0) { TeamBusinessLayer sbl = new TeamBusinessLayer(); List <Team> ListOfTeams = sbl.Teams.OrderBy(i => i.TeamDesc).ToList(); return(View(ListOfTeams)); }
public ActionResult Edit(int id, FormCollection collection) { bool DidItWork = false; string CrudAction = "Edit"; try { TeamBusinessLayer bl = new TeamBusinessLayer(); Team a = bl.Teams.Where(p => p.TeamID == id).Single(); #region Pull from Form Collection a.TeamDesc = (string)collection["TeamDesc"]; a.TeamEmail = (string)collection["TeamEmail"]; #endregion StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer(); DidItWork = spbl.ExecuteStoredProcedure(a, CrudAction, User.Identity.Name); if (DidItWork == false) { return(Content(string.Format("Error on {0} of {1}. Press back to return and try again", CrudAction, a.GetType().Name))); } else { return(RedirectToAction("Index")); } } catch { return(View()); } }
// GET: TeamAttributePermission/Create public ActionResult Create() { TeamBusinessLayer tbl = new TeamBusinessLayer(); List <Team> ListOfTeams = tbl.Teams.ToList(); ViewData["ddTeam"] = ListOfTeams.Select(m => new SelectListItem { Value = m.TeamID.ToString(), Text = m.TeamDesc + " (" + m.TeamID.ToString() + ")" }); AttributeBusinessLayer abl = new AttributeBusinessLayer(); List <BusinessLayerLibrary.Attribute> ListOfAttributes = abl.Attributes.Where(w => w.Calculated == 0).OrderBy(o => o.AttributeOrder).ToList(); ViewData["ddAttr"] = ListOfAttributes.Select(m => new SelectListItem { Value = m.AttributeID.ToString(), Text = m.AttributeDesc + " (" + m.AttributeID.ToString() + ")" }); var Items = new HashSet <SelectListItem>(); Items.Add(new SelectListItem { Text = "Yes", Value = "1", Selected = false }); Items.Add(new SelectListItem { Text = "No", Value = "0", Selected = true }); ViewData["ddRead"] = Items; ViewData["ddWrite"] = Items; ViewData["ddNotify"] = Items; ViewData["ddView"] = Items; ViewData["ddPark"] = Items; return(View()); }
// GET: Team/Edit/5 public ActionResult Edit(int id) { TeamBusinessLayer bl = new TeamBusinessLayer(); Team o = bl.Teams.Where(p => p.TeamID == id).Single(); ViewBag.ID = id; return(View(o)); }
// GET: User/Create public ActionResult Create() { TeamBusinessLayer tbl = new TeamBusinessLayer(); List <Team> ListOfTeams = tbl.Teams.ToList(); ViewData["ddTeam"] = ListOfTeams.Select(m => new SelectListItem { Value = m.TeamID.ToString(), Text = m.TeamDesc + " (" + m.TeamID.ToString() + ")" }); return(View()); }
// GET: User/Edit/5 public ActionResult Edit(string id = "") { UserBusinessLayer bl = new UserBusinessLayer(); User o = bl.Users.Where(p => p.NetworkID == id).Single(); TeamBusinessLayer tbl = new TeamBusinessLayer(); List <Team> ListOfTeams = tbl.Teams.ToList(); ViewData["ddTeam"] = ListOfTeams.Select(m => new SelectListItem { Value = m.TeamID.ToString(), Text = m.TeamDesc + " (" + m.TeamID.ToString() + ")", Selected = m.TeamID == o.TeamID }); ViewBag.NetworkID = o.NetworkID; return(View(o)); }
// GET: TeamAttributePermission/Edit/5 public ActionResult Edit(string id) { TeamAttributePermissionBusinessLayer bl = new TeamAttributePermissionBusinessLayer(); TeamAttributePermission o = bl.TeamAttributePermissions.Where(p => p.ID == id).Single(); TeamBusinessLayer tbl = new TeamBusinessLayer(); List <Team> ListOfTeams = tbl.Teams.ToList(); ViewData["ddTeam"] = ListOfTeams.Select(m => new SelectListItem { Value = m.TeamID.ToString(), Text = m.TeamDesc + " (" + m.TeamID.ToString() + ")", Selected = m.TeamID == o.TeamID }); AttributeBusinessLayer abl = new AttributeBusinessLayer(); List <BusinessLayerLibrary.Attribute> ListOfAttributes = abl.Attributes.Where(w => w.Calculated == 0).OrderBy(z => z.AttributeOrder).ToList(); ViewData["ddAttr"] = ListOfAttributes.Select(m => new SelectListItem { Value = m.AttributeID.ToString(), Text = m.AttributeDesc + " (" + m.AttributeID.ToString() + ")", Selected = m.AttributeID == o.AttributeID }); var Items = new HashSet <SelectListItem>(); Items.Add(new SelectListItem { Text = "Yes", Value = "1" }); Items.Add(new SelectListItem { Text = "No", Value = "0" }); ViewData["ddRead"] = Items.Select(m => new SelectListItem { Value = m.Value, Text = m.Text, Selected = o.ReadPermission.ToString() == m.Value }); ViewData["ddWrite"] = Items.Select(m => new SelectListItem { Value = m.Value, Text = m.Text, Selected = o.WritePermission.ToString() == m.Value }); ViewData["ddNotify"] = Items.Select(m => new SelectListItem { Value = m.Value, Text = m.Text, Selected = o.Notify.ToString() == m.Value }); ViewData["ddView"] = Items.Select(m => new SelectListItem { Value = m.Value, Text = m.Text, Selected = o.ViewChange.ToString() == m.Value }); ViewData["ddPark"] = Items.Select(m => new SelectListItem { Value = m.Value, Text = m.Text, Selected = o.ParkForQuarantine.ToString() == m.Value }); ViewBag.ID = id; return(View(o)); }
// GET: TeamView/Create public ActionResult Create() { TeamBusinessLayer t = new TeamBusinessLayer(); List <Team> ListofTeams = t.Teams.ToList(); PivotViewBusinessLayer p = new PivotViewBusinessLayer(); List <PivotView> ListofPivotViews = p.PivotViews(String.Empty).ToList(); ViewData["ddTeam"] = ListofTeams.Select(m => new SelectListItem { Value = m.TeamID.ToString(), Text = m.TeamDesc + " (" + m.TeamID.ToString() + ")" }); ViewData["ddPivotView"] = ListofPivotViews.Select(m => new SelectListItem { Value = m.ViewID.ToString(), Text = m.ViewDesc + " (" + m.ViewID.ToString() + ")" }); return(View()); }