public ActionResult Save(int? FishID, string FishName, int price, int shadow, int rarity, string saying) { NewLeafContext nlc = new NewLeafContext(); Fish fish = new Fish(); if (FishID.HasValue) { fish.FishID = (int)FishID; fish = nlc.Fishes.Where(x => x.FishID == fish.FishID).FirstOrDefault(); } else { fish.FishID = nlc.Fishes.Max(x => x.FishID) + 1; nlc.Fishes.Add(fish); } fish.FishName = FishName; fish.Price = price; fish.ShadowSizeID = shadow; fish.FishRarityID = rarity; fish.CheesySaying = saying; nlc.SaveChanges(); return View(); }
// // GET: /Fish/ public FishVM Get(string fishName) { NewLeafContext nlc = new NewLeafContext(); Fish seaBass = nlc.Fishes.Include("FishTimes").Include("ShadowSize").Include("Rarity").Include("FishTimes.FishLocation").FirstOrDefault(f => f.FishName == fishName); return seaBass; }
// // GET: /EditFish/ public ActionResult Index(int? fish) { NewLeafContext nlc = new NewLeafContext(); if (fish.HasValue) { Fish editFish = nlc.Fishes.Include("ShadowSize").Include("Rarity").Where(x => x.FishID == (int)fish).FirstOrDefault(); SelectList shadow; SelectList rarity; if (editFish != null) { ViewData["FishID"] = editFish.FishID; shadow = new SelectList(nlc.ShadowSize, "ShadowSizeID", "ShadowSizeText", editFish.ShadowSizeID); rarity = new SelectList(nlc.FishRarity, "FishRarityID", "Rarity", editFish.FishRarityID); ViewData["FishName"] = editFish.FishName; ViewData["Price"] = editFish.Price; ViewData["Saying"] = editFish.CheesySaying; } else { shadow = new SelectList(nlc.ShadowSize, "ShadowSizeID", "ShadowSizeText"); rarity = new SelectList(nlc.FishRarity, "FishRarityID", "Rarity"); } ViewData["Shadow"] = shadow; ViewData["Rarity"] = rarity; } else { ViewData["Shadow"] = new SelectList(nlc.ShadowSize, "ShadowSizeID", "ShadowSizeText"); ViewData["Rarity"] = new SelectList(nlc.FishRarity, "FishRarityID", "Rarity"); } return View(); }
public List<FishVM> Get() { NewLeafContext nlc = new NewLeafContext(); nlc.Configuration.ProxyCreationEnabled = false; var fishes = nlc.Fishes.Include("FishTimes").Include("ShadowSize").Include("FishTimes.FishLocation").Include("Rarity").ToList(); List<FishVM> fishList = new List<FishVM>(); foreach (Fish fish in fishes) { fishList.Add(fish); } return fishList; }
public List<FishVM> GetCurrentFish(long ticks, string includeTropical = "N") { NewLeafContext nlc = new NewLeafContext(); nlc.Configuration.ProxyCreationEnabled = false; DateTime currentDate = new DateTime(ticks); List<FishVM> fishes = new List<FishVM>(); DateTime datePart = new DateTime(2000, currentDate.Month, currentDate.Day); DateTime timePart = new DateTime(2000, 1, 1, currentDate.Hour, currentDate.Minute, currentDate.Second); List<FishTime> fishTimes; if (includeTropical == "N") { fishTimes = nlc.FishTimes.Include("Fish").Include("FishLocation").Include("Fish.Rarity").Include("Fish.ShadowSize") .Where(ft => ft.FishLocation.LocationName != "Tropical Island" && ( ( ft.DateBegin < ft.DateEnd && ( ft.DateBegin <= datePart && ft.DateEnd >= datePart ) && ( ( ft.TimeBegin < ft.TimeEnd && ( ft.TimeBegin <= timePart && ft.TimeEnd > timePart ) ) || ( ft.TimeBegin > ft.TimeEnd && ( ft.TimeBegin <= timePart || ft.TimeEnd > timePart ) ) ) ) || ( ft.DateBegin > ft.DateEnd && ( ft.DateBegin <= datePart || ft.DateEnd >= datePart ) && ( ( ft.TimeBegin < ft.TimeEnd && ( ft.TimeBegin <= timePart && ft.TimeEnd > timePart ) ) || ( ft.TimeBegin > ft.TimeEnd && ( ft.TimeBegin <= timePart || ft.TimeEnd > timePart ) ) ) ) )).OrderBy(ft => ft.Fish.FishName).ToList(); } else { fishTimes = nlc.FishTimes.Include("Fish").Include("FishLocation") .Where(ft => ft.FishLocation.LocationName == "Tropical Island" && ((ft.DateBegin < ft.DateEnd && ft.DateBegin <= datePart && ft.DateEnd >= datePart && ((ft.TimeBegin < ft.TimeEnd && (ft.TimeBegin <= timePart && ft.TimeEnd > timePart)) || (ft.TimeBegin > ft.TimeEnd && (ft.TimeBegin <= timePart || ft.TimeEnd > timePart)))) || (ft.DateBegin > ft.DateEnd && ft.DateBegin <= datePart || ft.DateEnd >= datePart && ((ft.TimeBegin < ft.TimeEnd && (ft.TimeBegin <= timePart && ft.TimeEnd > timePart)) || (ft.TimeBegin > ft.TimeEnd && (ft.TimeBegin <= timePart || ft.TimeEnd > timePart)))))).OrderBy(ft => ft.Fish.FishName).ToList(); } foreach (FishTime ft in fishTimes) { if (!fishes.Any(f => f.FishName == ft.Fish.FishName)) { var fish = ft.Fish; //fish.FishTimes.Add(ft); fishes.Add(fish); } } return fishes; }