public ActionResult getdata() { try { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { var listvalue = (from q in entities.questiontbls select q).ToList(); List <Questionmodel> questions = new List <Questionmodel>(); foreach (var item in listvalue) { Questionmodel question = new Questionmodel(); question.q_id = item.q_id; question.questions = item.question; questions.Add(question); } // List<questiontbl> listvalue = entities.questiontbls.ToList<questiontbl>(); return(Json(new { data = questions }, JsonRequestBehavior.AllowGet)); } }catch (Exception ex) { throw; } }
public ActionResult Index(FormCollection form) { //int va = valueid; using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { string[] questions = Request.Form.GetValues("questionid"); int userid = Convert.ToInt32(Session["isuserId"]); int roleno = Convert.ToInt32(Session["RoleID"]); //List<Submitsurvey> submitsurveys = new List<Submitsurvey>(); foreach (var question in questions) { String rat = Request.Form.Get("rank+" + question); String comment = Request.Form.Get("comment+" + question); String surveryid = Request.Form.Get("surveryid+" + question); Submitsurvey submitsurvey = new Submitsurvey(); submitsurvey.rating = Convert.ToInt32(rat); submitsurvey.comment = comment; submitsurvey.sur_id = Convert.ToInt32(surveryid); submitsurvey.u_id = userid; submitsurvey.role_id = roleno; submitsurvey.sq_id = Convert.ToInt32(question); entities.Submitsurveys.Add(submitsurvey); entities.SaveChanges(); } } // string[] value = Request.Form.GetValues("Country"); return(RedirectToAction("Index", "Rating")); }
public UserDisplayViewModel isdetail(int isuservalue) { // int isuservalue = isUserAvailable(Objlogin); // List<UserDisplayViewModel> UD = new List<UserDisplayViewModel>(); UserDisplayViewModel userdep = new UserDisplayViewModel(); try { using (var entity = new HapinessSurveyEntities()) { var UDlist = (from u in entity.UserTbls join d in entity.departmenttbls on u.Dep_id equals d.dep_id where u.user_id == isuservalue select new { u.user_name, d.dep_name }).ToList(); foreach (var listud in UDlist) { userdep.user_name = listud.user_name; userdep.dep_name = listud.dep_name; //UD.Add(userdep); } } } catch (Exception ex) { } return(userdep); }
public int isUserAvailable(Loginmodel Objlogin) { //user avaliable return user id // bool isusermatch = false; try { using (var entity = new HapinessSurveyEntities()) { // var obj = from u in entity.UserTbls where u.user_mail = Objlogin.user_mail && u.user_Pass = Objlogin.user_pass select u. var obj = entity.UserTbls.Where(a => a.user_mail.Equals(Objlogin.user_mail) && a.user_Pass.Equals(Objlogin.user_pass)).FirstOrDefault(); if (obj != null) { isuservalue = obj.user_id; // isusermatch = true; } else { isuservalue = 0; // isusermatch = false; } } } catch (Exception ex) { } // return isusermatch; return(isuservalue); }
public static List <SelectListItem> getusers(int dep_id) { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { List <SelectListItem> userlist = (from u in entities.UserTbls join d in entities.departmenttbls.AsEnumerable() on u.Dep_id equals d.dep_id select new SelectListItem { Text = u.user_name, Value = u.user_id.ToString() }).ToList(); userlist.Insert(0, new SelectListItem { Text = "--Select User--", Value = "0" }); return(userlist); } }
// GET: Rating public ActionResult Index() { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { if (Session["RoleID"] == null) { return(RedirectToAction("Login", "Home")); } int id = Convert.ToInt32(Session["isuserId"]); //select sq.sq_id,q.question,us.sur_id from questiontbl as q // inner join surveyquestion as sq on sq.q_id = q.q_id // full join userSurvey as us on sq.sur_id = us.sur_id // where us.user_id = 7 var list = (from q in entities.questiontbls join qs in entities.surveyquestions on q.q_id equals qs.q_id join us in entities.userSurveys on qs.sur_id equals us.sur_id where us.user_id == id select new { qs.sq_id, q.question, q.q_id, us.sur_id }).ToList(); List <Ratingmodel> questionmodelList = new List <Ratingmodel>(); foreach (var l in list) { Ratingmodel questionmodel = new Ratingmodel(); questionmodel.sur_id = l.sur_id; questionmodel.sq_id = l.sq_id; questionmodel.ques = l.question; questionmodelList.Add(questionmodel); } return(View(questionmodelList)); // return View(); } }
public ActionResult ForgetPass(FormCollection form) { using (HapinessSurveyEntities db = new HapinessSurveyEntities()) { try { string ml = Request.Form["EmailID"].ToString(); var pas = (from m in db.UserTbls where m.user_mail == ml select m.user_Pass).FirstOrDefault(); EmailOperation.SendEmail(ml, "Forget Password", "Happiness Password is = " + pas); ViewBag.messge = "mail sended"; } catch (Exception ex) { return(View("ForgetPass")); } return(View("Login")); } }
private static List <SelectListItem> Getproject() { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { List <SelectListItem> projectList = (from p in entities.projecttbls.AsEnumerable() select new SelectListItem { Text = p.pro_name.ToString(), Value = p.pro_id.ToString() }).ToList(); //Add Default Item at First Position. projectList.Insert(0, new SelectListItem { Text = "--Select Project--", Value = "0" }); return(projectList); } }
private static List <SelectListItem> Getrole() { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { List <SelectListItem> roleList = (from p in entities.roletbls.AsEnumerable().Where(p => p.role_id > 3) select new SelectListItem { Text = p.role_name.ToString(), Value = p.role_id.ToString() }).ToList(); //Add Default Item at First Position. roleList.Insert(0, new SelectListItem { Text = "--Select Role--", Value = "0" }); return(roleList); } }
public ActionResult Edit(Questionmodel questionmodel) { try { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { var modiques = entities.questiontbls.Where(a => a.q_id.Equals(questionmodel.q_id)).First(); // questionmodel.q_id = modiques.q_id; // List < Questionmodel > qlist = new List<Questionmodel>(); modiques.question = questionmodel.questions; entities.SaveChanges(); return(View("question")); } } catch (Exception) { throw; } //eturn View("Edit", questionmodel); }
public ActionResult Edit(int?ID) { try { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { Questionmodel questionmodel = new Questionmodel(); List <Questionmodel> qlist = new List <Questionmodel>(); var question = (from q in entities.questiontbls where q.q_id == ID select q).FirstOrDefault(); questionmodel.q_id = question.q_id; questionmodel.questions = question.question; return(View("Edit", questionmodel)); } } catch (Exception) { throw; } }
public ActionResult Create(Questionmodel questionmodel) { try { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { //var addques = entities.questiontbls.Where(a => a.q_id.Equals(questionmodel.q_id)).First(); questiontbl ques = new questiontbl(); // List < Questionmodel > qlist = new List<Questionmodel>(); ques.question = questionmodel.questions; entities.questiontbls.Add(ques); entities.SaveChanges(); return(View("question")); } } catch (Exception) { throw; } // return View("Edit"); }
public JsonResult delete(int?id) { try { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { if (id == null) { return(Json(new { data = "Not Deleted" }, JsonRequestBehavior.AllowGet)); } var deleteques = entities.questiontbls.Find(id); entities.questiontbls.Remove(deleteques); entities.SaveChanges(); return(Json(new { data = "Delete" }, JsonRequestBehavior.AllowGet)); } } catch (Exception) { throw; } }
// GET: Survey public ActionResult Index() { using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { if (Session["RoleID"] == null) { RedirectToAction("Login", "Home"); } int rid = Convert.ToInt32(Session["RoleID"]); if (rid == 4) { } if (rid == 5) { } if (rid == 6) { } } return(View()); }
// GET: GenerateSurvey public ActionResult Index() { if (Session["RoleID"] == null) { return(RedirectToAction("Login", "Home")); } List <SelectListItem> items = new List <SelectListItem>(); using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { //var depdata = new SelectList(entities.departmenttbls.ToList(),"dep_id","dep_name").to; //List < SelectListItem > departmentlist = Getdepartment(); // ViewData["Department"] = departmentlist; // var prodata = new SelectList(entities.projecttbls.ToList(), "pro_id", "pro_name"); List <SelectListItem> projectlist = Getproject(); ViewData["Project"] = projectlist; // var roledata = new SelectList(entities.roletbls.ToList(), "role_id", "role_name"); List <SelectListItem> rolelist = Getrole(); ViewData["Role"] = rolelist; var qlist = from q in entities.questiontbls select new { q.q_id, q.question }; foreach (var v in qlist) { items.Add(new SelectListItem { Value = v.q_id.ToString(), Text = v.question.ToString() }); } } return(View("Questionlist", items)); }
public int isUserRoleID(Loginmodel Objlogin) { //get Roll iD for controller dashboard var role = 0; var roleid = 0; try { using (var entity = new HapinessSurveyEntities()) { teamtbl teamobj = new teamtbl(); role = (int)entity.teamtbls.Where(a => a.user_id.Equals(isuservalue)).LongCount(); if (role == 1) { roleid = entity.teamtbls.Where(a => a.user_id.Equals(isuservalue)).Select(a => a.role_id).FirstOrDefault(); //if assign any one role. } else if (role == 0) { roleid = role; //if not assign any role } else if (role == 2) { //if teamlead and teammember role // var roleid1 = entity.teamtbls.Where(a => a.user_id.Equals(isuservalue)).Select(a => a.role_id).ToList(); // roleid = roleid1.Min(); roleid = 6; // roleid = entity.teamtbls.Where(a => a.user_id.Equals(isuservalue)).Select(a => a.role_id).Min(); } } } catch (Exception ex) { } return(roleid); }
public ActionResult Index(List <SelectListItem> items, FormCollection form) { // string ddldep =Request.Form["Departmentddl"].ToString(); string ddlproj = Request.Form["Projectddl"].ToString(); string ddlrole = Request.Form["Roleddl"].ToString(); using (HapinessSurveyEntities entities = new HapinessSurveyEntities()) { int id, ids; var surveyCre = new surveytbl(); { surveyCre.role_id = Convert.ToInt32(ddlrole); surveyCre.Start_date = DateTime.Today; surveyCre.End_date = DateTime.Today.Date.AddDays(3); surveyCre.proj_id = Convert.ToInt32(ddlproj); surveyCre.Dep_id = 0; entities.surveytbls.Add(surveyCre); entities.SaveChanges(); ids = surveyCre.sur_id; entities.SaveChanges(); } // ViewBag.Message = "Selected Items:\\n"; foreach (SelectListItem item in items) { if (item.Selected) { try { //surveyCre.role_id = 1; //surveyCre.Start_date = DateTime.Today.Date; //surveyCre.End_date = DateTime.Today.Date.AddDays(3); //surveyCre.proj_id = 1; //surveyCre.Dep_id = 1; //entities.surveytbls.Add(surveyCre); //entities.SaveChanges(); //ids = surveyCre.sur_id; if (ids != 0) { surveyquestion surveyq = new surveyquestion(); { // var surcreid = (from q in entities.surveytbls select q.sur_id).FirstOrDefault(); surveyq.sur_id = ids; surveyq.q_id = Convert.ToInt32(item.Value); entities.surveyquestions.Add(surveyq); entities.SaveChanges(); // id = surveyq.sq_id; } } } catch (Exception ex) { } // ViewBag.Message += string.Format("{0}\\n", item.Text); } else { ViewBag.Message = "Select Question"; } } int pid = Convert.ToInt32(ddlproj); int rid = Convert.ToInt32(ddlrole); if (rid != 0) { var listusers = (from t in entities.teamtbls where t.pro_id == pid && t.role_id == rid select new { t.user_id }).ToList(); userSurvey surveyusers = new userSurvey(); foreach (var l in listusers) { surveyusers.user_id = l.user_id; surveyusers.sur_id = ids; surveyusers.Active = true; entities.userSurveys.Add(surveyusers); entities.SaveChanges(); } } else { var listusers = (from t in entities.teamtbls where t.pro_id == pid select new { t.user_id }).ToList(); userSurvey surveyusers = new userSurvey(); foreach (var l in listusers) { surveyusers.user_id = l.user_id; surveyusers.sur_id = ids; surveyusers.Active = true; entities.userSurveys.Add(surveyusers); entities.SaveChanges(); } } } return(RedirectToAction("Dashboard", "Home")); }