public ActionResult Create(YearlyMembership yearlymembership) { if (ModelState.IsValid) { db.Memmberships.Add(yearlymembership); db.SaveChanges(); return(RedirectToAction("Index")); } List <object> listagodina = new List <object>(); foreach (var p in db.Years) { listagodina.Add( new { Id = p.ID, Name = p.BeginDate.Year } ); } ViewBag.UserId = new SelectList(db.Users, "ID", "Name", yearlymembership.UserId); ViewBag.YearId = new SelectList(listagodina, "ID", "Name", yearlymembership.YearId); return(View(yearlymembership)); }
public ActionResult Create([Bind(Include = "ID,Name,Surname,DateJoined")] User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); int mjesecnaClanarina = 300 / 12; Dug dug = new Dug(); var years = db.Years; foreach (var year in years) { if (user.DateJoined.Year > year.BeginDate.Year) { dug.Amount = 0; dug.UserID = user.ID; dug.YearID = year.ID; dug.user = user; dug.year = year; db.Dugovi.Add(dug); db.SaveChanges(); } else { if (user.DateJoined.Year == year.BeginDate.Year) { dug.Amount = (12 - user.DateJoined.Month) * mjesecnaClanarina; dug.UserID = user.ID; dug.YearID = year.ID; dug.user = user; dug.year = year; db.Dugovi.Add(dug); db.SaveChanges(); } else { dug.Amount = 300; dug.UserID = user.ID; dug.YearID = year.ID; dug.user = user; dug.year = year; db.Dugovi.Add(dug); db.SaveChanges(); } } } db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public bool SaveAll() { return(db.SaveChanges() > 0); }