public ActionResult Delete(string id, FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Delete";
try
{
TeamAttributePermissionBusinessLayer bl = new TeamAttributePermissionBusinessLayer();
TeamAttributePermission a = bl.TeamAttributePermissions.Where(p => p.ID == id).Single();
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());
}
}
public ActionResult Create(FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Create";
try
{
TeamAttributePermission a = new TeamAttributePermission();
#region Pull from Form Collection
a.TeamID = Convert.ToInt32(collection["ddTeam"]);
a.AttributeID = Convert.ToInt32(collection["ddAttr"]);
a.ReadPermission = Convert.ToInt32(collection["ddRead"]);
a.WritePermission = Convert.ToInt32(collection["ddWrite"]);
a.Notify = Convert.ToInt32(collection["ddNotify"]);
a.ViewChange = Convert.ToInt32(collection["ddView"]);
a.ParkForQuarantine = Convert.ToInt32(collection["ddPark"]);
#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/Delete/5
public ActionResult Delete(string id)
{
TeamAttributePermissionBusinessLayer bl = new TeamAttributePermissionBusinessLayer();
TeamAttributePermission o = bl.TeamAttributePermissions.Where(p => p.ID == id).Single();
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));
}
