public IActionResult New(Student student)
{
_context.Add(student);
_context.SaveChanges();
TempData["message"] = "success";
return(RedirectToAction("Edit", new { id = student.Id }));
}
public InsertStudentResponse InsertStudent(InsertStudentRequest request)
{
var exists = _studentContext.Student.Any(s => s.IndexNumber.Equals(request.IndexNumber));
if (exists)
{
return(null);
}
var student = new Student()
{
FirstName = request.FirstName,
LastName = request.LastName,
BirthDate = request.BirthDate,
IndexNumber = request.IndexNumber,
IdEnrollment = request.IdEnrollment,
Password = request.Password,
PSalt = request.Salt,
RefreshToken = request.RefreshToekn
};
_studentContext.Add(student);
_studentContext.SaveChanges();
return(new InsertStudentResponse
{
IndexNumber = student.IndexNumber,
LastName = student.LastName
});
}
public async Task <IActionResult> Create([Bind("Major_Num,Major_Id,Major_Dept,Major_Desc,Major_Degree")] Major major)
{
if (ModelState.IsValid)
{
_context.Add(major);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(major));
}
public async Task <IActionResult> Create([Bind("Id,FirstName,LastName,Year,Gender,StudentId,Period1,Period2,Period3,Period4,Period5,Period6")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public IActionResult EnrollStudent(EnrollStudentReq request)
{
/*
* var response = _dbService.EnrollStudent(request);
* if (response.Error != null)
* {
* return BadRequest(response.Error);
* }
*/
var idStudy = _studentContext.Studies.Where(s => s.Name == request.Studies).Select(s => s.IdStudy).FirstOrDefault();
if (idStudy == 0) // default
{
return(BadRequest("Study not found"));
}
var idEnrollment = _studentContext.Enrollment.Where(e => e.IdStudy == idStudy && e.Semester == 1).Select(e => e.IdEnrollment).FirstOrDefault();
if (idEnrollment == 0) // default
{
idEnrollment = _studentContext.Enrollment.Select(e => e.IdEnrollment).Max() + 1;
var enrollment = new Entities.Enrollment
{
IdEnrollment = idEnrollment,
IdStudy = idStudy,
Semester = 1,
StartDate = DateTime.Now
};
_studentContext.Add(enrollment);
}
var student = new Entities.Student
{
IndexNumber = request.IndexNumber,
FirstName = request.FirstName,
LastName = request.LastName,
Password = request.Password,
RefreshToken = request.Password,
BirthDate = request.BirthDate,
IdEnrollment = idEnrollment,
IdRole = request.IdRole,
};
_studentContext.Add(student);
_studentContext.SaveChanges();
var response = new
{
IdEnrollment = idEnrollment
};
return(Ok(response));
}
public static void Seed(StudentContext sContext,
ILoggerFactory loggerFactory)
{
try
{
// TODO: Only run this if using a real database
// context.Database.Migrate();
if (!sContext.Students.Any())
{
var eId = 1;
var sId = 1;
var ssId = 1;
for (var d = 1; d <= 4; d++)
{
for (var s = 1; s <= 9; s++)
{
var student = new Student(sId++, d,
$"Student{s:D2}",
$"Distrct{d:D2}",
DateTime.Today.AddYears(-1 * d),
$"{s:D2}{d:D4}");
sContext.Add(student);
for (var e = 1; e <= 3; e++)
{
var enrollment = new Enrollment {
EnrollmentId = eId++, Student = student, SchoolYear = DateTime.Today.AddYears(d).Year
};
sContext.Add(enrollment);
}
for (var ss = 1; ss <= 2; ss++)
{
var service = new Service {
ServiceId = ssId++, Student = student, SchoolYear = DateTime.Today.AddYears(d).Year, Name = $"S{ss:D4}{s:D2}{d:D3}"
};
sContext.Add(service);
}
}
}
sContext.SaveChanges();
}
}
catch (Exception ex)
{
var log = loggerFactory.CreateLogger <StudentContext>();
log.LogError(ex.Message);
throw;
}
}
public bool AddStudent(Student student)
{
try
{
var entry = _studentContext.Add(student);
_studentContext.SaveChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
public async Task <IActionResult> Create([Bind("Id,Name,Address,DayOfBirth")] Student student, IFormFile ProfilePic)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
if (ProfilePic != null)
{
if (ProfilePic.FileName != null)
{
var imageName = $"{student.Id}" + Path.GetExtension(ProfilePic.FileName);
var imageFolder = "Images";
var imageFolderPath = Path.GetFullPath($"./wwwroot/{imageFolder}");
var imagePath = Path.Join(imageFolderPath, imageName);
using (var stream = new FileStream(imagePath, FileMode.Create))
{
var task = ProfilePic.CopyToAsync(stream);
await task;
if (!task.IsFaulted)
{
student.ProfilePicPath = imageFolder + "/" + imageName;
await _context.SaveChangesAsync();
}
}
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public int StudentAdd(List <StudentModel> obj)
{
StudentContext studentContext = new StudentContext();
studentContext.Add(obj);
studentContext.SaveChanges();
//StudentContext studentcontext = new StudentContext();
//String connectionString = "Data Source=localhost;Initial Catalog=playground2017;User ID=sa;Password=Ashvik18";
//SqlConnection conn = new SqlConnection(connectionString);
//SqlCommand com = new SqlCommand("AddNewStudAttenDetails", conn);
//com.CommandType = CommandType.StoredProcedure;
//com.Parameters.AddWithValue("@Attendance", obj);
//com.Parameters.AddWithValue("@AttendanceDate", obj.AttendanceDate);
//com.Parameters.AddWithValue("@Comments", obj.Comments);
//com.Parameters.AddWithValue("@StudentID", obj.StudentID);
//conn.Open();
//int i = com.ExecuteNonQuery();
//conn.Close();
//return i;
//for(int i =0;i<=obj.Count;i++)
//{
// studentContext.ad(obj[0].StudentID);
//}
return(1);
}
public async Task <IActionResult> CreateEdit(int?id, StudentsInputDto students)
{
if (ModelState.IsValid)
{
if (id == null)
{
/*Students student = new Students
* {
* Name = students.Name,
* RollNo = students.RollNo,
* FatherName = students.FatherName,
* MotherName = students.MotherName,
* Age = students.Age,
* DOB = students.DOB,
* AddmissionDate = students.AddmissionDate,
* CompeletionDate = students.CompeletionDate,
* StandardId = students.StandardId,
* Standard = students.Standard
* };*/
var student = _mapper.Map <Students>(students);
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Student)));
}
}
if (id != null)
{
try
{
/* var student = _context.Students.Where(p => p.Id == id).FirstOrDefault();
* student.RollNo = students.RollNo;
* student.Name = students.Name;
* student.FatherName = students.FatherName;
* student.MotherName = students.MotherName;
* student.DOB = students.DOB;
* student.Age = students.Age;
* student.Standard = students.Standard;
* student.AddmissionDate = students.AddmissionDate;
* student.CompeletionDate = students.CompeletionDate;*/
var student = _mapper.Map <Students>(students);
_context.Update(student);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentsExists(students.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Student)));
}
return(View());
}
public IActionResult EnrollStudent(EnrollStudentRequest request)
{
try
{
//Check if all required data has been delivered.
if (string.IsNullOrWhiteSpace(request.IndexNumber) || string.IsNullOrWhiteSpace(request.FirstName) || string.IsNullOrWhiteSpace(request.LastName) || string.IsNullOrWhiteSpace(request.Studies))
{
return NotFound("Not enough data");
}
//check if studies from the request exists in the Studies table.
var res =( from stu in _studentContext.Studies where stu.Name.Equals(request.Studies) select stu).ToList();
if (res.Count() == 0) return NotFound("Studies doesnt exist");
var idStudies = res.ToList().First().IdStudy;
//For existing studies, find the latest entry in the Enrollments table with value Semester = 1
var lastEnrollment = (from e in _studentContext.Enrollment where (e.IdStudy.Equals(idStudies)) && (e.Semester == 1) orderby e.IdEnrollment descending select e.IdEnrollment).ToList();
//If such record doesn’t exist, we must insert it with StartDate set as a current date
if (lastEnrollment.Count==0)
{
var max = _studentContext.Enrollment.Max(c => c.IdEnrollment);
Enrollment en = new Enrollment
{
IdEnrollment = max+1,
IdStudy = idStudies,
Semester = 1,
StartDate = DateTime.Now
};
var res2 = _studentContext.Enrollment.Add(en);
}
var maxEnrollment = _studentContext.Enrollment.Max(c => c.IdEnrollment);
//In the next step a new Student must be created.
//Remember about checking if index number provided in the request is not assigned to other student(otherwise return an error).
var res3 = _studentContext.Student.Where(s => s.IndexNumber == request.IndexNumber).Select(s => s.IndexNumber).ToList();
if (res3.Count!=0)
{
return BadRequest("Student with given index already exists");
}
Student s = new Student
{
IndexNumber = request.IndexNumber,
FirstName = request.FirstName,
LastName = request.LastName,
BirthDate = request.Birthdate,
IdEnrollment = maxEnrollment
};
_studentContext.Add(s);
_studentContext.SaveChanges();
}
catch (Exception exc)
{
return BadRequest(exc);
}
return Ok("Enrollment successfull");
}
public IActionResult CreateUser([FromBody] Users user)
{
try
{
if (user == null)
{
return(BadRequest("User object is null"));
}
if (!ModelState.IsValid)
{
return(BadRequest("Invalid model object"));
}
user.Id = Guid.NewGuid();
_context.Add(user);
_context.SaveChanges();
return(StatusCode(201));
}
catch (Exception ex)
{
return(StatusCode(500, $"Internal server error: {ex}"));
}
}
public async Task <ActionResult> Add(Student student, IFormFile FileUrl)
{
if (ModelState.IsValid)
{
student.Department = StudentContext.Department.Where(x => x.Id == student.DepartmentId).FirstOrDefault();
//StudentContext.Students.Add(student);
string dirPath = Path.Combine(_hostingEnvironment.WebRootPath, @"uploads\");
var fileName = Guid.NewGuid().ToString().Replace("-", "") + "_" + FileUrl.FileName;
using (var fileStream = new FileStream(dirPath + fileName, FileMode.Create))
{
await FileUrl.CopyToAsync(fileStream);
}
student.ImageUrl = fileName;
StudentContext.Add(student);
await StudentContext.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewData["DepartmentId"] = new SelectList(StudentContext.Department, "Id", "Dname", student.DepartmentId);
return(View(student));
}
public void Add(Student item)
{
using (StudentContext db = new StudentContext())
{
db.Add(item);
db.SaveChanges();
}
}
public IActionResult putStudent(Entities.Student student)
{
_StudentContext.Add <Entities.Student>(student);
_StudentContext.SaveChanges();
return(Ok(student));
}
public IActionResult Create(Student student)
{
if (ModelState.IsValid)
{
_std.Add(student);
_std.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("ID,Name,Age,Birthday")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("Id,Name")] Department department)
{
if (ModelState.IsValid)
{
_context.Add(department);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(department));
}
public async Task <IActionResult> Create([Bind("Id,Name")] University university)
{
if (ModelState.IsValid)
{
_context.Add(university);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(university));
}
public async Task <IActionResult> Create([Bind("Student_Id,First_Name,Last_Name,Date_of_Birth,Age,Gender,Major_Id")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
//updated token
private async Task AddTokenLog(string email, string token, Role role)
{
var tokenRecord = _context.TokenLogs.SingleOrDefault(i => i.Email == email);
if (tokenRecord != null)
{
tokenRecord.Token = token;
_context.TokenLogs.Update(tokenRecord);
await _context.SaveChangesAsync();
}
TokenLog tokenLog = new TokenLog
{
Email = email,
Token = token,
IsAdmin = role == Role.Admin ? true : false
};
_context.Add(tokenLog);
await _context.SaveChangesAsync();
}
public async Task <IActionResult> Create([Bind("Id,Name,Designation")] Faculty faculty)
{
if (ModelState.IsValid)
{
_context.Add(faculty);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(faculty));
}
public async Task <IActionResult> Create([Bind("RollNumber,FirstName,LastName,Phone,Email,Address,Gender,Status")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("id,firstName,lastName,studentStatus,userName,isModerator")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("Id,Student_Code,Name,City,Branch,DOB,Gender,Statuts,Created_By,Created_Date,Modified_By,Modified_Date")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("Id,StudentId,Name,Age,District,Province,CourseCode,CourseName")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("Id,Ime,Prezime,BrojDolazaka")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("ID,LastName,FirstMidName,EnrollmentDate")] Student student)
{
if (ModelState.IsValid)
{
_context.Add(student);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(student));
}
public async Task <IActionResult> Create([Bind("Id,Name,SurName,TelNumber")] Parent parent)
{
if (ModelState.IsValid)
{
_context.Add(parent);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(parent));
}
public async Task <IActionResult> Create([Bind("Id,Title,Credits,Code")] Course course)
{
if (ModelState.IsValid)
{
_context.Add(course);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(course));
}
