public ActionResult AddAssessment(int?id)
{
if (id == null)
{
return(RedirectToAction("Index", "Errors", new { name = "Bad Request", description = "Member ID as parameter cannot be NULL" }));
}
List <string> errs = new List <string>();
tb_Assessment MA = new tb_Assessment {
MemberID = id ?? 0, AssessmentDate = DateTime.UtcNow
};
ViewBag.AssessmentNameID = new SelectList(db.tb_AssessmentName, "AssessmentNameID", "AssessmentName" /*, tb_Assessment.AssessmentNameID*/);
ViewBag.ValueID = new SelectList(db.tb_AssessmentValue, "ValueID", "ValueName" /*, tb_Assessment.ValueID*/ /* selected value */);
ViewBag.AssessedBy = new SelectList(db.AspNetUsers.OrderBy(s => s.LastFirstName), "Id", "LastFirstName");
ViewBag.MemberAssessments = db.tb_Assessment.Where(f => f.tb_MemberMaster.MemberID == id).ToList();
errs.Add("Empty");
ViewData["ErrorList"] = errs;
return(View(MA));
}
public ActionResult DeleteAssessment(int?AssessmentID, int?MemberId, int?CollegeID)
{
Error error = new Error();
error.errCode = ErrorDetail.Success;
if (AssessmentID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (LRCEntities context = new LRCEntities())
{
try
{
tb_Assessment assessment = context.tb_Assessment.Find(AssessmentID);
if (assessment == null)
{
return(HttpNotFound());
}
context.tb_Assessment.Remove(assessment);
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 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 AddBackgroundStory([Bind(Include = "AssessmentID,MemberID,AssessmentNameID,AssessmentDesc,ValueID,AssessmentDate,AssessedBy,BackgroundStory,Fears,AttitudeTowardUnion,IDdLeaders,FollowUp")] tb_Assessment model /*, string AssessedBy*/)
{
Error error = new Error();
error.errCode = ErrorDetail.Success;
List <string> errs = new List <string>();
ViewBag.AssessmentNameID = new SelectList(db.tb_AssessmentName, "AssessmentNameID", "AssessmentName", model.AssessmentNameID);
ViewBag.ValueID = new SelectList(db.tb_AssessmentValue, "ValueID", "ValueName", model.ValueID /* selected value */);
ViewBag.MemberID = new SelectList(db.tb_MemberMaster, "MemberID", "LastName", model.MemberID);
ViewBag.AssessedBy = new SelectList(db.AspNetUsers, "Id", "LastFirstName", model.AssessedBy).OrderBy(s => s.Value);
if (String.IsNullOrEmpty(model.Evaluation))
{
errs.Add("Required field!" + "Evaluation text area can not be empty");
ViewData["ErrorList"] = errs; return(View(model));
}
if (ModelState.IsValid)
{
try
{
var uName = HttpContext.GetOwinContext().Authentication.User.Identity.GetUserName();
model.AddedBy = uName;
model.AddedDateTime = DateTime.UtcNow;
db.tb_Assessment.Attach(model);
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["ErrorList"] = errs;
return(View(model));
}
return(RedirectToAction("Details", "Home", new { @id = model.MemberID }));
}
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;
return(View(model));
}
}
public ActionResult AddAssessment([Bind(Include = "AssessmentID,MemberID,AssessmentNameID,AssessmentDesc,ValueID,AssessmentDate,AssessedBy,Evaluation")] tb_Assessment model /*, string AssessedBy*/)
{
Error error = new Error();
error.errCode = ErrorDetail.Success;
List <string> errs = new List <string>();
ViewBag.AssessmentNameID = new SelectList(db.tb_AssessmentName, "AssessmentNameID", "AssessmentName", model.AssessmentNameID);
ViewBag.ValueID = new SelectList(db.tb_AssessmentValue, "ValueID", "ValueName", model.ValueID /* selected value */);
ViewBag.MemberID = new SelectList(db.tb_MemberMaster, "MemberID", "LastName", model.MemberID);
ViewBag.AssessedBy = new SelectList(db.AspNetUsers.OrderBy(s => s.LastFirstName), "Id", "LastFirstName", model.AssessedBy);
if (ModelState.IsValid)
{
try
{
var userId = HttpContext.GetOwinContext().Authentication.User.Identity.GetUserId();
model.AddedBy = userId;
model.AddedDateTime = DateTime.UtcNow;
db.tb_Assessment.Add(model);
// Next commented block of code in case if we may have only 1 assessment fot a Member
//var memberAssessment = db.tb_Assessment.Where(s => s.MemberID == model.MemberID).FirstOrDefault();
//if (memberAssessment == null) //Add new member assessment
//{
// model.AddedBy = userId;
// model.AddedDateTime = DateTime.UtcNow;
// db.tb_Assessment.Add(model);
//}
//else // Edit previous member assessment
//{
// memberAssessment.ModifiedBy = userId;
// memberAssessment.AssessmentDate = model.AssessmentDate;
// memberAssessment.AssessedBy = model.AssessedBy;
// memberAssessment.AssessmentNameID = model.AssessmentNameID;
// memberAssessment.ValueID = model.ValueID;
// memberAssessment.Evaluation = model.Evaluation;
// db.Entry(memberAssessment).State = EntityState.Modified;
//}
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["ErrorList"] = errs;
return(View(model));
}
return(RedirectToAction("Details", "Home", new { @id = model.MemberID }));
}
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;
return(View(model));
}
}