Example #1
0
        public async Task <IActionResult> RevoteStatus_CodeBehind(LanguagePreference languagePreference)
        {
            if (HttpContext.Session.GetString("activeVoteContractAddress") == null)
            {
                if (languagePreference == LanguagePreference.Russian)
                {
                    return(await Task.Run <IActionResult>(() => { return RedirectToAction("Login_Russian"); }));
                }
                else
                {
                    return(await Task.Run <IActionResult>(() => { return RedirectToAction("Login"); }));
                }
            }

            string meetingId     = HttpContext.Session.GetString("activeVoteContractAddress");
            string controlNumber = HttpContext.Session.GetString("ControlNumber");

            var filter = Builders <VoteSubmission> .Filter.Eq("ControlNumber", controlNumber) & Builders <VoteSubmission> .Filter.Eq("MeetingId", meetingId) & Builders <VoteSubmission> .Filter.Eq("voteSubmissionStatus", VoteSubmissionStatus.VoteCoinsTransferred);

            var update = Builders <VoteSubmission> .Update.Set("voteSubmissionStatus", VoteSubmissionStatus.VoteCoinsTransferredPendingDelete);

            _context.votesubmission.UpdateOne(filter, update);

            //var filterSubmittedAddresses = Builders<BlockchainAddress>.Filter.Eq("meetingId", meetingId) & Builders<BlockchainAddress>.Filter.Eq("controlNumber", controlNumber);
            //Context.blockchainaddresses.DeleteMany(filterSubmittedAddresses);

            if (languagePreference == LanguagePreference.Russian)
            {
                return(await Task.Run <IActionResult>(() => { return RedirectToAction("Index_Russian"); }));
            }
            else
            {
                return(await Task.Run <IActionResult>(() => { return RedirectToAction("Index"); }));
            }
        }
        public IActionResult QuestionRealtime_Codebehind(string quidAndUserType, LanguagePreference languagePreference)
        {
            if (HttpContext.Session.GetString("ControlNumber") == null)
            {
                return(RedirectToAction("Login", "ShareholderVoting"));
            }

            var builder = new ConfigurationBuilder()
                          .SetBasePath(Directory.GetCurrentDirectory())
                          .AddJsonFile("appsettings.json");

            IConfigurationRoot Configuration = builder.Build();

            string quid     = quidAndUserType.Split('|')[0].ToString();
            string UserType = quidAndUserType.Split('|')[1].ToString();

            List <Question> questions  = _blockchainContext.questions;
            var             question   = questions.FirstOrDefault(q => q.quid == quid);
            QuestionVM      questionVM = new QuestionVM();

            questionVM.quid = quid;
            questionVM.text = question.text;
            questionVM.blockchainExplorerUrl = Configuration["blockchainExplorerUrl"].ToString();
            questionVM.smartContractAddress  = _blockchainContext.ContractAddress;

            ViewBag.UserType = UserType;

            return(View(questionVM));
        }
Example #3
0
 public CustomerPreference(
     LanguagePreference languagePreference,
     CarPreference carPreference)
 {
     CarPreference      = carPreference;
     LanguagePreference = languagePreference;
 }
        public async Task <IActionResult> IndexRealtime_Codebehind(string UserType, LanguagePreference languagePreference)
        {
            if (HttpContext.Session.GetString("ControlNumber") == null)
            {
                return(RedirectToAction("Login", "ShareholderVoting"));
            }


            var builder = new ConfigurationBuilder()
                          .SetBasePath(Directory.GetCurrentDirectory())
                          .AddJsonFile("appsettings.json");

            IConfigurationRoot Configuration = builder.Build();

            int refreshBlockchainDataInSeconds = Convert.ToInt32(Configuration["refreshBlockchainDataInSeconds"]);

            string contractNumber = _blockchainContext.ContractAddress;
            List <ContractBlockchainAddresses> contractBlockchainAddresses = Context.contractBlockchainAddresses.AsQueryable().ToList();

            MainVM viewModel = new MainVM();

            if (contractBlockchainAddresses.Any(bc => bc.contractNumber == contractNumber && Convert.ToDateTime(bc.lastModifiedDatetime).AddSeconds(refreshBlockchainDataInSeconds) > DateTime.Now))
            {
                viewModel.refreshDataFromBlockchain = "false";
            }
            else
            {
                viewModel.refreshDataFromBlockchain = "true";
            }

            viewModel.contractNumber = contractNumber;
            ViewBag.UserType         = UserType;

            return(await Task.Run <IActionResult>(() => { return View(viewModel); }));
        }
        public IActionResult Index_Codebehind(string UserType, LanguagePreference languagePreference)
        {
            if (HttpContext.Session.GetString("displayResultsContractAddress") == null)
            {
                if (languagePreference == LanguagePreference.Russian)
                {
                    if (UserType == "IVY")
                    {
                        return(RedirectToAction("Login_Russian", "InstitutionalVoting"));
                    }
                    else
                    {
                        return(RedirectToAction("Login_Russian", "ShareholderVoting"));
                    }
                }
                else
                {
                    if (UserType == "IVY")
                    {
                        return(RedirectToAction("Login", "InstitutionalVoting"));
                    }
                    else
                    {
                        return(RedirectToAction("Login", "ShareholderVoting"));
                    }
                }
            }

            MainVM viewModel = new MainVM();

            string meetingId = HttpContext.Session.GetString("displayResultsContractAddress");


            if (meetingId != "-1")
            {
                List <Question> questions = _blockchainContext.questions;

                viewModel.completedQuestions = (from q in questions
                                                select new QuestionVM
                {
                    quid = q.quid,
                    text = q.text,
                    block = q.block,
                    keyid = q.quid + "|"
                }
                                                ).ToList();

                viewModel.meeting = Context.meetings.AsQueryable().Where(m => m._id == meetingId).FirstOrDefault();
            }
            else
            {
                viewModel.completedQuestions = new List <QuestionVM>();
            }

            ViewBag.UserType = UserType;

            return(View(viewModel));
        }
 public LanguageObjectPreference()
 {
     data = new LanguagePreference();
     data.Caption = string.Empty;
     data.EnumerationOptions = null;
     data.PreferenceGroup = string.Empty;
     data.PrefrenceType = LanguagePreferenceType.Boolean;
     data.Value = null;
 }
        public IActionResult Question_Codebehind(string quidAndUserType, LanguagePreference languagePreference)
        {
            string quid     = quidAndUserType.Split('|')[0].ToString();
            string UserType = quidAndUserType.Split('|')[1].ToString();

            if (HttpContext.Session.GetString("displayResultsContractAddress") == null)
            {
                if (languagePreference == LanguagePreference.Russian)
                {
                    if (UserType == "IVY")
                    {
                        return(RedirectToAction("Login_Russian", "InstitutionalVoting"));
                    }
                    else
                    {
                        return(RedirectToAction("Login_Russian", "ShareholderVoting"));
                    }
                }
                else
                {
                    if (UserType == "IVY")
                    {
                        return(RedirectToAction("Login", "InstitutionalVoting"));
                    }
                    else
                    {
                        return(RedirectToAction("Login", "ShareholderVoting"));
                    }
                }
            }


            List <Question> questions  = _blockchainContext.questions;
            var             question   = questions.FirstOrDefault(q => q.quid == quid);
            QuestionVM      questionVM = new QuestionVM();

            questionVM.quid = quid;
            questionVM.text = question.text;

            ViewBag.UserType = UserType;

            return(View(questionVM));
        }
Example #8
0
        public async Task <IActionResult> Login_Codebehind(string controlNumber, LanguagePreference languagePreference)
        {
            HttpContext.Session.SetString("ControlNumber", controlNumber);
            SHOAccount shoAccount = _context.shoaccounts.AsQueryable().FirstOrDefault(a => a.ControlNumber == controlNumber);

            HttpContext.Session.SetString("AvailableShares", shoAccount.AvailableShares.ToString());
            List <Question> questions = _blockchainContext.questions;
            List <Answer>   answers   = new List <Answer>();

            foreach (Question question in questions)
            {
                Answer answer = new Answer();
                answer.quid   = question.quid;
                answer.answid = "A";
                answer.test   = "FOR";
                answers.Add(answer);
                answer        = new Answer();
                answer.quid   = question.quid;
                answer.answid = "B";
                answer.test   = "AGAINST";
                answers.Add(answer);
                answer        = new Answer();
                answer.quid   = question.quid;
                answer.answid = "Z";
                answer.test   = "ABSTAIN";
                answers.Add(answer);
            }
            HttpContext.Session.SetString("answers", Newtonsoft.Json.JsonConvert.SerializeObject(answers));

            if (languagePreference == LanguagePreference.Russian)
            {
                return(await Task.Run <IActionResult>(() => { return RedirectToAction("Index_Russian", new { revote = "0" }); }));
            }
            else
            {
                return(await Task.Run <IActionResult>(() => { return RedirectToAction("Index", new { revote = "0" }); }));
            }
        }
 private static bool DoesNotSpeaksGreek(LanguagePreference lang)
 => lang == LanguagePreference.DoesNotSpeakGreek;
 private static bool RegardlessOfLanguage(LanguagePreference lang)
 => true;
Example #11
0
 protected CustomerPreference CustomerPreference(LanguagePreference lang, CarPreference car) =>
 new CustomerPreference(lang, car);
        /// <summary>
        /// Draws a language selection popup used for showing a user's language preference.
        /// Returns the corresponding SerializedProperty of the drawn language selection popup which be used after ApplyModifiedProperties() to detect changes to the settings.
        /// </summary>
        /// <param name="languagePreference">Determines wheter to draw the Text Language preference or the Audio Language preference.</param>
        private SerializedProperty DrawLanguagePreference(LanguagePreference languagePreference)
        {
            // Declare and set variables depending on the type of language preference to draw
            List <string>      languages              = default;
            SerializedProperty preferencesProperty    = default;
            string             defaultProjectLanguage = default;
            string             infoMessageOnEmptyProjectLanguageList = default;
            string             languagePopupLabel = default;

            switch (languagePreference)
            {
            case LanguagePreference.TextLanguage:
                languages              = _textLanguages;
                preferencesProperty    = _preferences.FindProperty("_textLanguage");
                defaultProjectLanguage = ProjectSettings.TextProjectLanguageDefault;
                infoMessageOnEmptyProjectLanguageList = _emptyTextLanguageMessage;
                languagePopupLabel     = "Text Language";
                _textLanguageLastFrame = preferencesProperty.stringValue;
                break;

            case LanguagePreference.AudioLanguage:
                languages              = _audioLanguage;
                preferencesProperty    = _preferences.FindProperty("_audioLanguage");
                defaultProjectLanguage = ProjectSettings.AudioProjectLanguageDefault;
                infoMessageOnEmptyProjectLanguageList = _emptyAudioLanguageMessage;
                languagePopupLabel      = "Audio Language";
                _audioLanguageLastFrame = preferencesProperty.stringValue;
                break;
            }

            // Get currently available languages and determine which the selected language should be
            int selectedLanguageIndex = -1;

            string[] languagesNamesAvailableForSelection = languages.Count > 0 ? languages.ToArray() : System.Array.Empty <string>();
            var      selectedLanguage = languagesNamesAvailableForSelection
                                        .Select((name, index) => new { name, index })
                                        .FirstOrDefault(element => element.name == preferencesProperty.stringValue);

            if (selectedLanguage != null)
            {
                selectedLanguageIndex = selectedLanguage.index;
            }
            else if (!string.IsNullOrEmpty(defaultProjectLanguage))
            {
                // Assign default language in case the currently selected language has become invalid
                selectedLanguageIndex = 0;
            }
            string[] languagesDisplayNamesAvailableForSelection = languagesNamesAvailableForSelection.Select(name => Cultures.GetCultures().FirstOrDefault(c => c.Name == name).DisplayName).ToArray();
            // Disable popup and show message box in case the project languages have been defined yet
            if (languagesNamesAvailableForSelection.Length == 0)
            {
                GUI.enabled = false;
                EditorGUILayout.HelpBox(infoMessageOnEmptyProjectLanguageList, MessageType.Info);
            }
            // Draw the actual language popup
            selectedLanguageIndex = EditorGUILayout.Popup(languagePopupLabel, selectedLanguageIndex, languagesDisplayNamesAvailableForSelection);
            // Change/set the language ID
            if (selectedLanguageIndex != -1)
            {
                preferencesProperty.stringValue = languagesNamesAvailableForSelection[selectedLanguageIndex];
            }
            else
            {
                // null the language ID since the index is invalid
                preferencesProperty.stringValue = string.Empty;
            }
            GUI.enabled = true;

            return(preferencesProperty);
        }
        public LanguagePreference SetLanguagePreferenceValue(LanguagePreference oldValue, LanguageObjectPreference newValue)
        {
            if (oldValue.PrefrenceType == LanguagePreferenceType.Boolean)
            {
                oldValue.Value = newValue.BoolValue.ToString();
            }
            else if (oldValue.PrefrenceType == LanguagePreferenceType.Number)
            {
                oldValue.Value = newValue.IntValue.ToString();
            }
            else if (oldValue.PrefrenceType == LanguagePreferenceType.Enumerated)
            {
                oldValue.Value = newValue.EnumerationValue;
            }

            return oldValue;
        }
Example #14
0
        public async Task <IActionResult> Index_CodeBehind(LanguagePreference languagePreference, string revote)
        {
            string voteAnswerChoices = "";

            if (HttpContext.Session.GetString("ControlNumber") == null)
            {
                return(await Task.Run <IActionResult>(() => { return RedirectToAction("Login"); }));
            }

            List <VoteSubmission> voteSubmissions = _context.votesubmission.AsQueryable().ToList();

            string controlNumber = HttpContext.Session.GetString("ControlNumber");

            SHOAccount shoaccount = _context.shoaccounts.AsQueryable().Where(sho => sho.ControlNumber == controlNumber).FirstOrDefault();

            if (shoaccount.maskedVoters != null && shoaccount.maskedVoters.Any())
            {
                List <string> voteSessionIds     = new List <string>();
                string        voteSessionId      = "";
                string        firstVoteSessionId = "";
                bool          allTheSame         = true;
                for (int x = 0; x < shoaccount.maskedVoters.Count(); x++)
                {
                    VoteMask voteMask = shoaccount.maskedVoters[x];
                    Voter    voter1   = await _blockchainContext.getVoteAnswersByVoterId(voteMask.voterId);

                    voteAnswerChoices = voter1.voteSelections;
                    string voteSessionId1 = voter1.sessionId;
                    voteSessionIds.Add(voteSessionId1);
                    if (x == 0)
                    {
                        firstVoteSessionId = voteSessionId1;
                    }
                    else
                    {
                        if (firstVoteSessionId != voteSessionId1)
                        {
                            allTheSame = false;
                        }
                    }
                }

                if (allTheSame)
                {
                    voteSessionId = firstVoteSessionId;
                }
                else
                {
                }

                var existingVoteSubmissions = voteSubmissions.Where(v => v.ControlNumber == controlNumber && v.voteSubmissionStatus == VoteSubmissionStatus.VotesConfirmed);
                if (existingVoteSubmissions.Any())
                {
                    if (existingVoteSubmissions.Any(vs => vs._id == voteSessionId) && allTheSame)
                    {
                        var filterVoteSubmission = Builders <VoteSubmission> .Filter.Eq("_id", voteSessionId);

                        _context.votesubmission.DeleteMany(filterVoteSubmission);
                    }
                    else
                    {
                        if (languagePreference == LanguagePreference.Russian)
                        {
                            return(RedirectToAction("Confirm_Russian", new { id = existingVoteSubmissions.FirstOrDefault()._id }));
                        }
                        else
                        {
                            return(RedirectToAction("Confirm", new { id = existingVoteSubmissions.FirstOrDefault()._id }));
                        }
                    }
                }
                else
                {
                    if (revote == "0")
                    {
                        var filterVoteSubmission = Builders <VoteSubmission> .Filter.Eq("ControlNumber", controlNumber);

                        _context.votesubmission.DeleteMany(filterVoteSubmission);
                    }
                }
            }

            if (revote == "1" || voteAnswerChoices == "")
            {
                MainVM viewModel = new MainVM();
                if (controlNumber != "-1")
                {
                    List <Question> questions = _blockchainContext.questions;

                    viewModel.activeQuestions = (from q in questions
                                                 orderby q.questionIndex
                                                 select new QuestionVM
                    {
                        quid = q.quid,
                        boardRecommendation = q.boardRecommendation,
                        text = q.text,
                        text_ru = q.text_ru,
                        questionIndex = q.questionIndex,
                        keyid = q.quid + "|",
                        SelectedAnswerId = "Z"
                    }
                                                 ).ToList();

                    viewModel.activeQuestions.ForEach(sv => sv.orderNum = Convert.ToInt32(sv.questionIndex) + 1);

                    List <Answer> answers = new List <Answer>();
                    Answer        answer  = new Answer();
                    answer.answid = "A";
                    answer.test   = "FOR";
                    answers.Add(answer);
                    Answer answer2 = new Answer();
                    answer2.answid = "B";
                    answer2.test   = "AGAINST";
                    answers.Add(answer2);
                    Answer answer3 = new Answer();
                    answer3.answid = "Z";
                    answer3.test   = "ABSTAIN";
                    answers.Add(answer3);

                    foreach (QuestionVM question in viewModel.activeQuestions)
                    {
                        question.Answers = (from a in answers
                                            orderby a.answid
                                            select new AnswerVM
                        {
                            quid = question.quid,
                            answid = a.answid,
                            text = a.test
                        }
                                            ).ToList();
                    }
                }
                else
                {
                    viewModel.activeQuestions = new List <QuestionVM>();
                }

                return(await Task.Run <IActionResult>(() => { return View(viewModel); }));
            }
            else
            {
                if (languagePreference == LanguagePreference.Russian)
                {
                    return(await Task.Run <IActionResult>(() => { return RedirectToAction("Confirm_Russian", new { id = "0" }); }));
                }
                else
                {
                    return(await Task.Run <IActionResult>(() => { return RedirectToAction("Confirm", new { id = "0" }); }));
                }
            }
        }
 private static bool SpeaksGreek(LanguagePreference lang)
 => lang == LanguagePreference.Greek;
Example #16
0
        public async Task <IActionResult> CreateAsync(TrueView model, string search)
        {
            List <Marker> list                  = db.Marker.ToList();
            var           applicationMax        = db.Application;
            var           applicationDetailsMax = db.ApplicationDetails;

            ViewBag.MarkerList = new SelectList(list, "IdentityNo", "Name");

            var markerDatabase = db.Marker;


            var idNumber = markerDatabase.AsQueryable().Where(idNumber => model.IdentityNo == idNumber.IdentityNo);

            if (idNumber.Count() <= 0)
            {
                Marker marker = new Marker();
                marker.IdentityNo  = model.IdentityNo;
                marker.Surname     = model.Surname;
                marker.Initials    = model.Initials;
                marker.Gender      = model.Gender;
                marker.Race        = model.Race;
                marker.Title       = model.Title;
                marker.Persal      = model.Persal;
                marker.MaidenName  = model.MaidenName;
                marker.Nationality = model.Nationality;
                db.Marker.Add(marker);
                db.SaveChanges();
            }
            else
            {
                List <Marker> allsearch = db.Marker.Where(x => x.IdentityNo.Contains(search)).Select(x => new Marker
                {
                    IdentityNo = x.IdentityNo,
                    Surname    = x.Surname
                }).ToList();
            };

            //Application
            Application application = new Application();

            application.IdentityNo           = model.IdentityNo;
            application.Subject              = model.Subject;
            application.Language             = model.Language;
            application.Paper                = model.Paper;
            application.Position             = model.Position;
            application.CurrentPosition      = model.CurrentPosition;
            application.PracticalSubject     = model.PracticalSubject;
            application.PracticalExamination = model.PracticalExamination;

            application.CheckedBySubjectAdvisor = model.CheckedBySubjectAdvisor;
            application.RecommendedBySubject    = model.RecommendedBySubject;
            application.SelectionReason         = model.SelectionReason;
            db.Application.Add(application);
            db.SaveChanges();


            //LanguageContact
            LanguagePreference languagePreference = new LanguagePreference();

            languagePreference.IdentityNo          = model.IdentityNo;
            languagePreference.LanguageDescription = model.LanguageDescription;
            db.LanguagePreference.Add(languagePreference);
            db.SaveChanges();

            //Save contact

            Contact contact = new Contact();

            contact.IdentityNo      = model.IdentityNo;
            contact.TelephoneNo     = model.TelephoneNo;
            contact.WorkSchool      = model.WorkSchool;
            contact.HomeTelephoneNo = model.HomeTelephoneNo;
            contact.CellphoneNo     = model.CellphoneNo;
            contact.FaxNo           = model.FaxNo;
            contact.EmailAddress    = model.EmailAddress;
            db.Contact.Add(contact);
            db.SaveChanges();

            //Resindent
            Resident resident = new Resident();

            resident.IdentityNo             = model.IdentityNo;
            resident.ResidentialAddress     = model.ResidentialAddress;
            resident.PostalCode             = model.PostalCode;
            resident.Latitude               = model.Latitude;
            resident.Longitude              = model.Longitude;
            resident.FullResidentialAddress = model.FullResidentialAddress;

            db.Resident.Add(resident);
            db.SaveChanges();
            //currentEmployment
            CurrentEmployment currentEmployment = new CurrentEmployment();

            currentEmployment.IdentityNo            = model.IdentityNo;
            currentEmployment.NameOftheSchoolOffice = model.NameOftheSchoolOffice;
            currentEmployment.CentreNumber          = model.CentreNumber;
            currentEmployment.District        = model.District;
            currentEmployment.CurrentPosition = model.CurrentPosition;
            currentEmployment.EmploymentType  = model.EmploymentType;
            currentEmployment.Retiring        = model.Retiring;
            db.CurrentEmployment.Add(currentEmployment);
            db.SaveChanges();

            //Qualification

            Qualification qualification = new Qualification();

            qualification.IdentityNo               = model.IdentityNo;
            qualification.QualificationYear        = model.QualificationYear;
            qualification.QualificationDescription = model.QualificationDescription;
            qualification.MojarSubjects            = model.MojarSubjects;
            qualification.CourseLevel              = model.CourseLevel;
            qualification.LevelOfDegree            = model.LevelOfDegree;
            qualification.LevelOfDiploma           = model.LevelOfDiploma;
            db.Qualification.Add(qualification);
            db.SaveChanges();

            //Teaching Experience

            TeachingExperience teachingExperience = new TeachingExperience();

            teachingExperience.IdentityNo          = model.IdentityNo;
            teachingExperience.TeachingExperience1 = model.TeachingExperience1;
            teachingExperience.ExperienceInNcsCaps = model.ExperienceInNcsCaps;
            teachingExperience.SubjectExperience   = model.SubjectExperience;
            teachingExperience.Fetexperience       = model.Fetexperience;
            teachingExperience.Year     = model.Year;
            teachingExperience.Subject  = model.Subject;
            teachingExperience.Language = model.Language;
            teachingExperience.Grade    = model.Grade;
            teachingExperience.NameofschooIInstitution = model.NameofschooIInstitution;
            teachingExperience.PercentageofLearners    = model.PercentageofLearners;
            db.TeachingExperience.Add(teachingExperience);
            db.SaveChanges();

            //Marking Experience
            MarkingExperience markingExperience = new MarkingExperience();

            markingExperience.IdentityNo            = model.IdentityNo;
            markingExperience.MarkingExperienceYear = model.MarkingExperienceYear;
            markingExperience.Subject      = model.Subject;
            markingExperience.Language     = model.Language;
            markingExperience.PositionHeld = model.PositionHeld;
            db.MarkingExperience.Add(markingExperience);
            db.SaveChanges();

            ApplicationDetails applicationDetails = new ApplicationDetails();

            //Test


            int max = applicationMax.AsQueryable().Max(pet => pet.AppliactionId);

            applicationDetails.Subject       = model.Subject;
            applicationDetails.Language      = model.Language;
            applicationDetails.Paper         = model.Paper;
            applicationDetails.ApplicationId = max;
            db.ApplicationDetails.Add(applicationDetails);
            db.SaveChanges();

            //Prescribe
            PrescribedWorks prescribedWorks = new PrescribedWorks();
            int             maxD            = applicationDetailsMax.AsQueryable().Max(detail => detail.ApplicationDetailsId);

            prescribedWorks.ApplicationDetailsId = maxD;
            prescribedWorks.Drama        = model.Drama;
            prescribedWorks.Novel        = model.Novel;
            prescribedWorks.ShortStories = model.ShortStories;
            prescribedWorks.Poetry       = model.Poetry;
            db.PrescribedWorks.Add(prescribedWorks);
            db.SaveChanges();
            //Declaration

            DeclerationByApplicant declerationByApplicant = new DeclerationByApplicant();

            declerationByApplicant.IdentityNo      = model.IdentityNo;
            declerationByApplicant.Declaration     = model.Declaration;
            declerationByApplicant.YearAvg         = model.YearAvg;
            declerationByApplicant.TaughtByAverage = model.TaughtByAverage;
            declerationByApplicant.DistrictYear    = model.DistrictYear;
            declerationByApplicant.CandidatesByDistrictPercentage = model.CandidatesByDistrictPercentage;
            declerationByApplicant.PercentageYear     = model.PercentageYear;
            declerationByApplicant.ProvincePercentage = model.ProvincePercentage;
            db.DeclerationByApplicant.Add(declerationByApplicant);
            db.SaveChanges();



            //Motivation
            Motivation motivation = new Motivation();

            motivation.IdentityNo            = model.IdentityNo;
            motivation.MotivationDescription = model.MotivationDescription;
            db.Motivation.Add(motivation);
            db.SaveChanges();


            ////Applicatio
            //List<string> result = new List<string>();

            //using (SqlConnection con = new SqlConnection("Data Source=197.242.147.140,1433;User ID=markers_user;Password=********;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
            //{
            //    using (SqlCommand cmd = new SqlCommand("select DISTINCT IdentityNo from Marker where IdentityNoLIKE '%'+@IdentityNo+'%'", con))
            //    {
            //        con.Open();
            //        cmd.Parameters.AddWithValue("@IdentityNo", IdentityNo);
            //        SqlDataReader dr = cmd.ExecuteReader();
            //        while (dr.Read())

            //        {
            //            result.Add(dr["IdentityNo"].ToString());
            //        }

            //        con.Close();

            //}
            return(View(model));
        }
Example #17
0
        public UserPreference(string languageFolder)
        {
            // -- Create the instance of general preference class.
            this._General = new GeneralPreference();

            // -- Create the instance of language preference class.
            this._Language = new LanguagePreference();

            // -- Create the instance of indicator preference class.
            this._Indicator = new IndicatorPreference();

            // -- Create the instance of dataview preference class.
            this._DataView = new DataviewPreference(Path.Combine(languageFolder, this._Language.InterfaceLanguage + ".xml"));

            // -- Create the instance of chart preference class.
            this._Chart = new GraphPreference();

            // -- Create the instance of mapping preference class.
            this._Mapping = new MapPrefernce();

            //-- Vreate the instance of default legend colors and add the colors into it.
            this._Mapping.DefaultLegendColors = new List<string>();

            if (this._Mapping.DefaultLegendColors.Count == 0)
            {
                this._Mapping.DefaultLegendColors.Add("#DEE4F0");
                this._Mapping.DefaultLegendColors.Add("#94A9D3");
                this._Mapping.DefaultLegendColors.Add("#4A6EB6");
                this._Mapping.DefaultLegendColors.Add("#003399");
            }

            // -- Create the instance of sound preference class.
            this._Sound = new SoundPreference();

            // -- Create the instance of database preference class.
            this._Database = new DatabasePreference();

            // -- Create the instance of user selection.
            this._UserSelection = new UserSelection();

            // -- Create the instance of MRU preference class.
            this._MRU = new MRUPreference();

            //-- Event to update the language of fields in dataview.
            this._Language.InterfaceLanguageChanged += new LanguagePreference.InterfaceLanguageChangedDelegate(_Language_UpdateLanguageEvent);

            //-- Set the language folder path.
            LanguageFolderPath = languageFolder;
        }