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