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