static void Main() { //Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentDbContext, Configuration>()); var db = new StudentDbContext(); var student = db.Students.Where(s => s.Id == 1).FirstOrDefault(); var course = db.Courses.Where(c => c.Id == 1).FirstOrDefault(); student.Courses.Add(course); course.Students.Add(student); db.SaveChanges(); }
public Project AddProject(Project _project) { dbContext.Projects.Add(_project); dbContext.SaveChanges(); return(_project); }
public Salary AddSalary(Salary _salary) { dbContext.Salaries.Add(_salary); dbContext.SaveChanges(); return(_salary); }
public int Add(Student aStudent) { db.Students.Add(aStudent); return(db.SaveChanges()); }
public async Task <IActionResult> UpdateWithTracking(int id, Student student) { var existingStudent = await _context.Students.FindAsync(id); if (id != student.StudentId) { return(BadRequest()); } var existingStudentData = new Student() { FirstName = existingStudent.FirstName, LastName = existingStudent.LastName, StudentAge = existingStudent.StudentAge, DOB = existingStudent.DOB }; var trackRecordData = new TrackRecord() { UpdatedColumn = "", OldValue = "", UpdatedValue = "", UpdatedTime = new TimeSpan() }; if (existingStudentData.FirstName != student.FirstName) { student.IsUpdated = true; trackRecordData.UpdatedColumn = "FirstName"; trackRecordData.OldValue = existingStudentData.FirstName; trackRecordData.UpdatedValue = student.FirstName; trackRecordData.UpdatedTime = DateTime.Now.TimeOfDay; } else if (existingStudentData.LastName != student.LastName) { student.IsUpdated = true; trackRecordData.UpdatedColumn = "LastName"; trackRecordData.OldValue = existingStudentData.LastName; trackRecordData.UpdatedValue = student.LastName; trackRecordData.UpdatedTime = DateTime.Now.TimeOfDay; } else if (existingStudentData.StudentAge != student.StudentAge) { student.IsUpdated = true; trackRecordData.UpdatedColumn = "StudentAge"; trackRecordData.OldValue = Convert.ToString(existingStudentData.StudentAge); trackRecordData.UpdatedValue = Convert.ToString(student.StudentAge); trackRecordData.UpdatedTime = DateTime.Now.TimeOfDay; } else if (existingStudentData.DOB != student.DOB) { student.IsUpdated = true; trackRecordData.UpdatedColumn = "DOB"; trackRecordData.OldValue = Convert.ToString(existingStudentData.DOB); trackRecordData.UpdatedValue = Convert.ToString(student.DOB); trackRecordData.UpdatedTime = DateTime.Now.TimeOfDay; } _context.TrackRecords.Add(trackRecordData); _context.Entry(existingStudent).State = EntityState.Detached; _context.Entry(student).State = EntityState.Modified; _context.SaveChanges(); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudentExists(id)) { return(NotFound()); } else { throw; } } return(Ok()); }
public ActionResult Create(Student student) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public Programme AddProgramme(Programme _programme) { dbContext.Programmes.Add(_programme); dbContext.SaveChanges(); return(_programme); }
public void AddStudent(Student student) { student.Id = 0; _context.Students.Add(student); _context.SaveChanges(); }
static void Main() { Database.SetInitializer(new MigrateDatabaseToLatestVersion <StudentDbContext, Configuration>()); var db = new StudentDbContext(); var student = new Student { Name = "Djordjano", FacultyNumber = 1313, Course = new List <Course> { new Course { Name = "Music", Description = "Modern music" }, new Course { Name = "Dance", Description = "Modern dancing" }, new Course { CourseId = 6 } } }; var course = new Course { Name = "Mathematics Fundamentals Second Part", Description = "All secrets about mathematics", Homeworks = new List <Homework> { new Homework { Content = "Task 5", TimeSent = DateTime.Now }, new Homework { Content = "Task 6", TimeSent = DateTime.Now } } }; db.Students.Add(student); // db.Courses.Add(course); try { db.SaveChanges(); } catch (DbEntityValidationException ex) { } Console.WriteLine(db.Students.Count()); }
public EnrollmentResponse PromoteStudentsEntity(PromoteStudentsRequest promoteStudentsRequest) { var semester = promoteStudentsRequest.Semester; var studiesName = promoteStudentsRequest.Studies; var context = new StudentDbContext(); var studies = context.Studies .FirstOrDefault(stud => studiesName.Equals(stud.Name)); if (studies == null) { throw new ResourceNotFoundException("Studies with name = " + studiesName + " dont exist"); } var enrollment = context.Enrollment .FirstOrDefault(enroll => semester.Equals(enroll.Semester) && studies.IdStudy.Equals(enroll.IdStudy)); if (enrollment == null) { throw new ResourceNotFoundException("Enrollment with idStudies = " + studies.IdStudy + " and semester = " + semester + " dont exist"); } var enrollmentNew = context.Enrollment.FirstOrDefault(enrollment => (semester + 1).Equals(enrollment.Semester) && studies.IdStudy.Equals(enrollment.IdStudy)); if (enrollmentNew == null) { enrollmentNew = new Enrollment { IdEnrollment = context.Enrollment.Select(enroll => enroll.IdEnrollment) .OrderByDescending(i => i).First() + 1, Semester = semester + 1, IdStudy = studies.IdStudy, StartDate = DateTime.Today }; context.Enrollment.Add(enrollmentNew); } var students = context.Student.Where(student => enrollment.IdEnrollment.Equals(student.IdEnrollment)) .ToList(); students.ForEach(student => { student.IdEnrollment = enrollmentNew.IdEnrollment; }); context.SaveChanges(); var response = new EnrollmentResponse { Semester = enrollmentNew.Semester, IdStudy = enrollmentNew.IdStudy, IdEnrollment = enrollmentNew.IdEnrollment, StartDate = enrollmentNew.StartDate.ToString("yyyy-MM-dd") }; return(response); }
public EnrollmentResponse EnrollNewStudentEntity(EnrollmentStudentRequest enrollmentStudentRequest) { var context = new StudentDbContext(); var studies = context.Studies .FirstOrDefault(stud => enrollmentStudentRequest.Studies.Equals(stud.Name)); if (studies == null) { throw new ResourceNotFoundException("Studies with name = " + enrollmentStudentRequest.Studies + " dont exist"); } var enrollment = context.Enrollment.FirstOrDefault(enroll => 1.Equals(enroll.Semester) && studies.IdStudy.Equals(enroll.IdStudy)); var enrollmentResponse = new EnrollmentResponse(); if (enrollment == null) { var enrollmentNew = new Enrollment { IdEnrollment = context.Enrollment.Select(enroll => enroll.IdEnrollment).OrderByDescending(i => i).First() + 1, Semester = 1, StartDate = DateTime.Now, IdStudy = studies.IdStudy }; context.Enrollment.Add(enrollmentNew); enrollmentResponse.IdEnrollment = enrollmentNew.IdEnrollment; enrollmentResponse.Semester = enrollmentNew.Semester; enrollmentResponse.IdStudy = enrollmentNew.IdStudy; enrollmentResponse.StartDate = enrollmentNew.StartDate.ToString("yyyy-MM-dd"); } else { enrollmentResponse.IdEnrollment = enrollment.IdEnrollment; enrollmentResponse.Semester = enrollment.Semester; enrollmentResponse.IdStudy = enrollment.IdStudy; enrollmentResponse.StartDate = enrollment.StartDate.ToString("yyyy-MM-dd"); } if (context.Student.Any(student => enrollmentStudentRequest.Index.Equals(student.IndexNumber))) { throw new BadRequestException("Student Index number not unique"); ; } var salt = PasswordUtils.GenerateSalt(); context.Student.Add(new Student { IndexNumber = enrollmentStudentRequest.Index, FirstName = enrollmentStudentRequest.FirstName, LastName = enrollmentStudentRequest.LastName, BirthDate = enrollmentStudentRequest.BirthDate, IdEnrollment = enrollmentResponse.IdEnrollment, Password = PasswordUtils.CreateSaltedPasswordHash(enrollmentStudentRequest.Password, salt), Salt = salt }); context.SaveChanges(); return(enrollmentResponse); }
public StudentBatch AddStdBatch(StudentBatch _studentBatch) { dbContext.StudentBatches.Add(_studentBatch); dbContext.SaveChanges(); return(_studentBatch); }
public bool EnrollStudent(EnrollStudentRequest request) { try { var studies = _context.Studies.Find(request.Studies); var student = _context.Student.Find(request.IndexNumber); //sprawdzanie czy jest dany student if (student == null) { var tmp = new Student(); tmp.IndexNumber = request.IndexNumber; tmp.FirstName = request.FirstName; tmp.LastName = request.LastName; tmp.BirthDate = DateTime.Parse(request.BirthDate); _context.Add <Student>(tmp); _context.Student.Add(tmp); } //sprawdzenie czy sa dane studia if (studies == null) { return(false); } //sprawdzanie czy jest dany enrollment var tmpEnrol = _context.Enrollments.Find(request.Studies); if (tmpEnrol == null) { tmpEnrol = new Enrollment(); tmpEnrol.IdEnrollment = _context.Enrollments.LastOrDefault().IdEnrollment + 1; tmpEnrol.Semester = 1; tmpEnrol.IdStudy = _context.Studies.Find(request.Studies).idStudy; tmpEnrol.StartDate = DateTime.Now; _context.Add <Enrollment>(tmpEnrol); } _context.SaveChanges(); return(true); }catch (Exception ex) { Console.WriteLine(ex.Message); } /* * using (var con = new SqlConnection(dbName)) * { * using (var com = new SqlCommand()) * { * com.Connection = con; * con.Open(); * SqlTransaction transaction = con.BeginTransaction(); * * try * { * // SPRAWDZANIE CZY PODANE STUDIA ISTNIEJA * com.CommandText = "SELECT * FROM Studies WHERE name = name"; * com.Parameters.AddWithValue("name", request.Studies); * com.Transaction = transaction; * SqlDataReader reader = com.ExecuteReader(); * * if (!reader.HasRows) * { * return false; * } * * // DODAWANIE DO ENROLLMENT * com.CommandText = "SELECT * FROM enrollment e INNER JOIN studies s on s.idstudy = e.idstudy WHERE semester = 1 AND name = sname"; * com.Parameters.AddWithValue("sname", request.Studies); * * if (!reader.HasRows) * { * com.CommandText = "INSERT INTO enrollment(idenrollment, semester, idstudy, startdate)" + * "VALUES((select Max(idEnrollment)+1 from enrollment), 1, SELECT idstudy FROM Studies WHERE name = sname), GETDATE())"; * com.Parameters.AddWithValue("sname", request.Studies); * * com.ExecuteNonQuery(); * } * reader.Close(); * * // DODAWANIE NOWEGO STUDENTA * // zmienne sa z @ bo inaczej SQL krzyczal ze mu nie pasuje * com.CommandText = "SELECT * FROM Student WHERE indexnumber = @es"; * com.Parameters.AddWithValue("@es", request.IndexNumber); * reader = com.ExecuteReader(); * * if (!reader.HasRows) * { * reader.Close(); * com.CommandText = "INSERT INTO Student(indexnumber, firstname, lastname, birthdate, idenrollment)" + * "values(@es, @firstname, @lastname, @birthdate, (SELECT idenrollment FROM enrollment e INNER JOIN Studies s on e.idstudy = s.idstudy WHERE semester = 1 AND s.name = @sname))"; * com.Parameters.AddWithValue("@firstname", request.FirstName); * com.Parameters.AddWithValue("@lastname", request.LastName); * com.Parameters.AddWithValue("@birthdate", DateTime.Parse(request.BirthDate)); * * com.ExecuteNonQuery(); * reader.Close(); * } * else * { * Console.WriteLine("insert"); * return false; * } * * transaction.Commit(); * transaction.Dispose(); * * return true; * } * catch (Exception e) * { * try * { * transaction.Rollback(); * } * catch (Exception ex) * { * Console.WriteLine("Error at Rollback! " + ex.Message); * } * * return false; * } * } * } */ return(false); }
public Guarantor AddGuarantor(Guarantor _guarantor) { _studentDbContext.Guarantors.Add(_guarantor); _studentDbContext.SaveChanges(); return(_guarantor); }
public int Commit() { return(_context.SaveChanges()); }
public IActionResult Create(Student st) { db.Students.Add(st);//new Student{FirstName="Claus", LastName = "Bove", Age = 33}); db.SaveChanges(); return(View()); }
public EmploymentDetails AddEmpDetails(EmploymentDetails _employmentDetails) { dbContext.EmploymentDetails.Add(_employmentDetails); dbContext.SaveChanges(); return(_employmentDetails); }
public async Task <HttpResponseMessage> MediaUpload() { // Check if the request contains multipart/form-data. try { if (!Request.Content.IsMimeMultipartContent()) { throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType); } var provider = await Request.Content.ReadAsMultipartAsync <InMemoryMultipartFormDataStreamProvider>(new InMemoryMultipartFormDataStreamProvider()); NameValueCollection formData = provider.FormData; IList <HttpContent> files = provider.Files; HttpContent file1 = files[0]; var thisFileName = file1.Headers.ContentDisposition.FileName.Trim('\"'); string filename = String.Empty; Stream input = await file1.ReadAsStreamAsync(); string directoryName = String.Empty; string URL = String.Empty; string tempDocUrl = WebConfigurationManager.AppSettings["DocsUrl"]; if (formData["TutorialName"] != string.Empty && formData["StudentId"] != "") { var path = HttpRuntime.AppDomainAppPath; directoryName = System.IO.Path.Combine(path, "ClientDocument"); filename = System.IO.Path.Combine(directoryName, thisFileName); //Deletion exists file if (File.Exists(filename)) { File.Delete(filename); } string DocsPath = tempDocUrl + "/" + "ClientDocument" + "/"; URL = DocsPath + thisFileName; Tutorial tutorial = new Tutorial() { FileLocation = URL, StudentId = Convert.ToInt32(formData["StudentId"]), TutorialName = formData["TutorialName"], FileName = thisFileName }; using (StudentDbContext db = new StudentDbContext()) { db.Tutorials.Add(tutorial); db.SaveChanges(); } } else { var res = Request.CreateResponse(HttpStatusCode.NoContent, "Please fill form with correct data"); res.Headers.Add("DocsUrl", URL); return(res); } //Directory.CreateDirectory(@directoryName); using (Stream file = File.OpenWrite(filename)) { input.CopyTo(file); //close file file.Close(); } var response = Request.CreateResponse(HttpStatusCode.OK, URL); response.Headers.Add("DocsUrl", URL); return(response); } catch (Exception ex) { var response = Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message); return(response); } }