public QuestionnaireViewModel(Models.Questionnaire questionnaire) { _questionnaire = questionnaire; _context = new Models.pyrenactionEntities(); checkedFalse = false; }
protected void SubmitBtn_Click(object sender, ImageClickEventArgs e) { try { var quesModel = new Models.Questionnaire(); Int32 total = 0; quesModel.QuestionnaireId = Guid.NewGuid(); quesModel.AppraiserId = Profile.CurrentUser.UserId; quesModel.AppraiserTime = DateTime.Now; quesModel.CourseDevelop = Convert.ToInt32(radCourseDevelop.SelectedValue); total += (int)quesModel.CourseDevelop; quesModel.CourseId = this.courseId; quesModel.CourseKey = Convert.ToInt32(radCourseKey.SelectedValue); total += (int)quesModel.CourseKey; quesModel.CoursePractical = Convert.ToInt32(radCoursePractical.SelectedValue); total += (int)quesModel.CoursePractical; quesModel.CourseRich = Convert.ToInt32(radContentRich.SelectedValue); total += (int)quesModel.CourseRich; quesModel.CourseSubject = Convert.ToInt32(radSubject.SelectedValue); total += (int)quesModel.CourseSubject; quesModel.OrgArrange = Convert.ToInt32(radOrgArrange.SelectedValue); total += (int)quesModel.OrgArrange; quesModel.OrgService = Convert.ToInt32(radOrgService.SelectedValue); total += (int)quesModel.OrgService; quesModel.OrgTime = Convert.ToInt32(radOrgTime.SelectedValue); total += (int)quesModel.OrgTime; quesModel.TeacherBearing = Convert.ToInt32(radTeacherBearing.SelectedValue); total += (int)quesModel.TeacherBearing; quesModel.TeacherCommunication = Convert.ToInt32(radTeacherCommunication.SelectedValue); total += (int)quesModel.TeacherCommunication; quesModel.TeacherLanguage = Convert.ToInt32(radTeacherLanguage.SelectedValue); total += (int)quesModel.TeacherLanguage; quesModel.TeacherPrepare = Convert.ToInt32(radTeacherPrepare.SelectedValue); total += (int)quesModel.TeacherPrepare; quesModel.TeacherStyle = Convert.ToInt32(radTeacherStyle.SelectedValue); total += (int)quesModel.TeacherStyle; quesModel.TotalEvaluation = Convert.ToInt32(radAll.SelectedValue); // total += (int)quesModel.TotalEvaluation; quesModel.Suggest = txtSuggest.InnerText.Trim(); quesModel.Total = total; var queBll = new BLL.Questionnaire(); if (queBll.Add(quesModel)) { queBll.SubmitQuestionnaireState(Profile.CurrentUser.UserId, courseId); } Response.Redirect("MyQuestionnaire.aspx"); } catch (Exception ex) { Utility.LogHelper.WriteLogofExceptioin(ex); } }
public ActionResult Questionnaire(Models.Questionnaire q) { if (ModelState.IsValid) { System.Data.SqlClient.SqlConnection sqlConnection1 = new System.Data.SqlClient.SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename" + @"='C:\Users\sue\Documents\Visual Studio 2013\Projects\IntakeQuestionnaire\IntakeQuestionnaire\App_Data\Questionnaire.mdf';Integrated Security=True"); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "INSERT INTO [dbo].[QuestionnairePage1] ([ApplicationRefNumber] , [familyCode] , [DateFileOpened] , [No] , [Interpreter] , [Surname] , [FirstName] , [Initials] , [CommunityName] , [YorN] , [ContactNumber] , [ContactName], [Address] , [Flag] , [WhosContactNum], [HowLongClientBeenAtAdressFor] , [DOB] , [Country] , [Gender] , [MaritalStatus] , [EthnicGroup] , [Religion] , [HomeLang] , [ArrivalDate] , [typeOfApplicatn] , [DHAref] , [firstInterview] , [refugeeSTAT] , [UNCTD] , [ArrivalDateDurban] , [dateGranted] , [whenStatusExpire] , [firstInterviewDate] , [secondInterviewDate] , [englishAbility], [attendingEnglishClasses],[whereAndHow] , [sharingAccomodation], [fullNamesOfSharers])VALUES ('" + q.ApplicationRefNumber + "','" + q.familyCode + "','" + q.DateFileOpened + "','" + q.No + "','" + q.Interpreter + "','" + q.Surname + "','" + q.FirstName + "','" + q.Initials + "','" + q.CommunityName + "','" + q.YorN + "','" + q.ContactNumber + "','" + q.ContactName + "','" + q.Address + "','" + q.Flag + "','" + q.WhosContactNum + "','" + q.HowLongClientBeenAtAdressFor + "','" + q.DOB + "','" + q.Country + "','" + q.Gender + "','" + q.MaritalStatus + "','" + q.EthnicGroup + "','" + q.Religion + "','" + q.HomeLang + "','" + q.ArrivalDate + "','" + q.typeOfApplicatn + "','" + q.DHAref + "','" + q.firstInterview + "','" + q.refugeeSTAT + "','" + q.UNCTD + "','" + q.ArrivalDateDurban + "','" + q.dateGranted + "','" + q.whenStatusExpire + "','" + q.firstInterviewDate + "','" + q.secondInterviewDate + "','" + q.englishAbility + "','" + q.attendingEnglishClasses + "','" + q.whereAndHow + "','" + q.sharingAccomodation + "','" + q.fullNamesOfSharers + "')"; cmd.Connection = sqlConnection1; sqlConnection1.Open(); cmd.ExecuteNonQuery(); sqlConnection1.Close(); return(RedirectToAction("QuestionnairePageTwo")); } else { ModelState.AddModelError("", "Something didnt go right with adding the information to our databases"); } return(View(q)); }
//Chargement des Combobox private void loadFields() { _ListeImportances = new ObservableCollection <Models.Importance>(); var query = from U in _context.Importances select U; List <Models.Importance> listeImportances = query.ToList(); foreach (Models.Importance imp in listeImportances) { _ListeImportances.Add(imp); } //définition de la collection view _importanceCollectionView = CollectionViewSource.GetDefaultView(_ListeImportances); if (_importanceCollectionView == null) { throw new NullReferenceException("_importanceCollectionView"); } //ajout de l'événement à déclencher quand la vue courante change _importanceCollectionView.CurrentChanged += OnCollectionViewImportanceCurrentChanged; //Si on est sur une action existante à modifier, on selectionne l'item correspondant if (_action.Importance != null) { Models.Importance imp = _action.Importance; _importanceCollectionView.MoveCurrentTo(imp); NotifyPropertyChanged("Importances"); } _ListeFamilles = new ObservableCollection <Models.Famille>(); var queryFam = from U in _context.Familles select U; List <Models.Famille> listeFamilles = queryFam.ToList(); foreach (Models.Famille fam in listeFamilles) { _ListeFamilles.Add(fam); } //définition de la collection view _familleCollectionView = CollectionViewSource.GetDefaultView(_ListeFamilles); if (_familleCollectionView == null) { throw new NullReferenceException("_familleCollectionView"); } //ajout de l'événement à déclencher quand la vue courante change _familleCollectionView.CurrentChanged += OnCollectionViewFamilleCurrentChanged; //Si on est sur une action existante à modifier, on selectionne l'item correspondant if (_action.Famille != null) { Models.Famille fam = _action.Famille; _familleCollectionView.MoveCurrentTo(fam); NotifyPropertyChanged("Familles"); } _ListeSites = new ObservableCollection <Models.Site>(); var querySite = from U in _context.Sites select U; List <Models.Site> listeSites = querySite.ToList(); foreach (Models.Site site in listeSites) { _ListeSites.Add(site); } //définition de la collection view _siteCollectionView = CollectionViewSource.GetDefaultView(_ListeSites); if (_siteCollectionView == null) { throw new NullReferenceException("_siteCollectionView"); } //ajout de l'événement à déclencher quand la vue courante change _siteCollectionView.CurrentChanged += OnCollectionViewSiteCurrentChanged; //Si on est sur une action existante à modifier, on selectionne l'item correspondant if (_action.Site != null) { Models.Site site = _action.Site; _siteCollectionView.MoveCurrentTo(site); NotifyPropertyChanged("Sites"); } _ListeQuestionnaires = new ObservableCollection <Models.Questionnaire>(); var queryQuest = from U in _context.Questionnaires select U; List <Models.Questionnaire> listeQuestionnaires = queryQuest.ToList(); foreach (Models.Questionnaire quest in listeQuestionnaires) { _ListeQuestionnaires.Add(quest); } //définition de la collection view _questionnaireCollectionView = CollectionViewSource.GetDefaultView(_ListeQuestionnaires); if (_questionnaireCollectionView == null) { throw new NullReferenceException("_questionnaireCollectionView"); } //ajout de l'événement à déclencher quand la vue courante change _questionnaireCollectionView.CurrentChanged += OnCollectionViewQuestionnaireCurrentChanged; //Si on est sur une action existante à modifier, on selectionne l'item correspondant if (_action.Questionnaire != null) { Models.Questionnaire quest = _action.Questionnaire; _questionnaireCollectionView.MoveCurrentTo(quest); NotifyPropertyChanged("Questionnaires"); } _ListeActions = new ObservableCollection <Models.Action>(); var queryAct = from U in _context.Actions select U; List <Models.Action> listeActions = queryAct.ToList(); foreach (Models.Action act in listeActions) { _ListeActions.Add(act); } Models.Action actNull = new Models.Action(); //ajout d'une action vide pour que l'utilisateur puisse séléctionner "Aucune" action associée. actNull.description = "Aucune"; _ListeActions.Add(actNull); //définition de la collection view _actionCollectionView = CollectionViewSource.GetDefaultView(_ListeActions); if (_actionCollectionView == null) { throw new NullReferenceException("_actionCollectionView"); } //ajout de l'événement à déclencher quand la vue courante change _actionCollectionView.CurrentChanged += OnCollectionViewActionCurrentChanged; //Si on est sur une action existante à modifier, on selectionne l'item correspondant if (_action.Action2 != null) { Models.Action act = _action.Action2; _actionCollectionView.MoveCurrentTo(act); NotifyPropertyChanged("Actions"); } else { _actionCollectionView.MoveCurrentTo(actNull); NotifyPropertyChanged("Actions"); } _ListeUtilisateurs1 = new ObservableCollection <Models.Utilisateur>(); var queryUt1 = from U in _context.Utilisateurs select U; List <Models.Utilisateur> listeUt1 = queryUt1.ToList(); foreach (Models.Utilisateur ut in listeUt1) { _ListeUtilisateurs1.Add(ut); } //définition de la collection view _utilisateurCollectionView1 = CollectionViewSource.GetDefaultView(_ListeUtilisateurs1); if (_utilisateurCollectionView1 == null) { throw new NullReferenceException("_utilisateurCollectionView1"); } //ajout de l'événement à déclencher quand la vue courante change _utilisateurCollectionView1.CurrentChanged += OnCollectionViewResp1CurrentChanged; //Si on est sur une action existante à modifier, on selectionne l'item correspondant if (_action.Utilisateur != null) { Models.Utilisateur ut1 = _action.Utilisateur; _utilisateurCollectionView1.MoveCurrentTo(ut1); NotifyPropertyChanged("Resp1"); } _ListeUtilisateurs2 = new ObservableCollection <Models.Utilisateur>(); var queryUt2 = from U in _context.Utilisateurs select U; List <Models.Utilisateur> listeUt2 = queryUt2.ToList(); foreach (Models.Utilisateur ut in listeUt2) { _ListeUtilisateurs2.Add(ut); } //définition de la collection view _utilisateurCollectionView2 = CollectionViewSource.GetDefaultView(_ListeUtilisateurs2); if (_utilisateurCollectionView2 == null) { throw new NullReferenceException("_utilisateurCollectionView2"); } //ajout de l'événement à déclencher quand la vue courante change _utilisateurCollectionView2.CurrentChanged += OnCollectionViewResp2CurrentChanged; //Si on est sur une action existante à modifier, on selectionne l'item correspondant if (_action.Utilisateur1 != null) { Models.Utilisateur ut2 = _action.Utilisateur1; _utilisateurCollectionView2.MoveCurrentTo(ut2); NotifyPropertyChanged("Resp2"); } _ListeTaches = new ObservableCollection <Models.Tache>(); var queryTach = from U in _context.Taches select U; List <Models.Tache> listeTach = queryTach.ToList(); //Si on est sur une action existante à modifier, on selectionne l'item correspondant foreach (Models.Tache t in listeTach) { if (t.id_Action == _action.id) { _ListeTaches.Add(t); } } //définition de la collection view _tacheCollectionView = CollectionViewSource.GetDefaultView(_ListeTaches); if (_tacheCollectionView == null) { throw new NullReferenceException("_tacheCollectionView"); } //ajout de l'événement à déclencher quand la vue courante change _tacheCollectionView.CurrentChanged += OnCollectionViewTacheCurrentChanged; _ListeLiens = new ObservableCollection <Models.Lien>(); var queryLiens = from U in _context.Liens select U; List <Models.Lien> listeLiens = queryLiens.ToList(); //Si on est sur une action existante à modifier, on selectionne l'item correspondant foreach (Models.Lien l in listeLiens) { if (l.id_Action == _action.id) { _ListeLiens.Add(l); } } //définition de la collection view _lienCollectionView = CollectionViewSource.GetDefaultView(_ListeLiens); if (_lienCollectionView == null) { throw new NullReferenceException("_lienCollectionView"); } //ajout de l'événement à déclencher quand la vue courante change _lienCollectionView.CurrentChanged += OnCollectionViewLienCurrentChanged; }
public ActionResult QuestionnairePageSix(Models.Questionnaire q) { String[] list = new String[8]; String ig1 = Request.Form["inputGrid1"]; if (ig1 != "") { list = new String[] { Request.Form["inputGrid1"], Request.Form["inputGrid2"], Request.Form["inputGrid3"], Request.Form["inputGrid4"], Request.Form["inputGrid5"], Request.Form["inputGrid6"] }; insertDataPage6(list); } String ig1a = Request.Form["inputGrid1a"]; if (ig1a != "") { list = new String[] { Request.Form["inputGrid1a"], Request.Form["inputGrid2a"], Request.Form["inputGrid3a"], Request.Form["inputGrid4a"], Request.Form["inputGrid5a"], Request.Form["inputGrid6a"] }; insertDataPage6(list); } String ig1b = Request.Form["inputGrid1b"]; if (ig1b != "") { list = new String[] { Request.Form["inputGrid1b"], Request.Form["inputGrid2b"], Request.Form["inputGrid3b"], Request.Form["inputGrid4b"], Request.Form["inputGrid5b"], Request.Form["inputGrid6b"] }; insertDataPage6(list); } String ig1c = Request.Form["inputGrid1c"]; if (ig1c != "") { list = new String[] { Request.Form["inputGrid1c"], Request.Form["inputGrid2c"], Request.Form["inputGrid3c"], Request.Form["inputGrid4c"], Request.Form["inputGrid5c"], Request.Form["inputGrid6c"] }; insertDataPage6(list); } String ig1d = Request.Form["inputGrid1d"]; if (ig1d != "") { list = new String[] { Request.Form["inputGrid1d"], Request.Form["inputGrid2d"], Request.Form["inputGrid3d"], Request.Form["inputGrid4d"], Request.Form["inputGrid5d"], Request.Form["inputGrid6d"] }; insertDataPage6(list); } String ig1e = Request.Form["inputGrid1e"]; if (ig1e != "") { list = new String[] { Request.Form["inputGrid1e"], Request.Form["inputGrid2e"], Request.Form["inputGrid3e"], Request.Form["inputGrid4e"], Request.Form["inputGrid5e"], Request.Form["inputGrid6e"] }; insertDataPage6(list); } String[] newLineArray = new String[8]; String newLine = Request.Form["links7"]; if (newLine != "") { newLineArray = new String[] { Request.Form["links7"], Request.Form["keywords7"], Request.Form["violationtype7"], Request.Form["endD7"], Request.Form["details7"], Request.Form["amounts7"] }; insertDataPage6(newLineArray); } String newLine2 = Request.Form["links8"]; if (newLine2 != "") { newLineArray = new String[] { Request.Form["links8"], Request.Form["keywords8"], Request.Form["violationtype8"], Request.Form["endD8"], Request.Form["details8"], Request.Form["amounts8"] }; insertDataPage6(newLineArray); } String newLine3 = Request.Form["links9"]; if (newLine3 != "") { newLineArray = new String[] { Request.Form["links9"], Request.Form["keywords9"], Request.Form["violationtype9"], Request.Form["endD9"], Request.Form["details9"], Request.Form["amounts9"] }; insertDataPage6(newLineArray); } return(RedirectToAction("QuestionnaireFinish")); }