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> OnPostAsync()
{
foreach (var cadEntry in CadetViews)
{
bool emptyVal = false;
if (string.IsNullOrEmpty(cadEntry.firstName) || string.IsNullOrEmpty(cadEntry.lastName) ||
string.IsNullOrEmpty(cadEntry.schoolForm) || string.IsNullOrEmpty(cadEntry.cadGender) ||
string.IsNullOrEmpty(cadEntry.cadRank))
{
emptyVal = true;
}
if (emptyVal == false)
{
var cadet = _context.Cadets
.Where(r => r.Surname == cadEntry.lastName &&
r.KnownAs == cadEntry.firstName && r.Gender == cadEntry.cadGender && r.Year == cadEntry.schoolYear).ToList();
if (cadet.Count > 0)
{
tempString = "Cadet already exists";
}
else
{
_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(RedirectToPage("./CadetCreator"));
}
public async Task <IActionResult> OnPostAsync()
{
foreach (var qualEntry in QualificationViews)
{
bool emptyVal = false;
if (string.IsNullOrEmpty(qualEntry.qualName))
{
emptyVal = true;
}
if (emptyVal == false)
{
var qual = _context.Qualifications.Where(r => r.Name == qualEntry.qualName).ToList();
if (qual.Count > 0)
{
tempString = "Cadet already exists";
}
else
{
_context.Add(new Qualification
{
Name = qualEntry.qualName,
PassMark = qualEntry.passMark,
ParOrChi = qualEntry.chiPar,
Parent = qualEntry.parent,
NumOfChi = qualEntry.chiNum,
MinChiPass = qualEntry.passNum
});
counttest++;
await _context.SaveChangesAsync();
tempString = counttest + "Entries Created";
}
}
}
return(RedirectToPage("./QualificationCreator"));
}
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;
*
*/
}
