public ActionResult Add(int?legalEntityFK)
{
TempData["legalEntityFK"] = legalEntityFK;
AssessmentsView assessmentView = new AssessmentsView();
// Assessment types ddl
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentView.AssessmentTypes = new SelectList(assessmentTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "AssessmentTypePK", "Name");
//legalEntities ddl
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
if (legalEntityFK != null)
{
TempData["legalEntityFK"] = legalEntityFK;
assessmentView.LegalEntityFK = (int)legalEntityFK;
assessmentView.LegalEntityName = legalEntitiesRepository.GetLegalEntityByPK((int)legalEntityFK).Name;
}
// Assessment types
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
IAssessmentQuestionsRepository assessmentQuestionsRepository = new AssessmentQuestionsRepository(db);
assessmentView.AssessmentsTypesView = AssessmentsView.FillQuiz(assessmentTypesRepository.GetValid(), assessmentGroupsRepository, assessmentQuestionsRepository, null);
return(View(assessmentView));
}
public ActionResult Index()
{
IAssessmentQuestionsRepository assessmentQuestionsRepository = new AssessmentQuestionsRepository(db);
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
int page = !String.IsNullOrWhiteSpace(Request.QueryString["page"]) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
int pageSize = !String.IsNullOrWhiteSpace(Request.QueryString["pageSize"]) ? Convert.ToInt32(Request.QueryString["pageSize"]) : Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ResultsPerPage"]);
string sortOrder = !String.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !String.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "AssessmentQuestionPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <AssessmentQuestionView> assessmentQuestions = AssessmentQuestionView.GetAssessmentQuestionView(assessmentQuestionsRepository.GetValid(), assessmentGroupsRepository.GetValid(), assessmentTypesRepository.GetValid())
.OrderBy(ordering);
//AssessmentGroups ddl
ViewBag.AssessmentGroups = new SelectList(assessmentGroupsRepository.GetValid().OrderBy("Name ASC").ToList(), "AssessmentGroupPK", "Name", Request.QueryString["assessmentGroupFK"]);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
assessmentQuestions = assessmentQuestions.Where(c => c.Name.Contains(searchString));
}
if (!String.IsNullOrWhiteSpace(Request.QueryString["assessmentGroupFK"]))
{
int assessmentGroupFK = Convert.ToInt32(Request.QueryString["assessmentGroupFK"]);
assessmentQuestions = assessmentQuestions.Where(c => c.AssessmentGroupFK == assessmentGroupFK);
}
assessmentQuestions = assessmentQuestions.Page(page, pageSize);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
ViewData["numberOfRecords"] = assessmentQuestionsRepository.GetValid().Where(c => c.Name.Contains(searchString)).Count();
}
else
{
ViewData["numberOfRecords"] = assessmentQuestionsRepository.GetValid().Count();
}
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("AssessmentQuestion?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", assessmentQuestions.ToList()));
}
}
public void BindDDLs(AssessmentQuestionView assessmentQuestionView, ObjectContext db)
{
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentQuestionView.AssessmentTypes = new SelectList(assessmentTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "AssessmentTypePK", "Name");
//assement question ddl
if (assessmentQuestionView.AssessmentTypeFK != null)
{
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
assessmentQuestionView.AssessmentGroups = new SelectList(assessmentGroupsRepository.GetAssessmentGroupsByType(Convert.ToInt32((int)assessmentQuestionView.AssessmentTypeFK)), "AssessmentGroupPK", "Name");
}
else
{
assessmentQuestionView.AssessmentGroups = new SelectList(new List <AssessmentGroup>(), "AssessmentGroupPK", "Name");
}
}
public ActionResult Delete(int?assessmentTypePK)
{
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
if (assessmentTypePK != null)
{
AssessmentType assessmentType = assessmentTypesRepository.GetAssessmentTypeByPK((int)assessmentTypePK);
assessmentType.Deleted = true;
assessmentTypesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("DELETE", assessmentType.AssessmentTypePK);
}
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
public ActionResult Edit(int?assessmentTypePK)
{
if (assessmentTypePK != null)
{
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
AssessmentType assessmentType = assessmentTypesRepository.GetAssessmentTypeByPK((int)assessmentTypePK);
AssessmentTypeView assessmentTypeView = new AssessmentTypeView();
assessmentTypeView.ConvertFrom(assessmentType, assessmentTypeView);
return(View(assessmentTypeView));
}
else
{
return(RedirectToAction("Index", "AssessmentType"));
}
}
public ActionResult Edit(AssessmentTypeView assessmentTypeModel)
{
if (ModelState.IsValid)
{
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
AssessmentType assessmentType = assessmentTypesRepository.GetAssessmentTypeByPK((int)assessmentTypeModel.AssessmentTypePK);
assessmentTypeModel.ConvertTo(assessmentTypeModel, assessmentType);
assessmentTypesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("UPDATE", assessmentType.AssessmentTypePK);
return(RedirectToAction("Index", "AssessmentType"));
}
else
{
return(View(assessmentTypeModel));
}
}
public ActionResult Edit(int?assessmentPK)
{
if (assessmentPK != null)
{
IAssessmentsRepository assessmentsRepository = new AssessmentsRepository(db);
Assessment assessment = assessmentsRepository.GetAssessmentByPK((int)assessmentPK);
AssessmentsView assessmentView = new AssessmentsView();
assessmentView.ConvertFrom(assessment, assessmentView);
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentView.AssessmentTypes = new SelectList(assessmentTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "AssessmentTypePK", "Name");
// Assessment types ddl
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
IAssessmentQuestionsRepository assessmentQuestionsRepository = new AssessmentQuestionsRepository(db);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)assessment.LegalEntityFK);
assessmentView.LegalEntityName = legalEntity.Name + " (" + legalEntity.OIB + ")";
FormCollection form = new FormCollection();
IAssessmentAnswersRepository assessmentAnswersRepository = new AssessmentAnswersRepository(db);
IQueryable <AssessmentAnswers> assessmentAnswers = assessmentAnswersRepository.GetAssessmentAnswersByAssessment((int)assessmentPK);
foreach (var assessmentAnswer in assessmentAnswers)
{
string answer = assessmentAnswer.AssessmentAnswer == null ? "NP": (bool)assessmentAnswer.AssessmentAnswer ? "Da" : "Ne";
form.Add("answer[" + assessmentAnswer.AssessmentQuestionFK + "]", answer);
}
assessmentView.AssessmentsTypesView = AssessmentsView.FillQuiz(assessmentTypesRepository.GetValid(), assessmentGroupsRepository, assessmentQuestionsRepository, form);
return(View(assessmentView));
}
else
{
return(RedirectToAction("Index", "Assessment"));
}
}
public ActionResult Add(AssessmentTypeView assessmentTypeView)
{
if (ModelState.IsValid)
{
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
AssessmentType assessmentType = new AssessmentType();
assessmentTypeView.ConvertTo(assessmentTypeView, assessmentType);
assessmentTypesRepository.Add(assessmentType);
assessmentTypesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("INSERT", assessmentType.AssessmentTypePK);
return(RedirectToAction("Index", "AssessmentType"));
}
else
{
return(View(assessmentTypeView));
}
}
public void BindDDLs(AssessmentGroupView assessmentGroupView, ObjectContext db)
{
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentGroupView.AssessmentTypes = new SelectList(assessmentTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "AssessmentTypePK", "Name");
}
public ActionResult Edit(AssessmentsView assessmentView, FormCollection form)
{
if (ModelState.IsValid)
{
IAssessmentsRepository assessmentsRepository = new AssessmentsRepository(db);
Assessment assessment = assessmentsRepository.GetAssessmentByPK((int)assessmentView.AssessmentPK);
IAssessmentAnswersRepository assessmentAnswersRepository = new AssessmentAnswersRepository(db);
// Delete old values
assessmentAnswersRepository.Delete(a => a.AssessmentFK == assessment.AssessmentPK);
// Add new values
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
IAssessmentQuestionsRepository assessmentQuestionsRepository = new AssessmentQuestionsRepository(db);
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentView.AssessmentsTypesView = AssessmentsView.FillQuiz(assessmentTypesRepository.GetValid(), assessmentGroupsRepository, assessmentQuestionsRepository, form);
// Fetching answered type
AssessmentsTypeView atw = assessmentView.AssessmentsTypesView.Where(a => a.AssessmentType.AssessmentTypePK == assessmentView.AssessmentTypeFK).First();
List <AssessmentAnswers> assessmentAnswers = AssessmentAnswerView.ExtractQuizAnswers(atw, assessment.AssessmentPK);
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
LegalEntity legalEntity = legalEntitiesRepository.GetLegalEntityByPK((int)assessmentView.LegalEntityFK);
bool activityHighRisky = legalEntity.Activity.HighRisk != null && (bool)legalEntity.Activity.HighRisk ? true : false;
bool activityLowRisky = legalEntity.Activity.LowRisk != null && (bool)legalEntity.Activity.LowRisk ? true : false;
bool headquarterCountryRisky = legalEntity.Country.Risk != null && (bool)legalEntity.Country.Risk ? true : false;
IRisksRepository risksRepository = new RisksRepository(db);
if (activityHighRisky || headquarterCountryRisky) // check explicitly if related legalEntity activity is high risk
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Visok").RiskPK;
}
else if (activityLowRisky) // check explicitly if related legalEntity activity is low risk
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Nizak").RiskPK;
}
else // run assesment quiz
{
ILegalEntityOwnersRepository legalEntityOwnersRepository = new LegalEntityOwnersRepository(db);
IQueryable <LegalEntityOwner> legalEntityOwnersTable = legalEntityOwnersRepository.GetValid();
ICountriesRepository countriesRepository = new CountriesRepository(db);
IActivitiesRepository activitiesRepository = new ActivitiesRepository(db);
List <LegalEntityOwner> coList = legalEntityOwnersRepository.GetFirstLegalEntityOwnersForLegalEntity((int)assessmentView.LegalEntityFK).ToList();
legalEntityOwnersTable = LegalEntityOwnerView.GetLegalEntityOwnersForLegalEntity(Convert.ToInt32(assessmentView.LegalEntityFK), coList, legalEntityOwnersTable);
IQueryable <LegalEntity> legalEntityView = LegalEntityOwnerView.GetRelatedLegalEntities(legalEntityOwnersTable, legalEntitiesRepository.GetValid(), countriesRepository.GetValid(), activitiesRepository.GetValid());
// check owners risks
bool ownersResidenceCountryRisky = false;
bool ownersActivitiesHighlyRisky = false;
bool ownersActivitiesLowRisky = false;
if (legalEntityView.Count() > 0)
{
if (legalEntityView.ToList().TrueForAll(le => le.Country.Risk == null || (le.Country.Risk != null && (bool)le.Country.Risk != true)) == false)
{
ownersResidenceCountryRisky = true;
}
if (legalEntityView.ToList().TrueForAll(le => le.Activity == null || (le.Activity.HighRisk == null || (le.Activity.HighRisk != null && (bool)le.Activity.HighRisk != true))) == false)
{
ownersActivitiesHighlyRisky = true;
}
if (legalEntityView.ToList().TrueForAll(le => le.Activity == null || (le.Activity.LowRisk == null || (le.Activity.LowRisk != null && (bool)le.Activity.LowRisk != true))) == false)
{
ownersActivitiesLowRisky = true;
}
}
// check form
bool allAnswersYes = false;
bool allAnswersNo = false;
bool mixedAnswers = false;
if (assessmentAnswers.TrueForAll(aa => aa.AssessmentAnswer != null && (bool)aa.AssessmentAnswer == true))
{
allAnswersYes = true;
}
if (assessmentAnswers.TrueForAll(aa => aa.AssessmentAnswer != null && (bool)aa.AssessmentAnswer == false))
{
allAnswersNo = true;
}
if (allAnswersYes == false && allAnswersNo == false)
{
mixedAnswers = true;
}
// check general conditions
if (ownersActivitiesLowRisky)
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Nizak").RiskPK;
}
else if (allAnswersYes || ownersResidenceCountryRisky || ownersActivitiesHighlyRisky)
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Visok").RiskPK;
}
else if (allAnswersNo || mixedAnswers)
{
assessmentView.RiskFK = risksRepository.GetRiskByName("Srednji").RiskPK;
}
}
if (assessmentAnswers.Count() > 0)
{
assessmentAnswersRepository.AddAll(assessmentAnswers);
assessmentAnswersRepository.SaveChanges();
}
assessmentView.ConvertTo(assessmentView, assessment);
assessmentsRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("UPDATE", assessment.AssessmentPK);
return(RedirectToAction("Index", "Assessment"));
}
else
{
IAssessmentGroupsRepository assessmentGroupsRepository = new AssessmentGroupsRepository(db);
IAssessmentQuestionsRepository assessmentQuestionsRepository = new AssessmentQuestionsRepository(db);
//Assessment types ddl
IAssessmentTypesRepository assessmentTypesRepository = new AssessmentTypesRepository(db);
assessmentView.AssessmentTypes = new SelectList(assessmentTypesRepository.GetValid().OrderBy("Name ASC").ToList(), "AssessmentTypePK", "Name");
//legalEntities ddl
ILegalEntitiesRepository legalEntitiesRepository = new LegalEntitiesRepository(db);
assessmentView.LegalEntities = new SelectList(legalEntitiesRepository.GetValidLegalEntities().ToList(), "LegalEntityPK", "Name");
assessmentView.AssessmentsTypesView = AssessmentsView.FillQuiz(assessmentTypesRepository.GetValid(), assessmentGroupsRepository, assessmentQuestionsRepository, form);
return(View(assessmentView));
}
}
