// GET: SpaceAllocation/Edit/5
public ActionResult AddNew(string id)
{
SpaceAllocationBusinessLayer sbl = new SpaceAllocationBusinessLayer();
SpaceAllocation sa = sbl.SpaceAllocations.Where(i => i.ID == id).Single();
int MaxOrdinalSequence = sbl.SpaceAllocations.Where(t => t.SeasonID == sa.SeasonID && t.SpaceID == sa.SpaceID && t.CatID == sa.CatID && t.SpaceGradeID == sa.SpaceGradeID && t.FixtureOrdinal == sa.FixtureOrdinal).Max(s => s.OrdinalSequence);
sa.OrdinalSequence = MaxOrdinalSequence + 1;
MeTypeBusinessLayer m = new MeTypeBusinessLayer();
List <MeType> ListOfMeTypes = m.MeTypes.ToList();
ViewData["ddMeType"] = ListOfMeTypes.Select(k => new SelectListItem {
Value = k.MeTypeID.ToString(), Text = k.MeTypeDesc, Selected = k.MeTypeID == sa.MeTypeID
});
PreArticleSeasonalBusinessLayer pbl = new PreArticleSeasonalBusinessLayer();
List <PreArticleSeasonal> ListOfPreArticleSeasonals = pbl.PreArticleSeasonals.Where(j => j.SeasonID == sa.SeasonID || j.SFID == sa.SFID).ToList();
ViewData["ddPAS"] = ListOfPreArticleSeasonals.Select(k => new SelectListItem {
Value = k.SFID.ToString(), Text = k.SunflowerDesc + " (" + k.SFID + ")", Selected = k.SFID == sa.SFID
});
return(View(sa));
}
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());
}
}
// GET: PreArticleSeasonal/Delete/5
public ActionResult Delete(string id)
{
PreArticleSeasonalBusinessLayer pbl = new PreArticleSeasonalBusinessLayer();
PreArticleSeasonal SomePreArticleSeasonal = pbl.PreArticleSeasonals.Where(i => i.ID == id).Single();
ViewBag.SeasonID = SomePreArticleSeasonal.SeasonID;
return(View(SomePreArticleSeasonal));
}
// GET: PreArticleSeasonal/Edit/5
public ActionResult Edit(string id)
{
#region StaticData
SeasonBusinessLayer sbl = new SeasonBusinessLayer();
List <Season> ListOfSeasons = sbl.Seasons.Where(r => r.SeasonActive == 1).OrderBy(o => o.FirstLaunchDate).ToList();
VendorBusinessLayer vbl = new VendorBusinessLayer();
List <Vendor> ListOfVendors = vbl.Vendors.OrderBy(o => o.VendorID).ToList();
GradeBusinessLayer gbl = new GradeBusinessLayer();
List <Grade> ListOfGrades = gbl.Grades.Where(z => z.PreArticleGrade == 1).OrderBy(o => o.GradeOrder).ToList();
MerchCatBusinessLayer mbl = new MerchCatBusinessLayer();
List <MerchCat> ListOfMerchCats = mbl.MerchCats.OrderBy(o => o.MerchCatID).ToList();
SpaceUseBusinessLayer spbl = new SpaceUseBusinessLayer();
List <SpaceUse> ListOfSpaceUses = spbl.SpaceUses.ToList();
StatusBusinessLayer tbl = new StatusBusinessLayer();
List <Status> ListOfStatuses = tbl.Statuses.ToList();
#endregion
PreArticleSeasonalBusinessLayer pbl = new PreArticleSeasonalBusinessLayer();
PreArticleSeasonal SomePreArticleSeasonal = pbl.PreArticleSeasonals.Where(i => i.ID == id).Single();
ViewData["ddSeason"] = ListOfSeasons.Select(m => new SelectListItem {
Value = m.SeasonID.ToString(), Text = m.SeasonDesc + " (" + m.SeasonID.ToString() + ")", Selected = m.SeasonID == SomePreArticleSeasonal.SeasonID
});
ViewData["ddGradeP"] = ListOfGrades.Select(m => new SelectListItem {
Value = m.GradeID.ToString(), Text = m.GradeDescription, Selected = m.GradeID == SomePreArticleSeasonal.ProposedPreArticleGradeID
});
ViewData["ddGradeC"] = ListOfGrades.Select(m => new SelectListItem {
Value = m.GradeID.ToString(), Text = m.GradeDescription, Selected = m.GradeID == SomePreArticleSeasonal.ConfirmedPreArticleGradeID
});
ViewData["ddMerchCat"] = ListOfMerchCats.Select(m => new SelectListItem {
Value = m.MerchCatID.ToString(), Text = m.MerchCatDesc + " (" + m.MerchCatID.ToString() + ")", Selected = m.MerchCatID == SomePreArticleSeasonal.MerchCatID
});
ViewData["ddVendor"] = ListOfVendors.Select(m => new SelectListItem {
Value = m.VendorID, Text = m.VendorDesc + " (" + m.VendorID + ")", Selected = m.VendorID == SomePreArticleSeasonal.VendorID
});
ViewData["ddSpaceUse"] = ListOfSpaceUses.Select(m => new SelectListItem {
Value = m.SpaceUseID.ToString(), Text = m.SpaceUseDesc + " (" + m.SpaceUseID.ToString() + ")", Selected = m.SpaceUseID == SomePreArticleSeasonal.VendorID
});
ViewData["ddContinue"] = ListOfStatuses.Where(i => i.StatusType == "C").Select(m => new SelectListItem {
Value = m.StatusID.ToString(), Text = m.StatusDesc + " (" + m.StatusID.ToString() + ")", Selected = m.StatusID == SomePreArticleSeasonal.ConfirmedPreArticleGradeID
});
ViewData["ddReplacement"] = ListOfStatuses.Where(i => i.StatusType == "R").Select(m => new SelectListItem {
Value = m.StatusID.ToString(), Text = m.StatusDesc + " (" + m.StatusID.ToString() + ")", Selected = m.StatusID == SomePreArticleSeasonal.ReplacementStatusID
});
ViewBag.SeasonID = SomePreArticleSeasonal.SeasonID;
return(View(SomePreArticleSeasonal));
}
// GET: PreArticleSeasonal
public ActionResult Index(int SeasonID = 0)
{
PreArticleSeasonalBusinessLayer sbl = new PreArticleSeasonalBusinessLayer();
List <PreArticleSeasonal> ListOfPreArticleSeasonals = sbl.PreArticleSeasonals.OrderBy(i => i.SFID).ToList();
if (SeasonID != 0)
{
ListOfPreArticleSeasonals = ListOfPreArticleSeasonals.Where(j => j.SeasonID == SeasonID).ToList();
}
return(View(ListOfPreArticleSeasonals));
}
// GET: SpaceAllocation/Edit/5
public ActionResult Edit(string id)
{
SpaceAllocationBusinessLayer sbl = new SpaceAllocationBusinessLayer();
SpaceAllocation sa = sbl.SpaceAllocations.Where(i => i.ID == id).Single();
MeTypeBusinessLayer m = new MeTypeBusinessLayer();
List <MeType> ListOfMeTypes = m.MeTypes.ToList();
ViewData["ddMeType"] = ListOfMeTypes.Select(k => new SelectListItem {
Value = k.MeTypeID.ToString(), Text = k.MeTypeDesc, Selected = k.MeTypeID == sa.MeTypeID
});
PreArticleSeasonalBusinessLayer pbl = new PreArticleSeasonalBusinessLayer();
List <PreArticleSeasonal> ListOfPreArticleSeasonals = pbl.PreArticleSeasonals.Where(j => j.SeasonID == sa.SeasonID || j.SFID == sa.SFID).ToList();
ViewData["ddPAS"] = ListOfPreArticleSeasonals.Select(k => new SelectListItem {
Value = k.SFID.ToString(), Text = k.SunflowerDesc + " (" + k.SFID + ")", Selected = k.SFID == sa.SFID
});
return(View(sa));
}
