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)); }