public ActionResult Post([FromBody] Form form)
{
if (this.ModelState.IsValid)
{
Postulant postulant = fnc.createPostulant(form);
//Aca valida datos y guarda en db
int IdPostulantDb = dbm.InsertPostulant(postulant);
int IdStudyform = fnc.validateIdStudy(form);
int IdStudiesStateform = fnc.validateIdStudyState(form);
Studies studies = fnc.createStudies(form, IdPostulantDb, IdStudyform, IdStudiesStateform);
dbm.InsertStudies(studies);
var formString = JsonConvert.SerializeObject(form);
var barray = Encoding.UTF8.GetBytes(formString);
Attached attached = new Attached {
Name = "InitForm.txt",
Link = barray,
IdTypeAttached = 1
};
dbm.InsertAttached(attached, IdPostulantDb);
return(Ok());
}
else
{
return(BadRequest());
}
}
public Studies GetStudiesByName(string name)
{
using (var client = new SqlConnection(
"Data Source=db-mssql;Initial Catalog=s17428;Integrated Security=True"))
using (var cmd = new SqlCommand())
{
cmd.Connection = client;
cmd.CommandText = @"SELECT IdStudy, Name
FROM Studies AS studies
WHERE Name = @name";
cmd.Parameters.AddWithValue("name", name);
client.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var studies = new Studies();
studies.IdStudy = Convert.ToInt32(reader["IdStudy"]);
studies.Name = reader["Name"].ToString();
return(studies);
}
return(null);
}
}
public ActionResult OnGet([FromRoute] long id)
{
Study = Studies.GetStudy(id);
if (Study == null)
{
return(NotFound());
}
var studyIdentity = Study.Id;
var consentedSubjects = Subjects.GetConsentedSubjects(studyIdentity);
Logger.LogDebug(
"Found {count} consentedPeople - {consentedPeopleIds}",
consentedSubjects.Length,
consentedSubjects);
if (!Search)
{
SearchGroups = GetDefinedSearchGroups();
return(Page());
}
var mergedSearchGroups = GetSearchGroupsAndValues();
SearchGroups = mergedSearchGroups;
return(DoSearch());
}
/// <summary>
/// Load all user datas from the firebase db.
/// </summary>
/// <returns></returns>
private async Task GetUserDataAsync()
{
try
{
var documents = await CrossCloudFirestore.Current
.Instance
.GetCollection(QStudy.CollectionPath)
.GetDocumentsAsync();
IEnumerable <StudiesToParticipate> myModel = documents.ToObjects <StudiesToParticipate>();
foreach (var study in myModel)
{
if (!study.Team.Equals("System") && (!(study.EndDate < DateTime.Now) | (study.EndDate == DateTime.MinValue)))
{
if (CurrentUser.Instance.User.ActiveStudies.Contains(study.Id))
{
study.Paricipate = true;
}
Studies.Add(study);
}
}
}
catch (Exception e)
{
Crashes.TrackError(e);
}
}
IEnumerable <Studies> IDbService.GetStudies()
{
List <Studies> _studiesesList = new List <Studies>();
using (_connection = new SqlConnection(connection_string))
using (var command = new SqlCommand())
{
_connection.Open();
command.Connection = _connection;
command.CommandText = "Select * from Studies";
var dr = command.ExecuteReader();
while (dr.Read())
{
var studies = new Studies();
studies.Name = dr["Name"].ToString();
studies.IdStudy = int.Parse(dr["IdStudy"].ToString());
_studiesesList.Add(studies);
}
dr.Close();
_studieses = _studiesesList;
}
return(_studieses);
}
public async Task <IActionResult> Edit(int id, [Bind("IdStudy,Name")] Studies studies)
{
if (id != studies.IdStudy)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(studies);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudiesExists(studies.IdStudy))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(studies));
}
public Studies GetStudies(String studies)
{
using (var conection = new SqlConnection(_connection))
using (var command = new SqlCommand())
{
command.Connection = conection;
command.CommandText = @"SELECT idstudy, Name FROM Studies WHERE Name = @name";
command.Parameters.AddWithValue("name", studies);
conection.Open();
try
{
var dr = command.ExecuteReader();
dr.Read();
var _study = new Studies
{
IdStudy = int.Parse(dr["idstudy"].ToString()),
Name = dr["name"].ToString()
};
return(_study);
}
catch (Exception ex)
{
return(null);
}
}
}
public IActionResult GetStudent(string IndexNumber)
{
Student student;
Enrollment enrollment = new Enrollment();
Studies studies = new Studies();
List <Object> query = new List <object>();
using (SqlConnection conn = new SqlConnection(Conncetion))
using (SqlCommand command = new SqlCommand()){
command.Connection = conn;
command.CommandText = "select Student.idEnrollment, semester, name, startdate from Enrollment inner join student on Enrollment.IdEnrollment = Student.IdEnrollment inner join Studies on Enrollment.idStudy = Studies.idStudy where Student.IndexNumber = @index";
command.Parameters.AddWithValue("index", IndexNumber);
conn.Open();
var sqlReader = command.ExecuteReader();
if (sqlReader.Read())
{
enrollment.IdEnrollment = Int32.Parse(sqlReader["IdEnrollment"].ToString());
enrollment.Semester = Int32.Parse(sqlReader["Semester"].ToString());
studies.Name = sqlReader["Name"].ToString();
enrollment.Startdate = sqlReader["StartDate"].ToString();
query.Add(enrollment.IdEnrollment);
query.Add(enrollment.Semester);
query.Add(studies.Name);
query.Add(enrollment.Startdate);
return(Ok(query));
}
sqlReader.Close();
return(NotFound());
}
}
/// <inheritdoc />
public WhenRecordingConsent_ForANonExistantStudy()
{
var nonExistentStudyId = -Study.Id;
A.CallTo(() => Studies.GetStudy(nonExistentStudyId)).Returns(null);
RecordConsent(A.Dummy <IIdentifierValueDto>(), A.Dummy <DateTime>(), studyId: nonExistentStudyId);
}
/// <summary>
/// Finds the spatial registration objects for this patient that satisfy a predicate
/// </summary>
/// <param name="predicate">A predicate for the search</param>
/// <returns>All of the patient spatial registration objects that satisfy the predicate or null if the
/// predicate was null or no patient spatial registration object satisfies the predicate</returns>
/// <example>This example shows how to find spatial registration objects for a patient that transform to or
/// from a specific frame of reference:
/// <code>
/// using ProKnow;
/// using System.Threading.Tasks;
///
/// var pk = new ProKnowApi("https://example.proknow.com", "./credentials.json");
/// var patientItem = await pk.Patients.CreateAsync("Clinical");
/// var frameOfReferenceUid = "1.2.246.352.221.5093062159960566210763150553104377477";
/// var sroSummaries = patientItem.FindSros(s => s.TargetFrameOfReferenceUid == frameOfReferenceUid ||
/// s.SourceTargetFrameOfReferenceUid == frameOfReferenceUid);
/// </code>
/// </example>
/// <example>This example shows how to find all spatial registration objects for a patient:
/// <code>
/// using ProKnow;
/// using System.Threading.Tasks;
///
/// var pk = new ProKnowApi("https://example.proknow.com", "./credentials.json");
/// var patientItem = await pk.Patients.CreateAsync("Clinical");
/// var sroSummaries = patientItem.FindSros(s => true);
/// </code>
/// </example>
public IList <SroSummary> FindSros(Func <SroSummary, bool> predicate)
{
if (predicate == null)
{
return(new List <SroSummary>());
}
return(Studies.SelectMany(study => study.Sros.Where(sro => predicate(sro))).ToList());
}
public IActionResult PromoteStudents(PromoteStudentsRequest request)
{
Studies study = (from st in dbContext.Studies
where st.Name == request.Studies
select st).First();
Enrollment thisEnrollment = (from en in dbContext.Enrollment
where en.Semester == request.Semester
where en.IdStudy == study.IdStudy
select en).First();
Enrollment nextEnrollment = (from en in dbContext.Enrollment
where en.Semester == request.Semester + 1
where en.IdStudy == study.IdStudy
select en).FirstOrDefault();
if (nextEnrollment == null)
{
Enrollment lastEnrollment = (from enrollments in dbContext.Enrollment
orderby enrollments.IdEnrollment descending
select enrollments).FirstOrDefault();
int idEnrollment;
if (lastEnrollment == null)
{
idEnrollment = 1;
}
else
{
idEnrollment = lastEnrollment.IdEnrollment + 1;
}
nextEnrollment = new Enrollment
{
IdStudy = study.IdStudy,
Semester = request.Semester + 1,
IdEnrollment = idEnrollment,
StartDate = DateTime.Now
};
dbContext.Add(nextEnrollment);
}
var students = (from st in dbContext.Student
where st.IdEnrollment == thisEnrollment.IdEnrollment
select st);
foreach (Student st in students)
{
st.IdEnrollment = nextEnrollment.IdEnrollment;
dbContext.Add(st);
}
dbContext.SaveChanges();
return(Created("/enrollments/", request));
}
public async Task <IActionResult> EnrollStudent(EnrollStudentRequest request)
{
if (ModelState.IsValid == false)
{
IEnumerable <ModelError> allErrors = ModelState.Values.SelectMany(v => v.Errors);
return(BadRequest(allErrors));
}
Studies studies = await Context.Studies.FirstOrDefaultAsync(stud => stud.Name == request.Studies);
if (studies == null)
{
return(NotFound("Studia nie istnieją"));
}
Enrollment enrollment = await Context.Enrollment.FirstOrDefaultAsync(en => en.IdStudy == studies.IdStudy && en.Semester == 1);
if (enrollment == null)
{
enrollment = new Enrollment {
Semester = 1, IdStudy = studies.IdStudy, StartDate = DateTime.Now
};
Context.Add(enrollment);
}
Student student = await Context.Student.FirstOrDefaultAsync(s => s.IndexNumber == request.IndexNumber);
if (studies != null)
{
return(BadRequest("Student o takim indeksie już istnieje w bazie danych."));
}
student = new Student
{
IndexNumber = request.IndexNumber,
FirstName = request.FirstName,
LastName = request.LastName,
BirthDate = request.Birthdate,
IdEnrollment = enrollment.IdEnrollment
};
Context.Add(student);
if (await Context.SaveChangesAsync() == 0)
{
return(StatusCode(500, "Błąd podczas zapisu danych do bazy."));
}
EnrollStudentResponse result = new EnrollStudentResponse
{
IndexNumber = student.IndexNumber,
FirstName = student.FirstName,
LastName = student.LastName,
Semester = enrollment.Semester,
StartDate = enrollment.StartDate,
};
return(StatusCode(201, result));
}
private Enrollment PrepareNewEnrollment(Studies studies)
{
_sqlCommand.CommandText = InsertFirstSemesterEnrollmentForStudiesQuery;
_sqlCommand.Parameters.AddWithValue("EnrollmentDate", _enrollmentDate);
if (_sqlCommand.ExecuteNonQuery() == 0)
{
throw new SqlInsertException("Błąd podczas tworzenia nowego wpisu w tablicy \"Enrollment\"!");
}
return(InsertedEnrollment(studies.Name));
}
public void FilterAndJoin()
{
//filter subjects by arms
if (Arms.Any())
{
Subjects = Subjects.FindAll(s => Arms.Select(a => a.Id).Contains(s.StudyArmId)).ToList();
}
Debug.WriteLine(Subjects.Count, " AFTER ARMS");
//filter subjects by studies
if (Studies.Any())
{
Subjects = Subjects.FindAll(subj => Studies.Select(st => st.Id).Contains(subj.StudyId)).ToList();
}
Debug.WriteLine(Subjects.Count, " AFTER Studies");
//filter subjects by subCharacteristics
if (SubjChars.Any())
{
Subjects = Subjects.FindAll(s => SubjChars.Select(sc => sc.SubjectId).Contains(s.Id)).ToList();
}
Debug.WriteLine(Subjects.Count, " AFTER SubjChars");
//filter by visits
//TODO
//TODO : WILL RETRIEVE SUBJECTS THAT HAVE SAME UNIQUE IDS ACROSS PROJECTS (i.e. need to load observations to Mongo with
//TODO: DB subjectId
//filter observations for filtered subjects
Observations = Observations?.FindAll(o => Subjects.Select(s => s.UniqueSubjectId).Contains(o.USubjId));
//filter subjects by selected observations
if (Observations.Any() && ObservationsFiltered)
{
Subjects = Subjects.FindAll(s => Observations.Select(o => o.USubjId).Contains(s.UniqueSubjectId));
}
Debug.WriteLine(Subjects.Count, " AFTER syncing with observations");
//FILTER SAMPLES BY SELECTED AND FILTERED SAMPLE CHARACTERISTICS
if (SampleCharacteristics.Any())
{
Samples = Samples.FindAll(s => SampleCharacteristics.Select(sc => sc.SampleId).Contains(s.Id)).ToList();
}
//TODO: TEMP FILTERING BY COLLECTION STUDY DAY
//SYNCHRONIZE SAMPLES AND SUBJECTS
if (Samples.Any())
{
Samples = Samples.FindAll(s => Subjects.Select(sc => sc.Id).Contains(s.SubjectId)).ToList();
Subjects = Subjects.FindAll(sb => Samples.Select(sp => sp.SubjectId).Contains(sb.Id)).ToList();
}
}
private (StudyIdentity studyIdentity, IActionResult actionResult) GetStudy(long studyId)
{
var study = Studies.GetStudy(studyId);
if (study != null)
{
return(study.Id, null);
}
Logger.LogWarning("Study#{studyId} not found", studyId);
return(study.Id, NotFound());
}
private void AddStudy()
{
Study s = new Study();
s.Practice = DesktopApplication.CurrentPratice;
((Patient)Item).Studies.Add(s);
StudyViewModel vm = new StudyViewModel(s);
Studies.Add(vm);
SelectedStudy = vm;
}
public Student(string fname, string lname, string sname, string mode, string idx, string bd, string email, string mname, string faname)
{
this.fname = fname;
this.lname = lname;
this.indexNumber = idx;
this.birthdate = bd;
this.email = email;
this.motherName = mname;
this.fatherName = faname;
studies = new Studies(sname, mode);
}
//STUDIES
public void InsertStudies(Studies studies)
{
var sql = "INSERT INTO Studies (IdStudy, Institution, Career, IdPostulant, Year, IdStudiesState) VALUES (@IdStudy, @Institution, @Career, @IdPostulant, @Year, @IdStudiesState)";
using (var conn = new SqlConnection(connStr))
{
conn.Open();
conn.Execute(sql, studies);
conn.Close();
}
}
public async Task <IActionResult> Create([Bind("IdStudy,Name")] Studies studies)
{
if (ModelState.IsValid)
{
_context.Add(studies);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(studies));
}
public Student(string firstName, string name, string studiesName, string studiesMode, string index, DateTime dateOfBirth, string email, string mothersFName, string fathersFName)
{
this.firstName = firstName;
this.name = name;
study = new Studies(studiesName, studiesMode);
this.index = index;
this.dateOfBirth = dateOfBirth;
this.email = email;
this.mothersFName = mothersFName;
this.fathersFName = fathersFName;
}
public void GenerateNames()
{
Studies = Studies.OrderBy(s => s.ID).ToList();
int i = 1;
foreach (DICOMStudy s in Studies)
{
StudyDictionary.Add(s.ID, string.Format("{0}_{1}", "Study", i));
i++;
}
}
public IActionResult upgradeStudent([FromBody] Studies studie)
{
if (studie.Studiess == null || studie.Semester == null)
{
return(BadRequest());
}
ObjectResult ob = new ObjectResult(new SqlServerDbService().PromoteStudents(studie.Semester, studie.Studiess));
ob.StatusCode = 201;
return(ob);
}
private Enrollment GetEnrollmentForNewStudent(Studies studies)
{
_sqlCommand.CommandText = FirstSemesterEnrollmentForStudiesQuery;
using var sqlDataReader = _sqlCommand.ExecuteReader();
if (sqlDataReader.Read())
{
return(SqlDataReaderToEnrollment(sqlDataReader, _enrollRequest.Studies));
}
sqlDataReader.Close();
return(PrepareNewEnrollment(studies));
}
//POST api/Management/Study
public ActionResult InsertStudies([FromBody] Studies studies)
{
if (this.ModelState.IsValid)
{
dbm.InsertStudies(studies);
return(Ok());
}
else
{
return(BadRequest());
}
}
public ActionResult Studies(int id, StudiesInformationViewModel studiesViewModel)
{
if (ModelState.IsValid)
{
Studies studie = new Studies
{
School = studiesViewModel.School,
Idstudylevel = studiesViewModel.Idstudylevel,
Obtainedtitle = studiesViewModel.Obtainedtitle,
Idacademicstate = studiesViewModel.Idacademicstate,
Startdate = studiesViewModel.Startdate,
Enddate = studiesViewModel.Enddate,
Idperiodicity = studiesViewModel.Idperiodicity,
Idcandidate = HttpContext.Session.GetInt32("IdCandidate")
};
if (id > 0)
{
studie.Idstudies = id;
db.Studies.Update(studie);
}
else
{
db.Studies.Add(studie);
}
db.SaveChanges();
var uploads = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot\\uploads");
var fileName = Path.GetFileName(studiesViewModel.File.FileName);
var filePath = Path.Combine(uploads, fileName);
using (FileStream file = new FileStream(filePath, FileMode.Create))
{
studiesViewModel.File.CopyTo(file);
file.Close();
}
Document document = new Document
{
Idcandidate = HttpContext.Session.GetInt32("IdCandidate"),
Url = $"\\uploads\\{fileName}",
Iddocumenttype = (int)DocumentTypeEnum.CertificadoEstudio,
};
db.Document.Add(document);
db.SaveChanges();
return(RedirectToAction("StudyList"));
}
return(View(studiesViewModel));
}
public IEnumerable <Studies> UpdateStudies(Studies studies)
{
var sql = "UPDATE Studies SET IdStudy = @IdStudy, Institution = @Institution, Career = @Career, IdStudiesState = @IdStudiesState Where Id = @Id";
using (var conn = new SqlConnection(connStr))
{
conn.Open();
conn.Execute(sql, studies);
conn.Close();
}
return(this.GetStudies(studies.IdPostulant));
}
public Studies createStudies(Form form, int IdPostulantDb, int IdStudyform, int IdStudiesStateform)
{
Studies studies = new Studies
{
IdStudy = IdStudyform,
Institution = form.Institution,
Career = form.Career,
IdPostulant = IdPostulantDb,
IdStudiesState = IdStudiesStateform
};
return(studies);
}
public override bool Equals(object obj)
{
if (obj == null)
{
return(false);
}
if (typeof(Studies).IsInstanceOfType(obj))
{
Studies nStud = (Studies)obj;
return(nStud.name == this.name);
}
return(false);
}
//PUT api/Management/Study/Modif
public IEnumerable <Studies> UpdateStudies([FromBody] Studies studies)
{
if (studies.Id != 0)
{
return(dbm.UpdateStudies(studies));
}
else
{
IEnumerable <Studies> study = null;
study.Append(studies);
return(study);
}
}
public Studies createStudiesget(Studiesget studyget, int IdStudyform, int IdStudiesStateform)
{
Studies studies = new Studies
{
IdStudy = IdStudyform,
Institution = studyget.Institution,
Career = studyget.Career,
IdPostulant = studyget.IdPostulant,
Year = studyget.Year,
IdStudiesState = IdStudiesStateform
};
return(studies);
}
