public ActionResult Delete(string id, FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Delete";
try
{
AttributeValueBusinessLayer sbl = new AttributeValueBusinessLayer();
AttributeValue a = sbl.AttributeValues.Where(i => i.ID == id).Single();
//pull data from FormCollection-----------------------------------------------
//a.AttributeValueEntry = (string)collection["AttributeValueEntry"];
//--------------------------------------------------------------------------- -
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", new { SeasonID = a.SeasonID, SFID = a.SFID }));
}
}
catch
{
return(View());
}
}
public ActionResult Delete(int id, FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Delete";
try
{
AttributeBusinessLayer bl = new AttributeBusinessLayer();
BusinessLayerLibrary.Attribute a = bl.Attributes.Where(i => i.AttributeID == 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 Edit(FormCollection collection, string id = "")
{
bool DidItWork = false;
string CrudAction = "Edit";
try
{
UserBusinessLayer bl = new UserBusinessLayer();
User a = bl.Users.Where(p => p.NetworkID == id).Single();
#region Pull from Form Collection
a.TeamID = Convert.ToInt32(collection["ddTeam"]);
#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());
}
}
public ActionResult Edit(int id, FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Edit";
try
{
SeasonBusinessLayer bl = new SeasonBusinessLayer();
Season a = bl.Seasons.Where(p => p.SeasonID == id).Single();
#region Pull from Form Collection
a.SeasonDesc = (string)collection["SeasonDesc"];
a.SeasonActive = Convert.ToInt32(collection["ddActive"]);
a.FirstLaunchDate = Convert.ToDateTime(collection["FirstLaunchDate"]);
a.VAT = Convert.ToDecimal(collection["VAT"]);
a.GBPUSD = Convert.ToDecimal(collection["GBPUSD"]);
a.GBPEUR = Convert.ToDecimal(collection["GBPEUR"]);
#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());
}
}
public ActionResult Create(FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Create";
try
{
Grade a = new Grade();
#region Pull from Form Collection
a.GradeDescription = (string)collection["GradeDescription"];
a.GradeOrder = Convert.ToInt32(collection["GradeOrder"]);
a.PreArticleGrade = Convert.ToInt32(collection["ddPAG"]);
a.WholeGrade = Convert.ToInt32(collection["ddWhole"]);
a.SubCatGrade = Convert.ToInt32(collection["ddSubCat"]);
#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());
}
}
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());
}
}
public ActionResult Delete(int Autoid, FormCollection collection)
{
bool DidItWork = false;
try
{
SpaceAllocationBusinessLayer sbl = new SpaceAllocationBusinessLayer();
SpaceAllocation sa = sbl.SpaceAllocations.Where(i => i.AutoID == Autoid).Single();
StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer();
DidItWork = spbl.ExecuteStoredProcedure(sa, "delete", User.Identity.Name);
//DidItWork = sbl.ActionSpaceAllocation(sa, "delete", User.Identity.Name);
if (DidItWork == false)
{
return(Content("Error on deletion of space allocation. Press back to return and try again"));
}
else
{
return(RedirectToAction("Index", new { SeasonID = sa.SeasonID, GradeID = sa.SpaceGradeID, CatID = sa.CatID }));
}
}
catch
{
return(View());
}
}
public ActionResult Edit(string id, FormCollection collection)
{
bool DidItWork = false;
try
{
AttributeValueBusinessLayer sbl = new AttributeValueBusinessLayer();
AttributeValue a = sbl.AttributeValues.Where(i => i.ID == id).Single();
a.AttributeValueEntry = (string)collection["AttributeValueEntry"];
StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer();
DidItWork = spbl.ExecuteStoredProcedure(a, "Edit", User.Identity.Name);
if (DidItWork == false)
{
return(Content("Error on edit of attribute value. Press back to return and try again"));
}
else
{
return(RedirectToAction("Index", new { SeasonID = a.SeasonID, SFID = a.SFID }));
}
}
catch
{
return(View());
}
}
public ActionResult Create(FormCollection collection)
{
bool DidItWork = false;
try
{
int SFID = Convert.ToInt32(collection["SFID"]);
int SeasonID = Convert.ToInt32(collection["ddSeason"]);
int AttributeID = Convert.ToInt32(collection["ddAttribute"]);
string AttributeValueEntry = (string)collection["AttributeValueEntry"];
AttributeValue NewAV = new AttributeValue();
NewAV.AttributeID = AttributeID;
NewAV.SFID = SFID;
NewAV.SeasonID = SeasonID;
NewAV.AttributeValueEntry = AttributeValueEntry;
//AttributeValueBusinessLayer sbl = new AttributeValueBusinessLayer();
//DidItWork = sbl.InsertAttributeValue(NewAV, User.Identity.Name);
StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer();
DidItWork = spbl.ExecuteStoredProcedure(NewAV, "Create", User.Identity.Name);
if (DidItWork == false)
{
return(Content("Error on creation of Attribute Value. Press back to return and try again"));
}
else
{
return(RedirectToAction("Index", new { Sfid = SFID, SeasonID = SeasonID }));
}
}
catch (Exception x)
{
return(Content("Error on creation of Attribute Value. Press back to return and try again"));
}
}
public ActionResult Delete(string id, FormCollection collection)
{
string CrudAction = "Delete";
bool DidItWork = false;
try
{
PreArticleSeasonalBusinessLayer sbl = new PreArticleSeasonalBusinessLayer();
PreArticleSeasonal r = sbl.PreArticleSeasonals.Where(q => q.ID == id).Single();
StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer();
DidItWork = spbl.ExecuteStoredProcedure(r, CrudAction, User.Identity.Name);
if (DidItWork == false)
{
return(Content("Error on deletion of PreArticleSeasonal. Press back to return and try again"));
}
else
{
return(RedirectToAction("Index", "AttributeValuePivot", new { SeasonID = r.SeasonID }));
}
}
catch
{
return(View());
}
}
public ActionResult Create(FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Create";
try
{
TeamView a = new TeamView();
#region Pull from Form Collection
a.TeamID = Convert.ToInt16(collection["ddTeam"]);
a.ViewID = Convert.ToInt16(collection["ddPivotView"]);
a.ViewDescription = "";
a.TeamDescription = "";
#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());
}
}
public ActionResult Edit(int id, FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Edit";
try
{
SpaceBusinessLayer bl = new SpaceBusinessLayer();
Space a = bl.Spaces.Where(p => p.SpaceID == id).Single();
#region Pull from Form Collection
a.SpaceOrder = Convert.ToInt32(collection["SpaceOrder"]);
a.SpaceDesc = (string)collection["SpaceDesc"];
#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());
}
}
public ActionResult Create(FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Create";
try
{
Cat a = new Cat();
#region Pull from Form Collection
a.CatID = Convert.ToInt32(collection["CatID"]);
a.CatDesc = (string)collection["CatDesc"];
a.CatActive = Convert.ToInt32(collection["ddActive"]);
a.CatOrder = Convert.ToInt32(collection["CatOrder"]);
a.Concept = Convert.ToInt32(collection["ddConcept"]);
a.ShortCode = (string)collection["ShortCode"];
#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());
}
}
public ActionResult Create(FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Create";
try
{
MeType a = new MeType();
#region Pull from Form Collection
a.MeTypeID = -1;
a.MeTypeDesc = (string)collection["MeTypeDesc"];
#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());
}
}
public ActionResult Edit(int id, FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Edit";
try
{
PivotViewBusinessLayer bl = new PivotViewBusinessLayer();
PivotView a = bl.PivotViews(String.Empty).Where(p => p.ViewID == id).Single();
#region Pull from Form Collection
a.ViewDesc = (string)collection["ViewDesc"];
#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());
}
}
public ActionResult Delete(string id, FormCollection collection)
{
bool DidItWork = false;
try
{
AvailableSpaceBusinessLayer sbl = new AvailableSpaceBusinessLayer();
AvailableSpace sa = sbl.AvailableSpaces.Where(i => i.ID == id).Single();
StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer();
DidItWork = spbl.ExecuteStoredProcedure(sa, "Edit", User.Identity.Name);
if (DidItWork == false)
{
return(Content("Error on deletion of available space. Press back to return and try again"));
}
else
{
return(RedirectToAction("Index", new { SeasonID = sa.SeasonID, GradeID = sa.SpaceGradeID, CatID = sa.CatID }));
}
}
catch
{
return(View());
}
}
public ActionResult Create(FormCollection collection)
{
bool DidItWork = false;
try
{
AvailableSpace a = new AvailableSpace();
a.SeasonID = Convert.ToInt32(collection["ddSeason"]);
a.SpaceID = Convert.ToInt32(collection["ddSpace"]);
a.CatID = Convert.ToInt32(collection["ddCat"]);
a.SpaceGradeID = Convert.ToInt32(collection["ddGrade"]);
//AvailableSpaceBusinessLayer bl = new AvailableSpaceBusinessLayer();
//DidItWork = bl.ActionAvailableSpace(a, "Create", User.Identity.Name);
StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer();
DidItWork = spbl.ExecuteStoredProcedure(a, "Create", User.Identity.Name);
if (DidItWork == false)
{
//something went wrong trying to action the PreArticalSeasonald procedure
//return View();
return(Content("Error on creation of Available Space. Press back to return and try again"));
}
else
{
//return View();
return(RedirectToAction("Index", "AvailableSpace", new { SeasonID = a.SeasonID, CatID = a.CatID, SpaceID = a.SpaceID, GradeID = a.SpaceGradeID }));
}
}
catch (Exception x)
{
return(View());
}
}
public ActionResult AddNew(string id, FormCollection collection)
{
bool DidItWork = false;
try
{
SpaceAllocationBusinessLayer sbl = new SpaceAllocationBusinessLayer();
SpaceAllocation sa = sbl.SpaceAllocations.Where(i => i.ID == id).Single();
//SpaceAllocation sa = new SpaceAllocation();
sa.Fill = Convert.ToInt32(collection["Fill"]);
sa.DisplayQuantity = Convert.ToInt32(collection["DisplayQuantity"]);
sa.SFID = Convert.ToInt32(collection["ddPas"]);
sa.MeTypeID = Convert.ToInt32(collection["ddMeType"]);
sa.OrdinalSequence = Convert.ToInt32(collection["OrdinalSequence"]);
StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer();
DidItWork = spbl.ExecuteStoredProcedure(sa, "insert", User.Identity.Name);
//DidItWork = sbl.ActionSpaceAllocation(sa, "insert", User.Identity.Name);
if (DidItWork == false)
{
return(Content("Error on edit of space allocation. Press back to return and try again"));
}
else
{
return(RedirectToAction("Index", new { SeasonID = sa.SeasonID, GradeID = sa.SpaceGradeID, CatID = sa.CatID, FO = sa.FixtureOrdinal }));
}
}
catch
{
return(View());
}
}
public ActionResult Create(FormCollection collection)
{
string CrudAction = "Create";
bool DidItWork = false;
try
{
PreArticleSeasonal SomePreArticalSeasonal = new PreArticleSeasonal();
SomePreArticalSeasonal.SFID = Convert.ToInt32(collection["SFID"]);
SomePreArticalSeasonal.SunflowerDesc = (string)collection["SunflowerDesc"];
SomePreArticalSeasonal.PlmID = (string)collection["PlmID"];
SomePreArticalSeasonal.PlmDescription = (string)collection["PlmDescription"];
SomePreArticalSeasonal.SapArticleID = (string)collection["SapArticleID"];
SomePreArticalSeasonal.SapDescription = (string)collection["SapDescription"];
SomePreArticalSeasonal.SeasonID = Convert.ToInt32(collection["ddSeason"]);
SomePreArticalSeasonal.ProposedPreArticleGradeID = Convert.ToInt32(collection["ddGradeP"]);
SomePreArticalSeasonal.ConfirmedPreArticleGradeID = Convert.ToInt32(collection["ddGradeC"]);
SomePreArticalSeasonal.MerchCatID = Convert.ToInt32(collection["ddMerchCat"]);
SomePreArticalSeasonal.VendorID = (string)collection["ddVendor"];
SomePreArticalSeasonal.ContinuationStatusID = Convert.ToInt32(collection["ddContinue"]);
SomePreArticalSeasonal.ReplacementStatusID = Convert.ToInt32(collection["ddReplacement"]);
SomePreArticalSeasonal.SpaceUseID = (string)collection["ddSpaceUse"];
StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer();
DidItWork = spbl.ExecuteStoredProcedure(SomePreArticalSeasonal, CrudAction, User.Identity.Name);
if (DidItWork == false)
{
//something went wrong trying to action the PreArticalSeasonald procedure
//return View();
return(Content("Error on creation of PreArticalSeasonal. Press back to return and try again"));
}
else
{
//return View();
return(RedirectToAction("Index", "AttributeValuePivot", new { SeasonID = SomePreArticalSeasonal.SeasonID }));
}
}
catch (Exception x)
{
return(View());
}
}
public ActionResult Edit(int id, FormCollection collection)
{
bool DidItWork = false;
string CrudAction = "Edit";
try
{
AttributeBusinessLayer bl = new AttributeBusinessLayer();
BusinessLayerLibrary.Attribute a = bl.Attributes.Where(i => i.AttributeID == id).Single();
#region Pull from Form Collection
a.AttributeDesc = (string)collection["AttributeDesc"];
a.Seasonal = Convert.ToInt32(collection["ddSeasonal"]);
a.AttributeOrder = Convert.ToInt32(collection["AttributeOrder"]);
a.SapName = (string)collection["SapName"];
a.PlmName = (string)collection["PlmName"];
a.DataTypeID = Convert.ToInt32(collection["ddDataType"]);
a.FutureSeasonCascade = Convert.ToInt32(collection["ddCascade"]);
a.Calculated = Convert.ToInt32(collection["ddCalculated"]);
#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());
}
}
public ActionResult Index(FormCollection collection, string submitButton, IEnumerable <string> keys, IEnumerable <decimal> amounts)
{
SpaceAllocationBusinessLayer sbl = new SpaceAllocationBusinessLayer();
if (submitButton == "Retazz LocationID" && keys != null)
{
//read the values for retazz and attempt to realign
for (int i = 0; i < keys.Count(); i++)
{
int NewOrder;
NewOrder = i + 1000 * Convert.ToInt32(amounts.ElementAt(i));
if (sbl.SpaceAllocations.Where(y => y.ID == keys.ElementAt(i) && y.AutoID != 0).Any())
{
SpaceAllocation LoopSA = sbl.SpaceAllocations.Where(y => y.ID == keys.ElementAt(i) && y.AutoID != 0).Single();
LoopSA.OrdinalSequence = NewOrder;
StoredProcedureBusinessLayer spbl = new StoredProcedureBusinessLayer();
Boolean DidUpdateWork = spbl.ExecuteStoredProcedure(LoopSA, "Edit", User.Identity.Name);
//Boolean DidUpdateWork = sbl.ActionSpaceAllocation(LoopSA, "Edit", User.Identity.Name);
}
}
Boolean DidRetazzWork = sbl.RetazzSpaceAllocation();
}
int DeptID = Convert.ToInt32(collection["ddDept"]);
int SeasonID = Convert.ToInt32(collection["ddSeason"]);
int GradeID = Convert.ToInt32(collection["ddGrade"]);
int CatID = Convert.ToInt32(collection["ddCat"]);
int FO = Convert.ToInt32(collection["ddFO"]);
string DeptName;
string CatName = "";
List <SpaceAllocation> ListOfSpaceAllocations = sbl.SpaceAllocations.ToList();
GradeBusinessLayer gbl = new GradeBusinessLayer();
List <Grade> ListOfGrades = gbl.Grades.ToList();
string GradeName = ListOfGrades.Where(q => q.GradeID == GradeID).Single().GradeDescription;
DeptBusinessLayer dbl = new DeptBusinessLayer();
List <Dept> ListOfDepts = dbl.Depts.ToList();
SeasonBusinessLayer ebl = new SeasonBusinessLayer();
List <Season> ListOfSeasons = ebl.Seasons.ToList();
MerchCatBusinessLayer mbl = new MerchCatBusinessLayer();
List <MerchCat> ListOfMerchCats = mbl.MerchCats.Where(w => w.DeptID == DeptID).ToList();
CatBusinessLayer cbl = new CatBusinessLayer();
List <Cat> ListOfCats = cbl.Cats.Where(w => w.CatActive == 1).ToList();
List <Cat> ListOfCatsForDept = ListOfCats.Join(ListOfMerchCats, a => a.CatID, b => b.CatID, (a, b) => new { a, b }).Select(z => z.a).Distinct().ToList();
if (ListOfCatsForDept.Count == 0)
{
CatID = 0;
FO = 0;
}
else
{
if (ListOfCatsForDept.Any(c => c.CatID == CatID) == false)
{
CatID = ListOfCatsForDept.First().CatID;
CatName = ListOfCatsForDept.Where(c => c.CatID == CatID).Single().CatDesc;
}
}
DeptName = ListOfDepts.Where(q => q.DeptID == DeptID).Single().DeptName;
#region StaticData
ViewData["ddSeason"] = ListOfSeasons.Select(m => new SelectListItem {
Value = m.SeasonID.ToString(), Text = m.SeasonDesc + " (" + m.SeasonID.ToString() + ")", Selected = m.SeasonID == SeasonID
});
ViewData["ddGrade"] = ListOfGrades.Select(m => new SelectListItem {
Value = m.GradeID.ToString(), Text = m.GradeDescription, Selected = m.GradeID == GradeID
});
ViewData["ddCat"] = ListOfCatsForDept.Select(m => new SelectListItem {
Value = m.CatID.ToString(), Text = m.CatDesc + " (" + m.CatID.ToString() + ")", Selected = m.CatID == CatID
});
ViewData["ddDept"] = ListOfDepts.Select(m => new SelectListItem {
Value = m.DeptID.ToString(), Text = m.DeptName + " (" + m.DeptID.ToString() + ")", Selected = m.DeptID == DeptID
});
ViewBag.DeptID = DeptID;
ViewBag.DeptName = DeptName;
ViewBag.CatID = CatID;
ViewBag.CatName = CatName;
ViewBag.GradeName = GradeName;
ListOfSpaceAllocations = ListOfSpaceAllocations.Where(z => z.SpaceGradeID == GradeID && z.SeasonID == SeasonID && z.CatID == CatID).OrderBy(w => w.OrdinalSequence).ToList();
if (FO == 0 && ListOfSpaceAllocations.Count > 0)
{
FO = ListOfSpaceAllocations.First().FixtureOrdinal;
}
List <SelectListItem> ListofSelects = new List <SelectListItem>();
ListofSelects = ListOfSpaceAllocations.Select(m => new SelectListItem {
Value = m.FixtureOrdinal.ToString(), Text = m.FixtureName + " (" + m.FixtureOrdinal.ToString() + ")", Selected = m.FixtureOrdinal == FO
}).ToList();
IEnumerable <SelectListItem> ListofSelects2 = ListofSelects;
ListofSelects = ListofSelects.GroupBy(p => p.Value).Select(g => g.First()).ToList();
#endregion
ListOfSpaceAllocations = ListOfSpaceAllocations.Where(z => z.FixtureOrdinal == FO).ToList();
string FixtureName = "";
if (ListOfSpaceAllocations.Count > 0)
{
FixtureName = ListOfSpaceAllocations.First().FixtureName;
}
//fixture ordinals are slightly different to the other drop downs...they are made from the existing data
ViewData["ddFO"] = ListofSelects;
ViewBag.FixtureName = FixtureName;
return(View(ListOfSpaceAllocations));
}