public ActionResult QuestionSelect()
{
if (Request.IsAuthenticated)
{
string UserName = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
tblQuestionnaireSubStrengthResult temp = db.tblQuestionnaireSubStrengthResults.Where(x => x.UserName == UserName).FirstOrDefault();
tblQuestionnaireLogin login = db.tblQuestionnaireLogins.Where(x => x.UserName == UserName).FirstOrDefault();
if (login.IsAdmin == "1")
{
return(RedirectToAction("Career", "AdminQuestionnaire"));
}
if (temp == null)
{
List <Sp_QuestionList_Result> list = db.Sp_QuestionList().ToList();
return(View(list));
}
else
{
return(RedirectToAction("DashBoard", "DashBoardQuestionnaire"));
}
}
else
{
return(RedirectToAction("Login", "LoginQuestionnaire"));
}
}
public JsonResult Questions(int[] marks)
{
if (marks != null)
{
string UserName = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
for (int i = 0; i < marks.Length; i++)
{
int count = db.tblQuestionnaireSubStrengthQuestions.Where(x => x.SubStrengthId == i).Count();
int limit = 15 * count;
if (marks[i] > limit)
{
return(Json(new { Status = false }));
}
}
tblQuestionnaireSubStrengthResult temp = db.tblQuestionnaireSubStrengthResults.Where(x => x.UserName == UserName).FirstOrDefault();
if (temp == null)
{
tblQuestionnaireSubStrengthResult result = new tblQuestionnaireSubStrengthResult();
result.UserName = UserName;
result.Artistic = marks[1];
result.Aesthetic = marks[2];
result.Idea_Generator = marks[3];
result.Team_Player = marks[4];
result.Independent = marks[5];
result.Mentor = marks[6];
result.Analytics = marks[7];
result.Social_Philosophical = marks[8];
result.Practical = marks[9];
result.Average = Convert.ToDecimal(marks.Sum()) / 9;
db.tblQuestionnaireSubStrengthResults.Add(result);
db.SaveChanges();
return(Json(new { Status = true }));
}
else
{
return(Json(new { Status = false }));
}
}
else
{
return(Json(new { Status = false }));
}
}
public JsonResult GetColumnChartData()
{
string UserName = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
tblQuestionnaireSubStrengthResult temp = db.tblQuestionnaireSubStrengthResults.Where(x => x.UserName == UserName).FirstOrDefault();
List <SubStrengthValueChart> list = new List <SubStrengthValueChart>();
SubStrengthValueChart Artistic = new SubStrengthValueChart();
Artistic.Name = "Artistic";
Artistic.Value = temp.Artistic;
list.Add(Artistic);
SubStrengthValueChart Aesthetic = new SubStrengthValueChart();
Aesthetic.Name = "Aesthetic";
Aesthetic.Value = temp.Aesthetic;
list.Add(Aesthetic);
SubStrengthValueChart Idea_Generator = new SubStrengthValueChart();
Idea_Generator.Name = "Idea Generator";
Idea_Generator.Value = temp.Idea_Generator;
list.Add(Idea_Generator);
SubStrengthValueChart Team_Player = new SubStrengthValueChart();
Team_Player.Name = "Team Player";
Team_Player.Value = temp.Team_Player;
list.Add(Team_Player);
SubStrengthValueChart Independent = new SubStrengthValueChart();
Independent.Name = "Independent";
Independent.Value = temp.Independent;
list.Add(Independent);
SubStrengthValueChart Mentor = new SubStrengthValueChart();
Mentor.Name = "Mentor";
Mentor.Value = temp.Mentor;
list.Add(Mentor);
SubStrengthValueChart Analytics = new SubStrengthValueChart();
Analytics.Name = "Analytics";
Analytics.Value = temp.Analytics;
list.Add(Analytics);
SubStrengthValueChart Social_Philosophical = new SubStrengthValueChart();
Social_Philosophical.Name = "Social Philosophical";
Social_Philosophical.Value = temp.Social_Philosophical;
list.Add(Social_Philosophical);
SubStrengthValueChart Practical = new SubStrengthValueChart();
Practical.Name = "Practical";
Practical.Value = temp.Practical;
list.Add(Practical);
return(Json(list, JsonRequestBehavior.AllowGet));
}
// GET: DashBoard
public ActionResult DashBoard()
{
if (Request.IsAuthenticated)
{
string UserName = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
tblQuestionnaireSubStrengthResult temp = db.tblQuestionnaireSubStrengthResults.Where(x => x.UserName == UserName).FirstOrDefault();
tblQuestionnaireLogin login = db.tblQuestionnaireLogins.Where(x => x.UserName == UserName).FirstOrDefault();
if (login.IsAdmin == "1")
{
return(RedirectToAction("Career", "AdminQuestionnaire"));
}
if (temp == null)
{
return(RedirectToAction("TermsAndConditions", "HomeQuestionnaire"));
}
else
{
tblQuestionnaireFieldLogicResult tblQuestionnaireFieldLogicResult = db.tblQuestionnaireFieldLogicResults.Where(x => x.UserName == UserName).FirstOrDefault();
if (tblQuestionnaireFieldLogicResult == null)
{
List <SubStrengthValue> list = new List <SubStrengthValue>();
SubStrengthValue Artistic = new SubStrengthValue();
Artistic.Name = 1;
Artistic.Value = temp.Artistic;
list.Add(Artistic);
SubStrengthValue Aesthetic = new SubStrengthValue();
Aesthetic.Name = 2;
Aesthetic.Value = temp.Aesthetic;
list.Add(Aesthetic);
SubStrengthValue Idea_Generator = new SubStrengthValue();
Idea_Generator.Name = 3;
Idea_Generator.Value = temp.Idea_Generator;
list.Add(Idea_Generator);
SubStrengthValue Team_Player = new SubStrengthValue();
Team_Player.Name = 4;
Team_Player.Value = temp.Team_Player;
list.Add(Team_Player);
SubStrengthValue Independent = new SubStrengthValue();
Independent.Name = 5;
Independent.Value = temp.Independent;
list.Add(Independent);
SubStrengthValue Mentor = new SubStrengthValue();
Mentor.Name = 6;
Mentor.Value = temp.Mentor;
list.Add(Mentor);
SubStrengthValue Analytics = new SubStrengthValue();
Analytics.Name = 7;
Analytics.Value = temp.Analytics;
list.Add(Analytics);
SubStrengthValue Social_Philosophical = new SubStrengthValue();
Social_Philosophical.Name = 8;
Social_Philosophical.Value = temp.Social_Philosophical;
list.Add(Social_Philosophical);
SubStrengthValue Practical = new SubStrengthValue();
Practical.Name = 9;
Practical.Value = temp.Practical;
list.Add(Practical);
list = list.Where(x => x.Value > temp.Average).OrderByDescending(x => x.Value).ToList();
List <tblQuestionnaireFieldLogic> fieldLogic = db.tblQuestionnaireFieldLogics.ToList();
foreach (var item in fieldLogic)
{
tblQuestionnaireFieldLogicResult result = new tblQuestionnaireFieldLogicResult();
result.CareerId = item.Id;
result.UserName = UserName;
result.MainField = item.MainField;
result.SubField = item.SubField;
result.Critical1 = list.Where(x => x.Name == item.Critical1).Select(x => x.Value).FirstOrDefault();
result.Critical2 = list.Where(x => x.Name == item.Critical2).Select(x => x.Value).FirstOrDefault();
result.Critical3 = list.Where(x => x.Name == item.Critical3).Select(x => x.Value).FirstOrDefault();
if (item.HygieneFactor == 0)
{
result.HygieneFactor = 1;
}
else if (item.HygieneFactor == 1)
{
if (temp.Artistic > temp.Average)
{
result.HygieneFactor = 1;
}
else
{
result.HygieneFactor = 0;
}
}
else if (item.HygieneFactor == 2)
{
if (temp.Aesthetic > temp.Average)
{
result.HygieneFactor = 1;
}
else
{
result.HygieneFactor = 0;
}
}
else if (item.HygieneFactor == 3)
{
if (temp.Idea_Generator > temp.Average)
{
result.HygieneFactor = 1;
}
else
{
result.HygieneFactor = 0;
}
}
else if (item.HygieneFactor == 4)
{
if (temp.Team_Player > temp.Average)
{
result.HygieneFactor = 1;
}
else
{
result.HygieneFactor = 0;
}
}
else if (item.HygieneFactor == 5)
{
if (temp.Independent > temp.Average)
{
result.HygieneFactor = 1;
}
else
{
result.HygieneFactor = 0;
}
}
else if (item.HygieneFactor == 6)
{
if (temp.Mentor > temp.Average)
{
result.HygieneFactor = 1;
}
else
{
result.HygieneFactor = 0;
}
}
else if (item.HygieneFactor == 7)
{
if (temp.Analytics > temp.Average)
{
result.HygieneFactor = 1;
}
else
{
result.HygieneFactor = 0;
}
}
else if (item.HygieneFactor == 8)
{
if (temp.Social_Philosophical > temp.Average)
{
result.HygieneFactor = 1;
}
else
{
result.HygieneFactor = 0;
}
}
else
{
if (temp.Practical > temp.Average)
{
result.HygieneFactor = 1;
}
else
{
result.HygieneFactor = 0;
}
}
result.Contra1 = list.Where(x => x.Name == item.Contra1).Select(x => x.Value).FirstOrDefault();
result.Contra2 = list.Where(x => x.Name == item.Contra2).Select(x => x.Value).FirstOrDefault();
if (item.HowItWorks == 1)
{
if (result.HygieneFactor == 1 && result.Contra1 == 0 && result.Contra2 == 0)
{
if (result.Critical1 == 0)
{
result.Result = 25;
}
else
{
if (item.Critical2 != 0 && result.Critical2 == 0)
{
result.Result = 75;
}
else
{
if (item.Critical3 != 0 && result.Critical3 == 0)
{
result.Result = 90;
}
else
{
result.Result = 100;
}
}
}
}
else
{
if (result.Critical1 > 0)
{
result.Result = 25;
}
else
{
result.Result = 0;
}
}
}
else if (item.HowItWorks == 2)
{
if (result.HygieneFactor == 1 && result.Contra1 == 0 && result.Contra2 == 0)
{
if (result.Critical1 == 0 && result.Critical2 == 0)
{
result.Result = 25;
}
else
{
if (result.Critical1 == 0 || result.Critical2 == 0)
{
result.Result = 50;
}
else
{
if (item.Critical3 != 0 && result.Critical3 == 0)
{
result.Result = 90;
}
else
{
result.Result = 100;
}
}
}
}
else
{
if (result.Critical1 == 0 && result.Critical2 == 0)
{
result.Result = 0;
}
else
{
result.Result = 25;
}
}
}
else if (item.HowItWorks == 3)
{
if (result.HygieneFactor == 1 && result.Contra1 == 0 && result.Contra2 == 0)
{
if (result.Critical1 == 0)
{
if (result.Critical2 == 0)
{
if (result.Critical3 == 0)
{
result.Result = 0;
}
else
{
result.Result = 25;
}
}
else
{
if (result.Critical3 == 0)
{
result.Result = 25;
}
else
{
result.Result = 50;
}
}
}
else
{
if (result.Critical2 == 0)
{
if (result.Critical3 == 0)
{
result.Result = 25;
}
else
{
result.Result = 50;
}
}
else
{
result.Result = 100;
}
}
}
else
{
if (result.Critical1 == 0 && result.Critical2 == 0 && result.Critical3 == 0)
{
result.Result = 0;
}
else
{
result.Result = 25;
}
}
}
else
{
if (result.HygieneFactor == 1 && result.Contra1 == 0 && result.Contra2 == 0)
{
if (result.Critical1 == 0 && result.Critical2 == 0 && result.Critical3 == 0)
{
result.Result = 25;
}
else
{
if (result.Critical1 > 0 || result.Critical2 > 0 || result.Critical3 > 0)
{
result.Result = 75;
}
else
{
result.Result = 100;
}
}
}
else
{
if (result.Critical1 > 0 || result.Critical2 > 0 || result.Critical3 > 0)
{
result.Result = 25;
}
else
{
result.Result = 0;
}
}
}
db.tblQuestionnaireFieldLogicResults.Add(result);
db.SaveChanges();
}
}
List <tblQuestionnaireFieldLogicResult> carrerlist = db.tblQuestionnaireFieldLogicResults.Where(x => x.UserName == UserName).OrderByDescending(x => x.Result).ToList();
ViewBag.CarrerList = carrerlist;
List <SubStrengthValue> list1 = new List <SubStrengthValue>();
SubStrengthValue Artistic1 = new SubStrengthValue();
Artistic1.Name = 1;
Artistic1.Value = temp.Artistic;
list1.Add(Artistic1);
SubStrengthValue Aesthetic1 = new SubStrengthValue();
Aesthetic1.Name = 2;
Aesthetic1.Value = temp.Aesthetic;
list1.Add(Aesthetic1);
SubStrengthValue Idea_Generator1 = new SubStrengthValue();
Idea_Generator1.Name = 3;
Idea_Generator1.Value = temp.Idea_Generator;
list1.Add(Idea_Generator1);
SubStrengthValue Team_Player1 = new SubStrengthValue();
Team_Player1.Name = 4;
Team_Player1.Value = temp.Team_Player;
list1.Add(Team_Player1);
SubStrengthValue Independent1 = new SubStrengthValue();
Independent1.Name = 5;
Independent1.Value = temp.Independent;
list1.Add(Independent1);
SubStrengthValue Mentor1 = new SubStrengthValue();
Mentor1.Name = 6;
Mentor1.Value = temp.Mentor;
list1.Add(Mentor1);
SubStrengthValue Analytics1 = new SubStrengthValue();
Analytics1.Name = 7;
Analytics1.Value = temp.Analytics;
list1.Add(Analytics1);
SubStrengthValue Social_Philosophical1 = new SubStrengthValue();
Social_Philosophical1.Name = 8;
Social_Philosophical1.Value = temp.Social_Philosophical;
list1.Add(Social_Philosophical1);
SubStrengthValue Practical1 = new SubStrengthValue();
Practical1.Name = 9;
Practical1.Value = temp.Practical;
list1.Add(Practical1);
list1 = list1.OrderByDescending(x => x.Value).ToList();
List <SubStrengthDescription> listdesc = new List <SubStrengthDescription>();
var t = list1.Take(3);
foreach (var temmp in t)
{
SubStrengthDescription sub = new SubStrengthDescription();
sub.Name = temmp.Name;
sub.Value = db.tblQuestionnaireSubStrengths.Where(x => x.Id == temmp.Name).Select(x => x.Description).FirstOrDefault();
listdesc.Add(sub);
}
ViewBag.Description = listdesc;
return(View());
}
}
else
{
return(RedirectToAction("Login", "LoginQuestionnaire"));
}
}
