public List <surveyquestion> GetQuestionsforReports() { using (var context = new MSSContext()) { var surveyQuestions = from aSurveyQuestion in context.surveyquestions where aSurveyQuestion.activeyn == true && aSurveyQuestion.surveyquestionid != 9 select aSurveyQuestion; List <surveyquestion> surveyQuestionsList = new List <surveyquestion>(); foreach (surveyquestion surveyquestion in surveyQuestions) { surveyquestion temp = new surveyquestion(); switch (surveyquestion.surveyquestionid) { case 1: temp.question = "Q1A: " + surveyquestion.question; break; case 2: temp.question = "Q1B: " + surveyquestion.question; break; case 3: temp.question = "Q1C: " + surveyquestion.question; break; case 4: temp.question = "Q1D: " + surveyquestion.question; break; case 5: temp.question = "Q1E: " + surveyquestion.question; break; case 6: temp.question = "Q2: " + surveyquestion.question; break; case 7: temp.question = "Q3: " + surveyquestion.question.Split('(')[0]; break; case 8: temp.question = "Q4: " + surveyquestion.question; break; default: break; } temp.surveyquestionid = surveyquestion.surveyquestionid; temp.questiontype = surveyquestion.questiontype; temp.activeyn = surveyquestion.activeyn; surveyQuestionsList.Add(temp); } return(surveyQuestionsList); } }
public void DeactivateSurveyQuestion(surveyquestion deactivatedSurveyQuestion) { using (var context = new MSSContext()) { var surveyQuestion = context.respondenttypes.Find(deactivatedSurveyQuestion.surveyquestionid); surveyQuestion.activeyn = false; var existingRespondentType = context.Entry(surveyQuestion); existingRespondentType.State = EntityState.Modified; context.SaveChanges(); } }
public void AddSurveyQuestion(surveyquestion tempSurveyQuestion) { using (var context = new MSSContext()) { surveyquestion newSurveyQuestion = new surveyquestion(); newSurveyQuestion.question = tempSurveyQuestion.question; newSurveyQuestion.questiontype = tempSurveyQuestion.questiontype; newSurveyQuestion.activeyn = true; context.surveyquestions.Add(newSurveyQuestion); context.SaveChanges(); } }
public void UpdateSurveyQuestion(surveyquestion updatedSurveyQuestion) { using (var context = new MSSContext()) { var surveyQuestion = context.surveyquestions.Find(updatedSurveyQuestion.surveyquestionid); surveyQuestion.question = updatedSurveyQuestion.question; surveyQuestion.questiontype = updatedSurveyQuestion.questiontype; var existingSurveyQuestion = context.Entry(surveyQuestion); existingSurveyQuestion.State = EntityState.Modified; context.SaveChanges(); } }
public List <surveyquestion> GetSurveyQuestions() { using (var context = new MSSContext()) { var surveyQuestions = from aSurveyQuestion in context.surveyquestions select aSurveyQuestion; List <surveyquestion> surveyQuestionsList = new List <surveyquestion>(); foreach (surveyquestion surveyquestion in surveyQuestions) { surveyquestion temp = new surveyquestion(); temp.question = surveyquestion.question; temp.questiontype = surveyquestion.questiontype; temp.activeyn = surveyquestion.activeyn; surveyQuestionsList.Add(temp); } return(surveyQuestionsList); } }
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")); }