public ActionResult Delete(int id = 0) { ActivityTransaction activitytransaction = db.ActivityTransactions.Find(id); if (activitytransaction == null) { return(HttpNotFound()); } return(View(activitytransaction)); }
public ActionResult Edit(ActivityTransaction activitytransaction) { if (ModelState.IsValid) { db.Entry(activitytransaction).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "UserName", activitytransaction.UserId); ViewBag.ActivityId = new SelectList(db.Activities, "ActivityId", "ActivityName", activitytransaction.ActivityId); return(View(activitytransaction)); }
public ActionResult Edit(int id = 0) { ActivityTransaction activitytransaction = db.ActivityTransactions.Find(id); if (activitytransaction == null) { return(HttpNotFound()); } ViewBag.UserId = new SelectList(db.UserProfiles, "UserId", "UserName", activitytransaction.UserId); ViewBag.ActivityId = new SelectList(db.Activities, "ActivityId", "ActivityName", activitytransaction.ActivityId); return(View(activitytransaction)); }
public ActionResult Create(int[] userId, int[] activityId, DateTime activityDate) { if (ModelState.IsValid) { foreach (int i in userId) { UserProfile updUserProfile = db.UserProfiles.Find(i); foreach (int x in activityId) { Activity act = db.Activities.Find(x); int points = act.PointValue; updUserProfile.PointTotal += points; updUserProfile.CumulativePointTotal += points; var activityTransaction = new ActivityTransaction { UserId = i, ActivityDate = activityDate, ActivityId = x }; db.ActivityTransactions.Add(activityTransaction); db.SaveChanges(); } } //Fetch User Profile //UserProfile updUserProfile = db.UserProfiles.Find(activitytransaction.UserId); //Fetch Activity // Activity act = db.Activities.Find(activitytransaction.ActivityId); //Fetch point value for completed activity //int points = act.PointValue; //Add Points //updUserProfile.PointTotal += points; //updUserProfile.CumulativePointTotal += points; //db.ActivityTransactions.Add(activitytransaction); // db.SaveChanges(); //AddStudentPoints(updUserProfile, points); return(RedirectToAction("Index")); } var usernames = Roles.GetUsersInRole("Student"); var studentUsers = db.UserProfiles .Where(x => usernames.Contains(x.UserName)).ToList(); ViewBag.UserId = new MultiSelectList(studentUsers, "UserId", "UserName"); ViewBag.ActivityId = new MultiSelectList(db.Activities, "ActivityId", "ActivityName"); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { ActivityTransaction activitytransaction = db.ActivityTransactions.Find(id); //Fetch User Profile UserProfile updUserProfile = db.UserProfiles.Find(activitytransaction.UserId); //Fetch Activity Activity act = db.Activities.Find(activitytransaction.ActivityId); //Fetch Points for that activity int points = act.PointValue; updUserProfile.PointTotal -= points; db.ActivityTransactions.Remove(activitytransaction); db.SaveChanges(); return(RedirectToAction("Index")); }
public void Calculate(ActivityTransaction activityTransaction, TenantList tenants) { var tenantId=activityTransaction.TenantId; Count(tenantId, tenants); }