public JsonResult GetDuties(string start, string end) { DateTime startDate = Convert.ToDateTime(start); DateTime endDate = Convert.ToDateTime(end); using (var context = RosterContext.Create()) { var duties = context.Duties.Where(d => d.FromDate >= startDate && d.ToDate <= endDate); List <DutyModel> model = new List <DutyModel>(); foreach (var d in duties) { model.Add(new DutyModel { Id = d.Id, ClubId = d.ClubId, Description = d.Description, start = d.FromDate.ToString("yyyy'-'MM'-'dd"), end = d.ToDate.ToString("yyyy'-'MM'-'dd"), title = d.Name, Instructions = d.Instructions, UserId = d.UserId, starttime = d.Starttime, endtime = d.Endtime, backgroundColor = string.IsNullOrEmpty(d.UserId) ? "Red" : "Green" }); } return(Json(model, JsonRequestBehavior.AllowGet)); } }
public bool Volunteer(int dutyId) { try { using (var context = RosterContext.Create()) { var usr = context.Users.First(u => u.Name == User.Identity.Name); var duty = context.Duties.First(d => d.Id == dutyId); duty.UserId = usr.Id; context.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }