public ActionResult DeleteConfirmed(int id)
{
MemberWinnings memberWinnings = db.MemberWinnings.Find(id);
db.MemberWinnings.Remove(memberWinnings);
db.SaveChanges();
return(RedirectToAction("Manage"));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MemberWinnings memberWinnings = db.MemberWinnings.Find(id);
if (memberWinnings == null)
{
return(HttpNotFound());
}
return(View(memberWinnings));
}
public ActionResult Create([Bind(Include = "MemberWinningId,DisplayName,WinningTypeId,Amount,EventId,FlightId")] MemberWinnings memberWinnings)
{
bool successful = false;
try
{
List <Members> members = db.Members.ToList();
memberWinnings.MemberId = members
.Where(m => m.DisplayName == memberWinnings.DisplayName)
.Select(m => m.MemberId)
.First();
if (memberWinnings.WinningTypeId == 2) // Equals 'Side Games'
{
memberWinnings.FlightId = 7; // Side Games
}
if (ModelState.IsValid)
{
db.MemberWinnings.Add(memberWinnings);
db.SaveChanges();
successful = true;
}
}
catch (Exception ex)
{
Debug.WriteLine("----Error in Members.Create()---------------------------------------------------");
Debug.WriteLine(ex.Message);
ViewBag.Message = "Did you select a Member?";
Debug.WriteLine("--------------------------------------------------------------------------------");
}
ViewBag.EventId = new SelectList(db.Event, "EventId", "Title", memberWinnings.EventId);
ViewBag.MemberId = new SelectList(db.Members, "MemberId", "Lastname", memberWinnings.MemberId);
ViewBag.WinningTypeId = new SelectList(db.WinningTypes, "WinningTypeId", "WinningType", memberWinnings.WinningTypeId);
ViewBag.Year = db.Event.Find(memberWinnings.EventId).EventEnd.Year;
ViewBag.Success = successful;
if (successful)
{
ViewBag.Message = "Event Winning Created";
ViewBag.Event = memberWinnings.Event.Title;
ViewBag.Member = db.Members.Find(memberWinnings.MemberId).DisplayName;
ViewBag.Type = db.WinningTypes.Find(memberWinnings.WinningTypeId).WinningType;
ViewBag.Amount = memberWinnings.Amount;
memberWinnings.MemberId = 0;
}
return(View(memberWinnings));
}
public ActionResult GetWinnings(int year)
{
List <MemberWinnings> list = new List <MemberWinnings>();
var winnings = db.MemberWinnings
.Where(mw => mw.Event.EventEnd.Year == year)
.OrderBy(mw => mw.Members.Lastname)
.ThenBy(mw => mw.Members.Firstname)
.ThenBy(mw => mw.Event.EventEnd)
.ToList();
foreach (MemberWinnings winning in winnings)
{
MemberWinnings mw = new MemberWinnings()
{
Amount = winning.Amount,
Event = new Event()
{
EventId = winning.EventId,
Title = winning.Event.Title,
EventEnd = winning.Event.EventEnd
},
MemberId = winning.MemberId,
Members = new Members()
{
MemberId = winning.MemberId,
Firstname = winning.Members.Firstname,
Lastname = winning.Members.Lastname,
},
MemberWinningId = winning.MemberWinningId,
WinningTypeId = winning.WinningTypeId,
WinningTypes = new WinningTypes()
{
WinningType = winning.WinningTypes.WinningType,
WinningTypeId = winning.WinningTypes.WinningTypeId,
}
};
list.Add(mw);
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
