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"));
}
