public async Task <IActionResult> AddStudent(StudentViewModel std)
{
//GEt the List of class
var i = _context.Class.ToList();
//Insert a new element in position 0
i.Insert(0, new Class {
ClassId = 0, ClassName = "Select"
});
ViewBag.Class = i;
// Create a student and save to the database
Student st = new Student()
{
StudentId = std.stdntidVM,
StudentName = std.stdntnameVM,
StudentCAddress = std.stdntcaddrssVM,
StudentPAddress = std.stdntpaddrssVM,
StudentNationality = std.stdntnationVM,
StudentDOB = std.dobVM,
StudentGender = std.stdntgenderVM,
DateOfAdmission = DateTime.Now.Date,
StudentClass = std.stdntclsVM,
StudentPhoto = std.stdntphotoVM,
Year = DateTime.Now.Year
};
_context.Student.Add(st);
await _context.SaveChangesAsync();
//Get the id of saved student
var StudentId = st.StudentId;
//Create guradian info for that student and save it
GuardianInfo gi = new GuardianInfo()
{
SL = 0,
StudentID = StudentId,
GNameF = std.gnameFVM,
GNameM = std.gnameMVM,
GPhoneF = std.gphoneFVM,
GPhoneM = std.gphoneMVM,
GEmailF = std.gemailFVM,
GEmailM = std.gemailMVM,
GOccupationF = std.goccupationFVM,
GOccupationM = std.goccupationMVM,
GOrganisationF = std.gorganisationFVM,
GOrganisationM = std.gorganisationMVM,
GDesignationF = std.gdesignationFVM,
GDesignationM = std.gdesignationsMVM
};
_context.GuardianInfo.Add(gi);
await _context.SaveChangesAsync();
// Create random password
PasswordCreator ps = new PasswordCreator();
//Insert the login information for student login and save
Login lg = new Login()
{
SL = 0,
Username = StudentId.ToString(),
Password = ps.RandomPassword(),
FirstLoginStatus = true,
ActiveStatus = true,
RoleId = 1,
DistinguishId = StudentId,
};
lg.CurrentPassword = lg.Password;
_context.Login.Add(lg);
await _context.SaveChangesAsync();
//Clear the modelstate
ModelState.Clear();
return(View());
}
public async Task <IActionResult> NewTeacher(TeacherViewModel tr)
{
Teacher tchr = new Teacher()
{
TeacherId = 0,
TeacherName = tr.TcrnameVM,
TeacherBG = tr.TcrbgVM,
TeacherEmail = tr.TcremailVM,
TeacherCAddress = tr.TcrcaddrssVM,
TeacherPAddress = tr.TcrpaddrssVM,
TeacherDOB = tr.TcrdobVM,
TeacherGender = tr.TcrgenderVM,
TeacherNationality = tr.TcrnationVM,
TeacherPhoneNo = tr.TcrphoneVM,
TeacherJD = DateTime.Now.Date,
TeacherPhoto = tr.TcrphotoVM,
TeacherDesignation = tr.TcrdesigVM
};
_context.Teacher.Add(tchr);
await _context.SaveChangesAsync();
///Get the id of teacher
var TeacherId = tchr.TeacherId;
//Teacher email
var TeacherEmail = tchr.TeacherEmail;
// Create random password
PasswordCreator ps = new PasswordCreator();
//Create login
Login lg = new Login()
{
SL = 0,
Username = TeacherEmail,
Password = ps.RandomPassword(),
FirstLoginStatus = false,
ActiveStatus = true,
RoleId = 2,
DistinguishId = TeacherId
};
lg.CurrentPassword = lg.Password;
_context.Login.Add(lg);
await _context.SaveChangesAsync();
///Save the Document Information to the Database
TeacherDocSubmitted doc = new TeacherDocSubmitted()
{
TeacherId = TeacherId,
SL = 0,
SSCCertificate = tr.TcrdocsubhsccrtfctVM,
SSCMarksheet = tr.TcrdocsubsscmarkVM,
HSCCertificate = tr.TcrdocsubhsccrtfctVM,
HSCMarksheet = tr.TcrdocsubhscmarkVM,
HonsCertificate = tr.TcrdocsubhonscrtfctVM,
HonsMarksheet = tr.TcrdocsubhonsmarkVM
};
await _context.TeacherDocSubmitted.AddAsync(doc);
await _context.SaveChangesAsync();
TeacherQualification tq = new TeacherQualification()
{
SL = 0,
TeacherId = TeacherId,
SSCYear = tr.TcrqsscyearVM,
SSCGrade = tr.TcrqsscgradeVM,
SSCInstitute = tr.TcrqsscinsVM,
HSCYear = tr.TcrqhscyearVM,
HSCGrade = tr.TcrqhscgradeVM,
HSCInstitute = tr.TcrqhscinsVM,
HonsYear = tr.TcrqhonsyearVM,
HonsGrade = tr.TcrqhonsgradeVM,
HonsInstitute = tr.TcrqhonsinsVM
};
await _context.TeacherQualification.AddAsync(tq);
await _context.SaveChangesAsync();
///Clear the model state
ModelState.Clear();
return(View());
}