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));
}
