public ActionResult CareerData(int id)
{
if (Request.IsAuthenticated)
{
string UserName = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
tblQuestionnaireLogin temp = db.tblQuestionnaireLogins.Where(x => x.UserName == UserName).FirstOrDefault();
if (temp.IsAdmin != "1")
{
FormsAuthentication.SignOut();
Session.Abandon();
return(RedirectToAction("Login", "LoginQuestionnaire"));
}
ViewBag.CareerFields = db.tblQuestionnaireFieldLogics.Where(x => x.Id == id).FirstOrDefault();
ViewBag.Description = db.tblQuestionnaireCareerDescriptions.Where(x => x.Id == id).FirstOrDefault();
ViewBag.CourseWork = db.tblQuestionnaireCourseWorks.Where(x => x.Id == id).FirstOrDefault();
ViewBag.Videos = db.tblQuestionnaireVideos.Where(x => x.CareerId == id).ToList();
ViewBag.Reading = db.tblQuestionnaireReadings.Where(x => x.CareerId == id).ToList();
ViewBag.OnlineCourses = db.tblQuestionnaireOnlineCourses.Where(x => x.CareerId == id).ToList();
return(View());
}
else
{
return(RedirectToAction("Login", "LoginQuestionnaire"));
}
}
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 Login([Bind(Include = "UserName,Password")] Login tblQuesrionnaireLogin)
{
tblQuestionnaireLogin temp = db.tblQuestionnaireLogins.Where(x => x.UserName == tblQuesrionnaireLogin.UserName && x.Password == tblQuesrionnaireLogin.Password).FirstOrDefault();
if (temp == null)
{
return(Json(new { Status = false }));
}
else
{
tblQuestionnaireStudentRegister regis = db.tblQuestionnaireStudentRegisters.Where(x => x.Email == tblQuesrionnaireLogin.UserName).FirstOrDefault();
FormsAuthentication.SetAuthCookie(tblQuesrionnaireLogin.UserName.Trim(), false);
return(Json(new { Status = true, IsAdmin = temp.IsAdmin }));
}
}
public JsonResult Register([Bind(Include = "Id,Name,Email,Age,Gender,Mobile,Address")] Register register)
{
if (ModelState.IsValid)
{
tblQuestionnaireStudentRegister tblQuestionnaireStudentRegister = new tblQuestionnaireStudentRegister();
tblQuestionnaireStudentRegister.Name = register.Name;
tblQuestionnaireStudentRegister.Email = register.Email;
tblQuestionnaireStudentRegister.Age = register.Age;
tblQuestionnaireStudentRegister.Gender = register.Gender;
tblQuestionnaireStudentRegister.Mobile = register.Mobile;
tblQuestionnaireStudentRegister.Address = register.Address;
tblQuestionnaireStudentRegister.IsActive = "1";
bool status = CheckEmail(tblQuestionnaireStudentRegister);
if (status == true)
{
return(Json(new { Status = false, Error = "Email Already Exists." }));
}
else
{
db.tblQuestionnaireStudentRegisters.Add(tblQuestionnaireStudentRegister);
tblQuestionnaireLogin tblQuesrionnaireLogin = new tblQuestionnaireLogin();
tblQuesrionnaireLogin.UserName = tblQuestionnaireStudentRegister.Email;
tblQuesrionnaireLogin.Password = Membership.GeneratePassword(12, 2);
tblQuesrionnaireLogin.IsAdmin = "0";
db.tblQuestionnaireLogins.Add(tblQuesrionnaireLogin);
db.SaveChanges();
BackgroundJob.Enqueue(() => SendMail(tblQuesrionnaireLogin.UserName, tblQuesrionnaireLogin.UserName, tblQuesrionnaireLogin.Password, tblQuestionnaireStudentRegister.Name));
return(Json(new { Status = true }));
}
}
else
{
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
return(Json(new { Status = false, Error = error.ErrorMessage }));
}
}
return(Json(new { Status = false }));
}
}
public JsonResult ForgotPassword(string Username)
{
tblQuestionnaireLogin tblQuesrionnaireLogin = db.tblQuestionnaireLogins.Where(x => x.UserName == Username).FirstOrDefault();
if (tblQuesrionnaireLogin != null)
{
tblQuestionnaireStudentRegister tblQuestionnaireStudentRegister = db.tblQuestionnaireStudentRegisters.Where(x => x.Email == Username).FirstOrDefault();
BackgroundJob.Enqueue(() => SendMail(tblQuesrionnaireLogin.UserName, tblQuesrionnaireLogin.UserName, tblQuesrionnaireLogin.Password, tblQuestionnaireStudentRegister.Name));
return(Json(new { Status = true }));
}
else
{
return(Json(new { Status = false }));
}
}
// GET: Admin
public ActionResult Career()
{
if (Request.IsAuthenticated)
{
string UserName = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
tblQuestionnaireLogin temp = db.tblQuestionnaireLogins.Where(x => x.UserName == UserName).FirstOrDefault();
if (temp.IsAdmin != "1")
{
FormsAuthentication.SignOut();
Session.Abandon();
return(RedirectToAction("Login", "LoginQuestionnaire"));
}
List <tblQuestionnaireFieldLogic> list = db.tblQuestionnaireFieldLogics.ToList();
return(View(list));
}
else
{
return(RedirectToAction("Login", "LoginQuestionnaire"));
}
}
// 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"));
}
}