示例#1
0
        public async Task <IActionResult> OnPostSubmitAsync()
        {
            foreach (var cadEntry in Cadets)
            {
                bool emptyVal = false;

                if (string.IsNullOrEmpty(cadEntry.KnownAs) ||
                    string.IsNullOrEmpty(cadEntry.Surname) ||
                    string.IsNullOrEmpty(cadEntry.Form) ||
                    string.IsNullOrEmpty(cadEntry.Gender) ||
                    string.IsNullOrEmpty(cadEntry.Rank))
                {
                    emptyVal = true;
                }

                if (emptyVal == false)
                {
                    Cadets = _context.Cadets
                             .Where(r => r.CadetId == cadEntry.CadetId)
                             .OrderBy(s => s.Surname).ToList();

                    //var cadet = _context.Cadets.Attach(new Cadet { CadetId = cadEntry.CadetId });

                    if (Cadets.Count > 0)
                    {
                        for (var i = 0; i < Cadets.Count; i++)
                        {
                            Cadets[i].KnownAs = cadEntry.KnownAs;
                            Cadets[i].Surname = cadEntry.Surname;
                            Cadets[i].Age     = cadEntry.Age;
                            Cadets[i].Year    = cadEntry.Year;
                            Cadets[i].Form    = cadEntry.Form;
                            Cadets[i].Gender  = cadEntry.Gender;
                            Cadets[i].Rank    = cadEntry.Rank;
                            Cadets[i].Platoon = cadEntry.Platoon;
                            Cadets[i].Section = cadEntry.Section;
                            _context.Update(Cadets[i]);
                            _context.SaveChanges();
                        }
                        //_context.Add(new Cadet
                        //{
                        //    Surname = cadEntry.lastName,
                        //    KnownAs = cadEntry.firstName,
                        //    Age = cadEntry.yearsOld,
                        //    Year = cadEntry.schoolYear,
                        //    Form = cadEntry.schoolForm,
                        //    Gender = cadEntry.cadGender,
                        //    Rank = cadEntry.cadRank,
                        //    Platoon = cadEntry.cadPlatoon,
                        //    Section = cadEntry.cadSection
                        //});
                        //counttest++;
                        //await _context.SaveChangesAsync();
                        //tempString = counttest + "Entries Created";
                    }
                }
            }
            return(Page());
        }
示例#2
0
        public async Task <IActionResult> OnPostAsync()
        {
            Cadets         = _context.Cadets.Include(s => s.Qualifications).OrderBy(s => s.Surname).ToList();
            Qualifications = _context.Qualifications.OrderBy(s => s.Name).ToList();


            foreach (var qualEntry in QualAssignViews)
            {
                //string inpName = qualEntry.cadetName;

                //string[] splitName = inpName.Split(',');
                //string realName = $"{splitName[1]} {splitName[0]}".Trim();

                var cadetQuer = _context.Cadets
                                .Where(s => s.Surname == qualEntry.cadetName /*splitName[0].Trim()
                                                                              * && s.KnownAs == splitName[1].Trim()*/)
                                .ToList();
                var qualQuer = _context.Qualifications.Where(s => s.Name == qualEntry.qualName).ToList();

                if (cadetQuer.Count > 0 && qualQuer.Count > 0)
                {
                    var cadQual = _context.CadetQualifications
                                  .Where(c => c.CadetId == cadetQuer[0].CadetId && c.QualificationId == qualQuer[0].QualificationId)
                                  .ToList();

                    if (qualEntry.cadetMark >= qualQuer[0].PassMark)
                    {
                        resultPass = "******";
                    }

                    if (cadQual.Count > 0)
                    {
                        for (var i = 0; i < cadQual.Count; i++)
                        {
                            cadQual[i].CadetId         = cadetQuer[0].CadetId;
                            cadQual[i].QualificationId = qualQuer[0].QualificationId;
                            cadQual[i].cadMark         = qualEntry.cadetMark;
                            cadQual[i].Passed          = resultPass;
                            _context.Update(cadQual[i]);
                        }
                    }
                    if (cadQual.Count == 0)
                    {
                        _context.CadetQualifications.Add(
                            new CadetQualification
                        {
                            CadetId         = cadetQuer[0].CadetId,
                            QualificationId = qualQuer[0].QualificationId,
                            cadMark         = qualEntry.cadetMark,
                            Passed          = resultPass
                        });
                    }
                    await _context.SaveChangesAsync();
                }
            }

            return(Page());
        }
        public async Task <IActionResult> OnPostSubmitAsync()
        {
            foreach (var qualEntry in Qualifications)
            {
                bool emptyVal = false;

                if (string.IsNullOrEmpty(qualEntry.Name))
                {
                    emptyVal = true;
                }

                if (emptyVal == false)
                {
                    Qualifications = _context.Qualifications
                                     .Where(r => r.QualificationId == qualEntry.QualificationId)
                                     .OrderBy(s => s.Name).ToList();

                    //var cadet = _context.Cadets.Attach(new Cadet { CadetId = cadEntry.CadetId });

                    if (Qualifications.Count > 0)
                    {
                        for (var i = 0; i < Qualifications.Count; i++)
                        {
                            Qualifications[i].Name       = qualEntry.Name;
                            Qualifications[i].PassMark   = qualEntry.PassMark;
                            Qualifications[i].ParOrChi   = qualEntry.ParOrChi;
                            Qualifications[i].Parent     = qualEntry.Parent;
                            Qualifications[i].NumOfChi   = qualEntry.NumOfChi;
                            Qualifications[i].MinChiPass = qualEntry.MinChiPass;
                            _context.Update(Qualifications[i]);
                            _context.SaveChanges();
                        }
                    }
                }
            }
            return(Page());
        }
示例#4
0
        public async Task <IActionResult> OnPostSubmitAsync()
        {
            //DateTime inputDate = date;
            //bool attendance = Attend;
            Cadets    = _context.Cadets.Include(c => c.Registers).OrderBy(s => s.Surname).ToList();
            Registers = _context.Registers.ToList();
            //var cadetRegisters = _context.CadetRegisters.Where(r => r.RegisterId == r.Register.RegisterId && r.Register.DateOfReg == inputDate && r.Cadet.Surname == inputName).ToList();

            foreach (var regEntry in RegisterViews)
            {
                string inpName = regEntry.FullName;

                string[] splitName = inpName.Split(',');
                string   realName  = $"{splitName[1]} {splitName[0]}".Trim();

                var cadetQuer  = _context.Cadets.Where(c => c.Surname == splitName[0].Trim() && c.KnownAs == splitName[1].Trim()).ToList();
                var attendance = 0 == string.Compare(regEntry.Attendance, "true", StringComparison.CurrentCultureIgnoreCase);
                var regQuer    = _context.Registers
                                 .Where(r => r.DateOfReg == regEntry.RegDate && r.Attended == attendance).ToList();
                if (regQuer.Count > 0 && cadetQuer.Count > 0)
                {
                    var cadReg = _context.CadetRegisters
                                 .Where(c => c.CadetId == cadetQuer[0].CadetId && c.Register.DateOfReg == regQuer[0].DateOfReg)
                                 .ToList();
                    if (cadReg.Count > 0)
                    {
                        for (var i = 0; i < cadReg.Count; i++)
                        {
                            cadReg[i].CadetId    = cadetQuer[0].CadetId;
                            cadReg[i].RegisterId = regQuer[0].RegisterId;
                            _context.Update(cadReg[i]);
                        }
                    }
                    if (cadReg.Count == 0)
                    {
                        int cadID = cadetQuer[0].CadetId;
                        int regID = regQuer[0].RegisterId;
                        _context.CadetRegisters.Add(new CadetRegister {
                            CadetId = cadID, RegisterId = regID
                        });
                    }
                    counttest++;
                    returnedString = counttest + " Entry Created";
                    await _context.SaveChangesAsync();
                }
                if (cadetQuer.Count == 0)
                {
                    returnedString = "Cadet doesn't exist";
                }
            }
            return(Page());

            /*if (cadetRegisters.Count > 0)
             * {
             *  string firstName = cadetRegisters[0].Cadet.KnownAs;
             *  string lastName = cadetRegisters[0].Cadet.Surname;
             *  string attend = cadetRegisters[0].Register.Attended.ToString();
             *  string newDate = cadetRegisters[0].Register.DateOfReg.ToShortDateString();
             *  returnedString = stringCreate(firstName, lastName, newDate, attend);
             * }
             *
             * else
             * {
             *  var cadetQuer = _context.Cadets.Where(c => c.Surname == inputName).ToList();
             *  var regQuer = _context.Registers.Where(r => r.DateOfReg == inputDate && r.Attended == true).ToList();
             *  if (regQuer.Count > 0 && cadetQuer.Count > 0)
             *  {
             *      int cadID = cadetQuer[0].CadetId;
             *      int regID = regQuer[0].RegisterId;
             *      _context.CadetRegisters.Add(new CadetRegister { CadetId = cadID, RegisterId = regID });
             *      string firstName = cadetQuer[0].KnownAs;
             *      string lastName = cadetQuer[0].Surname;
             *      string attend = regQuer[0].Attended.ToString();
             *      string newDate = inputDate.ToShortDateString();
             *      returnedString = stringCreate(firstName, lastName, newDate, attend);
             *  }
             *  if (cadetQuer.Count > 0)
             *  {
             *      //run new date creation
             *      _context.Registers.Add(new Register { Attended = true, DateOfReg = inputDate });
             *      _context.Registers.Add(new Register { Attended = false, DateOfReg = inputDate });
             *      returnedString =
             *          stringCreate(cadetQuer[0].KnownAs, cadetQuer[0].Surname, inputDate.ToShortDateString(), attendance.ToString());
             *  }
             *  else
             *  {
             *      returnedString = "Cadet doesn't exist";
             *  }
             * }
             *
             * useDate = date.ToShortDateString();
             * return RedirectToPage("./RegisterEdit");*/


            //_context.Registers.Add(new Register {Attended = true,
            //DateOfReg = new DateTime(),
            //});

            //await _context.SaveChangesAsync();

            /*assigns value to variable depending on input
             * foreach (var cadet in RegisterViews)
             * {
             *  var s = $"{cadet.FullName}, {cadet.Attendance}, {cadet.RegDate}";
             *  if (cadet.Attendance == "true")
             *  {
             *      answer = "Yes";
             *  }
             *  else
             *  {
             *      answer = "No";
             *  }
             * }
             * string queryString =
             * "SELECT CadetId, RegisterId FROM dbo.CadetRegisters;";
             *
             * string queryStringAttend =
             * "SELECT Attended, DateOfReg FROM dbo.Register;";
             *
             * using (SqlConnection connection =
             *         new SqlConnection("Server=(localdb)\\mssqllocaldb;Database=CourseworkDatabase;Trusted_Connection=True;"))
             * {
             *  SqlCommand command =
             *      new SqlCommand(queryString, connection);
             *  connection.Open();
             *
             *  SqlDataReader reader = command.ExecuteReader();
             *
             *  // Call Read before accessing data.
             *  while (reader.Read())
             *  {
             *      string regId = Convert.ToString(reader[0]);
             *
             *      SqlCommand commandAttended =
             *      new SqlCommand(queryStringAttend, connection);
             *      connection.Open();
             *      SqlDataReader readerAttended = commandAttended.ExecuteReader();
             *
             *      returnedString = testFunc(regId, Convert.ToString(readerAttended[0]), Convert.ToDateTime(readerAttended[1]).Date);
             *  }
             *
             *  // Call Close when done reading.
             *  reader.Close();
             *  connection.Close();
             * }
             * using (v
             *  var register = DbConnection.Database.SqlQuery("SELECT * FROM Registers").ToList;
             *
             */
        }