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());
}
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());
}
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;
*
*/
}