public ActionResult AddActivity(int id) { List <string> errs = new List <string>(); ActivityByMemberModels memberActivities = new ActivityByMemberModels(); using (LRCEntities context = new LRCEntities()) { var tb_MemberMaster = context.tb_MemberMaster.ToList(); ViewBag.ActivityStatus = context.tb_ActivityStatus.ToList(); ViewBag.ActivityStatusAfter = new List <SelectListItem> { new SelectListItem { Value = "0", Text = "Participated", Selected = false }, new SelectListItem { Value = "1", Text = "Not Participated", Selected = false } }; SelectList Activities = new SelectList(db.tb_Activity.OrderBy(s => s.ActivityName), "ActivityID", "ActivityName"); SelectListItem selListItem = new SelectListItem() { Value = "0", Text = " Select Activity " }; ViewBag.ActivityID = CommonFunctions.AddFirstItem(Activities, selListItem); } memberActivities.MemberID = id; ViewBag.MemberActivities = db.tb_MemberActivity.Where(a => a.MemberID == id).OrderBy(s => s.ActivityID).ToList(); tb_MemberMaster fm = db.tb_MemberMaster.Find(id); ViewBag.MemberName = fm.FirstName + " " + fm.LastName; return(View(memberActivities)); }
public ActionResult AddActivityByMember() { //https://www.youtube.com/watch?v=z3ViZ6XA884 Asp.Net MVC - Searchable and Multi-select Drop DownList Using Chosen Plugin //Chosen Plugin https://harvesthq.github.io/chosen/ ActivityByMemberModels memberActivities = new ActivityByMemberModels(); using (LRCEntities context = new LRCEntities()) { var tb_MemberMaster = context.tb_MemberMaster.ToList(); List <SelectListItem> members = new List <SelectListItem>(); foreach (var member in tb_MemberMaster) { members.Add(new SelectListItem() { Text = member.FirstName + " " + member.LastName, Value = member.MemberID.ToString() }); memberActivities.MemberCollection = members.OrderBy(s => s.Text).ToList(); } ViewBag.ActivityStatus = context.tb_ActivityStatus.ToList(); ViewBag.ActivityStatusAfter = new List <SelectListItem> { new SelectListItem { Value = "0", Text = "Participated", Selected = false }, new SelectListItem { Value = "1", Text = "Not Participated", Selected = false } }; SelectList Activities = new SelectList(db.tb_Activity.OrderBy(s => s.ActivityName), "ActivityID", "ActivityName"); SelectListItem selListItem = new SelectListItem() { Value = "0", Text = " Select Activity " }; ViewBag.ActivityID = CommonFunctions.AddFirstItem(Activities, selListItem); } return(View(memberActivities)); }
public ActionResult AddPersonAssessmentActivity(int?id, int CollegeID) { //ViewBag.CollegeID = CollegeID; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var tb_Assessment = db.tb_Assessment.Include(t => t.tb_MemberMaster); tb_Assessment = tb_Assessment.Where(f => f.tb_MemberMaster.MemberID == id); tb_Assessment Assessment = new tb_Assessment(); var uName = HttpContext.GetOwinContext().Authentication.User.Identity.GetUserName(); if (tb_Assessment.Count() == 0) //1st Assessment { Assessment.AddedBy = uName; Assessment.AddedDateTime = DateTime.Now; Assessment.AssessedBy = uName; Assessment.AssessmentDate = DateTime.Now; Assessment.AssessmentDesc = String.Empty; Assessment.AssessmentNameID = 7; // Add Fee Payer Assess Assessment.MemberID = id ?? default(int); Assessment.ModifiedBy = uName; Assessment.ModifiedDateTime = DateTime.Now; Assessment.ValueID = 1; } else { Assessment = tb_Assessment.FirstOrDefault(); } SelectList FeePayerAssess = new SelectList(db.tb_AssessmentName.OrderBy(s => s.AssessmentName), "AssessmentNameID", "AssessmentName", Assessment.AssessmentNameID /* selected value */); ViewBag.AssessmentNameID = FeePayerAssess; SelectList AssessmentValue = new SelectList(db.tb_AssessmentValue, "ValueID", "ValueName", Assessment.ValueID /* selected value */); ViewBag.ValueID = AssessmentValue; SelectList AspNetUsers = new SelectList(db.AspNetUsers.OrderBy(s => s.LastFirstName), "Id", "LastFirstName"); ViewBag.AssessedBy = AspNetUsers; List <tb_ActivityStatus> ActivityStatuses = new List <tb_ActivityStatus>(); ViewBag.ActivityStatus = db.tb_ActivityStatus.ToList(); ViewBag.ActivityStatusAfter = new List <SelectListItem> { new SelectListItem { Value = "0", Text = "Participated", Selected = false }, new SelectListItem { Value = "1", Text = "Not Participated", Selected = false } }; SelectList Activities = new SelectList(db.tb_Activity.OrderBy(s => s.ActivityName), "ActivityID", "ActivityName"); SelectListItem selListItem = new SelectListItem() { Value = "0", Text = " Select Activity " }; ViewBag.ActivityID = CommonFunctions.AddFirstItem(Activities, selListItem); List <tb_MemberActivity> MemberActivities = new List <tb_MemberActivity>(); MemberActivities = db.tb_MemberActivity.Where(a => a.MemberID == id).OrderBy(s => s.ActivityID).ToList(); tb_MemberMaster fm = db.tb_MemberMaster.Find(id); ViewBag.MemberName = fm.FirstName + " " + fm.LastName; var model = new AssessActivityModels() { _Assessment = Assessment, _Activity = db.tb_Activity.FirstOrDefault(), _ActivityStatus = ActivityStatuses, _MemberActivity = MemberActivities, _MemberAssessments = tb_Assessment.ToList(), _CollegeID = CollegeID }; return(View(model)); }
public ActionResult AddPersonAssessmentActivity(int id, string submit, int AssessmentNameID, string AssessedBy, int ActivityID, int ActivityStatusID, int ValueID, AssessActivityModels model, FormCollection formCollection) { //if (id == null) //{ // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); //} Error error = new Error(); error.errCode = ErrorDetail.Success; List <string> errs = new List <string>(); string userId = HttpContext.GetOwinContext().Authentication.User.Identity.GetUserId(); //string uLastFirstName = db.AspNetUsers.Where(s => s.Email == uName).FirstOrDefault().LastFirstName; //ViewBag.CollegeID = CollegeID; #region Prepare Model (ASSESSMENT Part) SelectList FeePayerAssess = new SelectList(db.tb_AssessmentName.OrderBy(s => s.AssessmentName), "AssessmentNameID", "AssessmentName", AssessmentNameID /* selected value */); ViewBag.AssessmentNameID = FeePayerAssess; SelectList AssessmentValue = new SelectList(db.tb_AssessmentValue, "ValueID", "ValueName", ValueID /* selected value */); ViewBag.ValueID = AssessmentValue; SelectList AspNetUsers = new SelectList(db.AspNetUsers.OrderBy(s => s.LastFirstName), "Id", "LastFirstName"); ViewBag.AssessedBy = AspNetUsers; model._Assessment.ValueID = ValueID; model._Assessment.AssessmentNameID = AssessmentNameID; model._Assessment.AssessedBy = AssessedBy; model._Assessment.AddedDateTime = DateTime.Now; model._MemberAssessments = db.tb_Assessment.Where(f => f.tb_MemberMaster.MemberID == id).ToList(); #endregion #region Prepare Model (ACTIVITY Part) model._ActivityStatus = db.tb_ActivityStatus.ToList(); ViewBag.ActivityStatusAfter = new List <SelectListItem> { new SelectListItem { Value = "0", Text = "Participated", Selected = false }, new SelectListItem { Value = "1", Text = "Not Participated", Selected = false } }; SelectList Activities = new SelectList(db.tb_Activity.OrderBy(s => s.ActivityName), "ActivityID", "ActivityName"); SelectListItem selListItem = new SelectListItem() { Value = "0", Text = " Select Activity " }; ViewBag.ActivityID = CommonFunctions.AddFirstItem(Activities, selListItem); model._MemberActivity = db.tb_MemberActivity.Where(s => s.MemberID == id).ToList(); tb_MemberMaster fm = db.tb_MemberMaster.Find(id); ViewBag.MemberName = fm.FirstName + " " + fm.LastName; #endregion if (submit == "Submit") //Adding Assessment { if (ModelState.IsValid) { try { model._Assessment.AddedBy = userId; db.tb_Assessment.Add(model._Assessment); db.SaveChanges(); } catch (DbEntityValidationException ex) { error.errCode = ErrorDetail.DataImportError; error.errMsg = ErrorDetail.GetMsg(error.errCode); foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors) { error.errMsg += ". Object: " + validationError.Entry.Entity.ToString(); foreach (DbValidationError err in validationError.ValidationErrors) { error.errMsg += ". " + err.ErrorMessage; } } errs.Add("Error #" + error.errCode.ToString() + "!" + error.errMsg); ViewData["AssessmentErrorList"] = errs; return(View(model)); } model._MemberAssessments = db.tb_Assessment.Where(f => f.tb_MemberMaster.MemberID == id).ToList(); return(View(model)); } else { error.errCode = ErrorDetail.DataImportError; error.errMsg = ErrorDetail.GetMsg(error.errCode); foreach (var state in ModelState) { foreach (var err in state.Value.Errors) { error.errMsg += ". " + err.ErrorMessage; } } errs.Add("Error #" + error.errCode.ToString() + "!" + error.errMsg); ViewData["AssessmentErrorList"] = errs; return(View(model)); } } else if (submit == "Assign") //Adding Person to Activity { if (ModelState.IsValid) { bool?isParticipated = null; if (formCollection["afterTheFact"] == "0") { isParticipated = true; } else if (formCollection["afterTheFact"] == "1") { isParticipated = false; } ActivityByMemberModels activityCRUD = new ActivityByMemberModels(); errs = activityCRUD.AddEditActivity(id, ActivityID, ActivityStatusID, isParticipated, model._Activity.ActivityDate, model._Activity.ActivityNote, userId); if (errs == null || errs.Count == 0) { return(RedirectToAction("MembersBySchool", "Home", new { @CollegeID = model._CollegeID })); } else { ViewData["ErrorList"] = errs; ActivityByMemberModels memberActivities = new ActivityByMemberModels(); memberActivities.MemberCollection = memberActivities.GetFullListOfMembers(); return(View(memberActivities)); } } else { error.errCode = ErrorDetail.DataImportError; error.errMsg = ErrorDetail.GetMsg(error.errCode); foreach (var state in ModelState) { foreach (var err in state.Value.Errors) { error.errMsg += ". " + err.ErrorMessage; } } errs.Add("Error #" + error.errCode.ToString() + "!" + error.errMsg); ViewData["ErrorList"] = errs; ActivityByMemberModels memberActivities = new ActivityByMemberModels(); memberActivities.MemberCollection = memberActivities.GetFullListOfMembers(); return(View(memberActivities)); } //if (ModelState.IsValid) //{ // try // { // tb_Activity activity = db.tb_Activity.Find(ActivityID); // activity.ActivityDate = model._Activity.ActivityDate; // activity.ActivityNote = model._Activity.ActivityNote; // activity.ModifiedDateTime = DateTime.UtcNow; // activity.ModifiedBy = userId; // tb_MemberActivity oldMemberActivity = db.tb_MemberActivity.Where(p => p.ActivityID == ActivityID && p.MemberID == id).FirstOrDefault(); //id = AssessActivity._Assessment.MemberID (changed to id) // if (oldMemberActivity == null) //Action isnt assigned for this member // { // tb_MemberActivity memberActivity = new tb_MemberActivity(); // memberActivity.MemberID = id ?? default(int); //id = AssessActivity._Assessment.MemberID (changed to id); // memberActivity.ActivityID = ActivityID; // memberActivity.ActivityStatusID = ActivityStatusID; // if (ActivityStatusID == 1) // 1 - Committed // { // memberActivity.Membership = true; // memberActivity.MembershipCommitment++; // } // else // memberActivity.Membership = false; // db.tb_MemberActivity.Add(memberActivity); // } // else // { // if (ActivityStatusID == 1) // 1 - Committed // { // oldMemberActivity.Membership = true; // oldMemberActivity.MembershipCommitment++; // } // else // { // oldMemberActivity.Membership = false; // if (oldMemberActivity.ActivityStatusID == 1 && oldMemberActivity.MembershipCommitment > 0) //commited before so reduce qty of commitments // oldMemberActivity.MembershipCommitment--; // } // oldMemberActivity.ActivityStatusID = ActivityStatusID; // db.Entry(oldMemberActivity).State = EntityState.Modified; // } // db.SaveChanges(); // model._MemberActivity = db.tb_MemberActivity.Where(s => s.MemberID == id).ToList(); // } // catch (DbEntityValidationException ex) // { // error.errCode = ErrorDetail.DataImportError; // error.errMsg = ErrorDetail.GetMsg(error.errCode); // foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors) // { // error.errMsg += ". Object: " + validationError.Entry.Entity.ToString(); // foreach (DbValidationError err in validationError.ValidationErrors) // { // error.errMsg += ". " + err.ErrorMessage; // } // } // errs.Add("Error #" + error.errCode.ToString() + "!" + error.errMsg); // ViewData["ActivityErrorList"] = errs; // return View(model); // } //} } else { error.errCode = ErrorDetail.DataImportError; error.errMsg = ErrorDetail.GetMsg(error.errCode); foreach (var state in ModelState) { foreach (var err in state.Value.Errors) { error.errMsg += ". " + err.ErrorMessage; } } errs.Add("Error #" + error.errCode.ToString() + "!" + error.errMsg); ViewData["ActivityErrorList"] = errs; return(View(model)); } return(View(model)); //return RedirectToAction("AddPersonAssessmentActivity"); }
public ActionResult AddActivityByMember([Bind(Include = "ActivityID")] ActivityByMemberModels model, FormCollection formCollection) { Error error = new Error(); error.errCode = ErrorDetail.Success; List <string> errs = new List <string>(); bool result = Int32.TryParse(formCollection["MemberID"], out int mId); //MemberActivityID model.MemberID = mId; result = Int32.TryParse(formCollection["ActivityStatusID"], out int asID); //ActivityStatusID (Before The Fact) model.ActivityStatusID = asID; #region Prepare Model ViewBag.ActivityStatus = db.tb_ActivityStatus.ToList(); ViewBag.ActivityStatusAfter = new List <SelectListItem> { new SelectListItem { Value = "0", Text = "Participated", Selected = false }, new SelectListItem { Value = "1", Text = "Not Participated", Selected = false } }; SelectList Activities = new SelectList(db.tb_Activity.OrderBy(s => s.ActivityName), "ActivityID", "ActivityName"); SelectListItem selListItem = new SelectListItem() { Value = "0", Text = " Select Activity " }; ViewBag.ActivityID = CommonFunctions.AddFirstItem(Activities, selListItem); #endregion if (ModelState.IsValid) { bool?isParticipated = null; if (formCollection["afterTheFact"] == "0") { isParticipated = true; } else if (formCollection["afterTheFact"] == "1") { isParticipated = false; } string userId = HttpContext.GetOwinContext().Authentication.User.Identity.GetUserId(); ActivityByMemberModels activityCRUD = new ActivityByMemberModels(); errs = activityCRUD.AddEditActivity(model.MemberID, model.ActivityID, model.ActivityStatusID, isParticipated, DateTime.Parse(formCollection["tb_Activity.ActivityDate"]), formCollection["tb_Activity.ActivityNote"], userId); if (errs == null || errs.Count == 0) { return(RedirectToAction("Index", "Activities", new { @id = model.MemberID })); } else { ViewData["ErrorList"] = errs; ActivityByMemberModels memberActivities = new ActivityByMemberModels(); memberActivities.MemberCollection = memberActivities.GetFullListOfMembers(); return(View(memberActivities)); } } else { error.errCode = ErrorDetail.DataImportError; error.errMsg = ErrorDetail.GetMsg(error.errCode); foreach (var state in ModelState) { foreach (var err in state.Value.Errors) { error.errMsg += ". " + err.ErrorMessage; } } errs.Add("Error #" + error.errCode.ToString() + "!" + error.errMsg); ViewData["ErrorList"] = errs; ActivityByMemberModels memberActivities = new ActivityByMemberModels(); memberActivities.MemberCollection = memberActivities.GetFullListOfMembers(); return(View(memberActivities)); } }