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)); }
} //for Chosen Plugin DDL public List <string> AddEditActivity(int memberId, int activityID, int activityStatusID, bool?isParticipated, DateTime activityDate, string activityNote, string userId) { Error error = new Error(); error.errCode = ErrorDetail.Success; List <string> errs = new List <string>(); List <string> warnings = new List <string>(); string warning = String.Empty; using (LRCEntities context = new LRCEntities()) { try { var existingActivity = context.tb_MemberActivity.Where(t => t.MemberID == memberId && t.ActivityID == activityID).FirstOrDefault(); if (existingActivity == null) // Add new activity for selected Member { tb_MemberActivity memberActivity = new tb_MemberActivity { ActivityID = activityID, MemberID = memberId, ActivityStatusID = activityStatusID, Participated = isParticipated }; context.tb_MemberActivity.Add(memberActivity); } else //Edit existing activity for selected Member { existingActivity.ActivityStatusID = activityStatusID; existingActivity.Participated = isParticipated; } tb_Activity activity = context.tb_Activity.Find(activityID); // Change if Activity was edited (activityDate or ActivityNote fields) if (activity.ActivityDate != activityDate || activity.ActivityNote.ToUpper() != activityNote.ToUpper()) { activity.ModifiedBy = userId; activity.ModifiedDateTime = DateTime.UtcNow; activity.ActivityDate = activityDate; activity.ActivityNote = activityNote; } context.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); return(errs); } } return(errs); }
public ActionResult CampusesMapping([Bind(Include = "ID,ScheduleMappingName")] tb_CampusMapping tb_CampusMapping, int?CampusId) { if (CampusId == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (LRCEntities context = new LRCEntities()) { tb_CampusMapping campusMapping = new tb_CampusMapping { CampusID = CampusId ?? 0, ScheduleMappingName = tb_CampusMapping.ScheduleMappingName }; context.tb_CampusMapping.Add(campusMapping); try { context.SaveChanges(); } catch (DbEntityValidationException ex) { } } ViewBag.Campuses = db.tb_CampusMapping.Include(c => c.tb_Campus).Where(m => m.ScheduleMappingName != null).ToList(); var campusNames = new SelectList(db.tb_Campus, "CampusID", "CampusName"); ViewBag.CampusId = campusNames.OrderBy(t => t.Text); return(View()); }
public ActionResult ScheduleMapping([Bind(Include = "ID,ColumnNameCBU")] tb_ScheduleImportMapping tb_ScheduleImportMapping, int?ID) { if (ID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (LRCEntities context = new LRCEntities()) { try { var rec = db.tb_ScheduleImportMapping.Find(ID); rec.ColumnNameCBU = tb_ScheduleImportMapping.ColumnNameCBU; context.tb_ScheduleImportMapping.Attach(rec); context.SaveChanges(); } catch (DbEntityValidationException ex) { } } ViewBag.Columns = db.tb_ScheduleImportMapping.ToList(); var modelFields = new SelectList(db.tb_ScheduleImportMapping, "ID", "ModelCorrespondingField"); ViewBag.ID = modelFields; return(View()); }
public JsonResult GetCampussesByCollegeId(int CollegeId) { List <tb_Activity> activities = new List <tb_Activity>(); string json = String.Empty; using (LRCEntities context = new LRCEntities()) { SelectList Campuses = new SelectList(context.tb_Campus.Where(s => s.CollegeID == CollegeId).OrderBy(s => s.CampusName), "CampusID", "CampusName"); json = JsonConvert.SerializeObject(Campuses, Formatting.Indented); } return(Json(json, JsonRequestBehavior.AllowGet)); }
public ActionResult RemoveAllScheduleErrorRecords() { using (LRCEntities context = new LRCEntities()) { try { context.Database.ExecuteSqlCommand("TRUNCATE TABLE [dbo].[tb_Schedule_Error]"); } catch (DbEntityValidationException ex) { } } return(RedirectToAction("MemberImportErrors")); }
public static SelectList GetDepartments(int CollegeID, int DepartmentID, bool isActual, SelectListItem firstItem) { List <tb_Department> departments = new List <tb_Department>(); IQueryable <tb_Department> Departments; using (LRCEntities context = new LRCEntities()) { if (CollegeID == 0) { Departments = context.tb_Department.Include(x => x.tb_MemberMaster); } else { Departments = context.tb_Department.Where(x => x.CollegeID == CollegeID).Include(x => x.tb_MemberMaster); } foreach (var dep in Departments) { if (dep.tb_MemberMaster.Any(c => c.DepartmentID == dep.DepartmentID)) { departments.Add(dep); } } } var deps = departments.Select(i => new SelectListItem() { Text = i.DepartmentName, Value = i.DepartmentID.ToString() }).ToList(); //List<SelectListItem> newList = origList; deps.Insert(0, firstItem); var selectedItem = deps.First(); if (DepartmentID > 0) { selectedItem = deps.Where(s => s.Value == DepartmentID.ToString()).First(); } var selectedItemValue = String.Empty; if (selectedItem != null) { selectedItemValue = selectedItem.Value; } return(new SelectList(deps, "Value", "Text", selectedItemValue)); }
//Check if current AreaName is present in tb_Area already and add it if not public static List <string> GetAreaID(string AreaName, out int areaID) { areaID = 0; Error error = new Error(); error.errCode = ErrorDetail.Success; error.errMsg = ErrorDetail.GetMsg(error.errCode); List <string> errs = new List <string>(); tb_Area tb_area = new tb_Area(); using (LRCEntities context = new LRCEntities()) { var areas = context.tb_Area.Where(t => t.AreaName.ToUpper() == AreaName.ToUpper()); if (areas.Count() == 0) { tb_area.AreaName = AreaName; tb_area.AreaDesc = String.Empty; //??? may be add it later with some Edit Area Form context.tb_Area.Add(tb_area); try { context.SaveChanges(); areaID = tb_area.AreaID; // new AreaID of added Area } 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); return(errs); } } else { //return AreaID of founded Area areaID = areas.FirstOrDefault().AreaID; } } return(errs); }
public ActionResult RemoveScheduleCampusMapping(int?Id) { if (Id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (LRCEntities context = new LRCEntities()) { var rec = context.tb_CampusMapping.Find(Id); context.tb_CampusMapping.Remove(rec); try { context.SaveChanges(); } catch (DbEntityValidationException ex) { } } return(RedirectToAction("CampusesMapping")); }
public ActionResult DeleteScheduleRecord(int?errId) { if (errId == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (LRCEntities context = new LRCEntities()) { var me = context.tb_Schedule_Error.Find(errId); context.tb_Schedule_Error.Remove(me); try { context.SaveChanges(); } catch (DbEntityValidationException ex) { } } return(RedirectToAction("ScheduleImportErrors")); }
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 List <SelectListItem> GetFullListOfMembers() { 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() //Selected = member.MemberID == mId ? true : false }); memberActivities.MemberCollection = members.OrderBy(s => s.Text).ToList(); } } return(memberActivities.MemberCollection); }
public ActionResult DeleteActivity(int?ActivityID, int?MemberId, int?CollegeID) { Error error = new Error(); error.errCode = ErrorDetail.Success; if (ActivityID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (LRCEntities context = new LRCEntities()) { try { tb_MemberActivity activity = context.tb_MemberActivity.Find(ActivityID); if (activity == null) { return(HttpNotFound()); } context.tb_MemberActivity.Remove(activity); context.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; } } } } return(RedirectToAction("AddPersonAssessmentActivity", new { @id = MemberId, CollegeID = CollegeID })); }
public async Task <ActionResult> Register(RegisterViewModel model, string Roles) { SelectList roles = new SelectList(db.AspNetRoles, "Id", "Name"); ViewBag.Roles = roles; var _users = db.AspNetUsers.ToList(); List <SelectListItem> _UsersRoles = new List <SelectListItem>(); foreach (var _user in _users) { var currentRoles = UserManager.GetRolesAsync(_user.Id); _UsersRoles.Add(new SelectListItem() { Text = _user.UserName, Value = currentRoles.Result.FirstOrDefault() }); } ViewBag.UsersAndRoles = _UsersRoles; ExcelMembers excelMembers = new ExcelMembers(); Error error = excelMembers.SplitFullName(model.UserLastFirstName, null, 0, out string lastName, out string firstName, out string middleName); if (error.errCode != ErrorDetail.Success) { ModelState.AddModelError("User Name Error", error.errMsg + ". Please enter last name and first name, separated by a comma."); return(View(model)); } if (ModelState.IsValid) { string selectedRole = roles.Where(t => t.Value == Roles).FirstOrDefault().Text; var user = new ApplicationUser { UserName = model.Email + ":" + selectedRole, Email = model.Email }; // placing selected Role Name to User Name in AspNetUsers table var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { using (LRCEntities context = new LRCEntities()) { try { AspNetUsers aUser = context.AspNetUsers.Where(s => s.Email.ToUpper() == model.Email.ToUpper()).FirstOrDefault(); aUser.LastFirstName = model.UserLastFirstName; context.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; } } } } if (error.errCode != ErrorDetail.Success) { ModelState.AddModelError("User Name Update Failed", error.errMsg); return(View(model)); } return(RedirectToAction("RegistrationRequestSentToAdmin", "Account")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
//Assign tb_MemberEmail record for current Member public static List <string> AssignEmail(string email, int emailTypeID, bool isEmailPrimary, string source, int mID, string userId) { Error error = new Error(); error.errCode = ErrorDetail.Success; error.errMsg = ErrorDetail.GetMsg(error.errCode); List <string> errs = new List <string>(); using (LRCEntities context = new LRCEntities()) { // Check if email(s) exist for current member var memberEmailAddresses = context.tb_MemberEmail.Where(s => s.MemberID == mID).OrderByDescending(s => s.CreatedDateTime).ToArray(); if (memberEmailAddresses.Count() > 0) //Current member has email(s) { int recornNumber = 0; foreach (var me in memberEmailAddresses) { if (++recornNumber <= MvcApplication.MaxRecordsInEmailHistory) //Leaving 10 records only and updating them { if (isEmailPrimary) { me.IsPrimary = false; //Set IsPrimary to false for all other member email from history if (me.EndDate == null) //EndDate == null means current Member email is actual (isn't record for history) { me.EndDate = DateTime.UtcNow; } } } else //Remove the excess. In the history we leave only MaxRecordsInEmailHistory = 10 entries { context.tb_MemberEmail.Remove(me); } try { context.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); return(errs); } } } //Assign new email to a current Member //Check dublicates memberEmailAddresses = memberEmailAddresses.Where(s => s.MemberID == mID && s.EmailAddress == email).ToArray(); if (memberEmailAddresses.Count() == 0) // add new email { tb_MemberEmail emailAddress = new tb_MemberEmail() { MemberID = mID, EmailAddress = email, IsPrimary = isEmailPrimary, EmailTypeID = emailTypeID, Source = source, CreatedDateTime = DateTime.Now, ModifiedBy = userId, StartDate = DateTime.UtcNow, EndDate = null }; if (!isEmailPrimary) { emailAddress.EndDate = DateTime.UtcNow; } context.tb_MemberEmail.Add(emailAddress); } else // edit old email { var emailAddress = context.tb_MemberEmail.Where(s => s.MemberID == mID && s.EmailAddress == email).FirstOrDefault(); emailAddress.IsPrimary = isEmailPrimary; emailAddress.EmailTypeID = emailTypeID; emailAddress.Source = source; emailAddress.ModifiedBy = userId; emailAddress.ModifiedDateTime = DateTime.Now; emailAddress.StartDate = DateTime.UtcNow; emailAddress.EndDate = null; if (!isEmailPrimary) { emailAddress.EndDate = DateTime.UtcNow; } } try { context.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); return(errs); } return(errs); } }
//Get tb_MemberAddress record for current Member //Assign MemberID for existing Member or return tb_MemberAddress.MemberID = 0 for new one public static List <string> AssignAddress(string _HomeStreet1, string _HomeStreet2, string city, string st, string postal, int addressTypeID, bool isAdressPrimary, string source, int sourceID, int mID, string userId) { Error error = new Error(); error.errCode = ErrorDetail.Success; error.errMsg = ErrorDetail.GetMsg(error.errCode); List <string> errs = new List <string>(); //int cityId = GetCityID(city); using (LRCEntities context = new LRCEntities()) { // Check if address(es) exist for current member var memberAddresses = context.tb_MemberAddress.Where(s => s.MemberID == mID).OrderByDescending(s => s.CreatedDateTime).ToArray(); var stateNo = 1; try { stateNo = context.tb_States.Where(x => x.StateCode.ToUpper() == st.ToUpper()).FirstOrDefault().StateID; } catch { stateNo = 1; } if (memberAddresses.Count() > 0) //Current member has address(es) { int recornNumber = 0; foreach (var ma in memberAddresses) { if (++recornNumber <= MvcApplication.MaxRecordsInAddressHistory) //Leaving 5 records only and updating them { if (isAdressPrimary) { ma.IsPrimary = false; //Set IsPrimary to false for all of addresses of current member. if (ma.EndDate == null) //EndDate == null means current Member Address is actual (isn't record for history) { ma.EndDate = DateTime.UtcNow; } } } else //Remove the excess. In the history we leave only MaxRecordsInAddressHistory = 5 entries { context.tb_MemberAddress.Remove(ma); } try { context.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); return(errs); } } } //Assign new address to the current Member //Check dublicates memberAddresses = memberAddresses.Where(s => s.MemberID == mID && s.HomeStreet1 == _HomeStreet1 && s.City == city && s.ZipCode == postal).ToArray(); if (memberAddresses.Count() == 0) // add new address { tb_MemberAddress address = new tb_MemberAddress() { MemberID = mID, HomeStreet1 = _HomeStreet1, HomeStreet2 = _HomeStreet2, City = city, ZipCode = postal, StateID = stateNo, Country = "USA", SourceID = sourceID, // 1 -Card/Form, 2 - Employer Source = userId, IsPrimary = isAdressPrimary, AddressTypeID = addressTypeID, CreatedDateTime = DateTime.Now, ModifiedBy = userId, StartDate = DateTime.UtcNow, EndDate = null }; if (!isAdressPrimary) { address.EndDate = DateTime.UtcNow; } context.tb_MemberAddress.Add(address); } else // edit old address { var address = context.tb_MemberAddress.Where(s => s.MemberID == mID && s.HomeStreet1 == _HomeStreet1 && s.City == city && s.ZipCode == postal).FirstOrDefault(); address.HomeStreet2 = _HomeStreet2; address.StateID = stateNo; address.Country = "USA"; address.SourceID = sourceID; address.Source = userId; address.IsPrimary = isAdressPrimary; address.AddressTypeID = addressTypeID; address.ModifiedBy = userId; address.ModifiedDateTime = DateTime.Now; address.StartDate = DateTime.UtcNow; address.EndDate = null; if (!isAdressPrimary) { address.EndDate = DateTime.UtcNow; } } try { context.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); return(errs); } } return(errs); }
public static string GetExportString(int CollegeID, int DepartmentID, string searchString) { //int CollegeID = (int)System.Web.HttpContext.Current.Profile.GetPropertyValue("CollegeID"); //int DepartmentID = (int)System.Web.HttpContext.Current.Profile.GetPropertyValue("DepartmentID"); //string searchString = (string)System.Web.HttpContext.Current.Profile.GetPropertyValue("SearchString"); List <tb_Department> deps = new List <tb_Department>(); List <tb_MemberMaster> members = new List <tb_MemberMaster>(); var sb = new StringBuilder(); using (LRCEntities context = new LRCEntities()) { if (DepartmentID > 0) { deps = context.tb_Department.Where(c => c.DepartmentID == DepartmentID).ToList(); } else { deps = context.tb_Department.Where(c => c.CollegeID == CollegeID).ToList(); } foreach (var dep in deps) { List <tb_MemberMaster> membersInDep = context.tb_MemberMaster.Where(t => t.DepartmentID == dep.DepartmentID).ToList(); if (membersInDep.Count > 0) { foreach (var item in membersInDep) { if (String.IsNullOrEmpty(searchString)) { members.Add(item); } //Searching @ Filtering else if (item.LastName.ToUpper().Contains(searchString.ToUpper()) || item.FirstName.ToUpper().Contains(searchString.ToUpper())) { members.Add(item); } } } } sb.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18}", "ID", "INSTRCTR", "CAMPUS", "LOCATION", "BUILDING", "ROOM", "DIV", "CLASS#", "SECT", "SUBJCD", "CATBR", "LEC LAB", "SBTM", "ATT TP", "BEGTIME", "ENDTIME", "DAYS", "CLASSEND DT", Environment.NewLine); foreach (var item in members) { List <tb_SemesterTaught> semesterTaught = context.tb_SemesterTaught.Where(t => t.MemberID == item.MemberID).ToList(); foreach (var taught in semesterTaught) { sb.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18}", item.MemberIDNumber ?? String.Empty, //ID item.FirstName + " " + item.LastName + " " + item.MiddleName, //INSTRCTR taught.tb_Building.tb_Campus.CollegeCode ?? String.Empty, //CAMPUS taught.tb_Building.tb_Campus.CollegeCode + " MAIN", //LOCATION taught.tb_Building.BuildingName ?? String.Empty, //BUILDING taught.Room ?? String.Empty, //ROOM item.tb_Division.DivisionName ?? String.Empty, //DIV taught.Class ?? String.Empty, //CLASS# "?", //SECT "?", //SUBJCD "?", //CATBR "?", //LEC LAB "?", //SBTM "?", //ATT TP taught.ClassStart.ToString(@"hh\:mm"), //BEGTIME taught.ClassEnd.ToString(@"hh\:mm"), //ENDTIME taught.tb_WeekDay.WeekDayName, //DAYS "?", //CLASSEND DT Environment.NewLine); } } } return(sb.ToString()); }
public ActionResult CreateActivity([Bind(Include = "_ActivityName,_ActivityDate,_ActivityNote,_CollegeID,_CampusID,_Callback,_MemberId,_ReturnCollegeID")] ActivityModels model, FormCollection formCollection) { Error error = new Error(); error.errCode = ErrorDetail.Success; error.errMsg = ErrorDetail.GetMsg(error.errCode); List <string> errs = new List <string>(); model._Colleges = new List <SelectListItem> { new SelectListItem() { Value = "0", Text = "-- Select One --" } }.Concat(db.tb_College.Select(x => new SelectListItem { Value = x.CollegeID.ToString(), Text = x.CollegeName })); model._Campuses = new SelectList(db.tb_Campus.Where(s => s.CollegeID == model._CollegeID).OrderBy(s => s.CampusName), "CampusID", "CampusName"); var userId = HttpContext.GetOwinContext().Authentication.User.Identity.GetUserId(); using (LRCEntities context = new LRCEntities()) { tb_Activity tb_Activity = new tb_Activity { ActivityName = model._ActivityName, ActivityDate = model._ActivityDate, CampusID = model._CampusID, ActivityNote = model._ActivityNote, AddedBy = userId, AddedDateTime = DateTime.UtcNow }; context.tb_Activity.Add(tb_Activity); try { context.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["ErrorList"] = errs; return(View(model)); } } switch (model._Callback) { case "AddActivityByMember": return(RedirectToAction("AddActivityByMember")); case "AddActivity": return(RedirectToAction("AddActivity", new { @id = model._MemberId })); case "AddPersonAssessmentActivity": return(RedirectToAction("AddPersonAssessmentActivity", "Assessment", new { @id = model._MemberId, CollegeID = model._ReturnCollegeID })); default: break; } return(View(model)); }
public JsonResult GetActivityDetailsById(int activityID, int memberID) { List <tb_Activity> activities = new List <tb_Activity>(); string json = String.Empty; using (LRCEntities context = new LRCEntities()) { if (activityID == 0) { ActivityJSON activity = new ActivityJSON { ActivityDate = String.Empty, ActivityNote = String.Empty, AddedBy = String.Empty, AddedDateTime = String.Empty, ActivityStatusBeforeTheFact = "Not Defined", ActivityStatusAfterTheFact = "Not Defined" }; json = JsonConvert.SerializeObject(activity, Formatting.Indented); } else { var tb_Activity = context.tb_Activity.Where(a => a.ActivityID == activityID).ToList <tb_Activity>().FirstOrDefault(); var tb_MemberActivity = context.tb_MemberActivity.Where(a => a.MemberID == memberID && a.ActivityID == activityID).ToList <tb_MemberActivity>().FirstOrDefault(); string addedDateTime = String.Empty; var d = tb_Activity.AddedDateTime ?? DateTime.MinValue; if (d == DateTime.MinValue) { addedDateTime = " - "; } else { addedDateTime = d.ToString("yyyy-MM-dd"); } string beforeTheFact = "Not Defined"; string afterTheFact = "Not Defined"; if (tb_MemberActivity != null) { if (tb_MemberActivity.Participated.GetValueOrDefault()) { afterTheFact = "Participated"; } else { afterTheFact = "Not Participated"; } if (!tb_MemberActivity.Participated.HasValue) { afterTheFact = "Not Defined"; } beforeTheFact = tb_MemberActivity.tb_ActivityStatus.ActivityStatusName; } ActivityJSON activity = new ActivityJSON { ActivityDate = tb_Activity.ActivityDate.ToString("yyyy-MM-dd"), ActivityNote = tb_Activity.ActivityNote, AddedBy = context.AspNetUsers.Where(s => s.Id == tb_Activity.AddedBy).FirstOrDefault().LastFirstName, AddedDateTime = addedDateTime, ActivityStatusBeforeTheFact = beforeTheFact, ActivityStatusAfterTheFact = afterTheFact }; json = JsonConvert.SerializeObject(activity, Formatting.Indented); } } return(Json(json, JsonRequestBehavior.AllowGet)); }