public ActionResult AddFund(FormCollection f) { Account acc = (Account)Session["acc"]; Sponsor sp = db.Sponsors.SingleOrDefault(r => r.AccountID == acc.AccountID); Fund fund = new Fund(); fund.SponsorID = sp.SponsorID; fund.CharityExamID = int.Parse(f["asd"]); //string s = f["FundSponsored"]; //s.Replace(",", string.Empty); fund.FundSponsored = float.Parse(f["FundSponsored"]); db.Funds.Add(fund); db.SaveChanges(); return RedirectToAction("ManageFund"); }
public int InsertFund(Fund fund) { db.Funds.Add(fund); int r = db.SaveChanges(); return r; }
public ActionResult AddResource(FormCollection f) { Account acc = (Account)Session["acc"]; Sponsor sp = db.Sponsors.SingleOrDefault(r => r.AccountID == acc.AccountID); int s = int.Parse(f["resource"]); int lodgeId = int.Parse(f["lodgeId"]); switch (s) { case 1: Fund fund = new Fund(); fund.SponsorID = sp.SponsorID; fund.CharityExamID = int.Parse(f["asd"]); fund.FundSponsored = float.Parse(f["FundSponsored"]); db.Funds.Add(fund); break; case 2: int carId = int.Parse(f["carId"]); Car car = db.Cars.SingleOrDefault(r => r.CarID == carId); car.SponsorID = sp.SponsorID; car.CharityExamID = int.Parse(f["asd"]); car.CharityID = int.Parse(f["charityid"]); car.NumberPlate = f["NumberPlate"]; car.TotalSlots = int.Parse(f["TotalSlots"]); car.AvailableSlots = car.TotalSlots; car.DriverName = f["DriverName"]; car.DriverPhone = f["DriverPhone"]; break; case 3: Lodge lodge = db.Lodges.SingleOrDefault(r => r.LodgeID == lodgeId); lodge.SponsorID = sp.SponsorID; lodge.Address = f["Address"]; lodge.CharityExamID = int.Parse(f["asd"]); lodge.CharityID = int.Parse(f["charityid"]); lodge.TotalSlots = int.Parse(f["TotalSlotsL"]); lodge.AvailableSlots = lodge.TotalSlots; List<Room> listRoom = new List<Room>(); listRoom = lodge.Rooms.ToList(); foreach (var room in listRoom) { room.CharityExamID = int.Parse(f["asd"]); db.SaveChanges(); } break; } db.SaveChanges(); if (s == 1) { return RedirectToAction("ManageFund"); } else { if (s == 2) { return RedirectToAction("ManageCar"); } else { return RedirectToAction("ManageLodge"); } } }