public bool CreateOrUpdate(CareerDTO career)
{
try
{
using (var ctx = new Utn_SysContext())
{
var oCareer = ctx.Careers.AsNoTracking()
.Where(c => c.Id == career.Id)
.FirstOrDefault();
if (oCareer == null)
{
oCareer = new Careers();
ctx.Careers.Add(oCareer);
}
else
{
ctx.Careers.Attach(oCareer);
}
oCareer.Name = career.Name;
oCareer.Deleted = false;
ctx.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool CancelInternship(string cancelationDescription, int internshipId, int userId, DateTime?cancelationDate)
{
try
{
using (var ctx = new Utn_SysContext())
{
var oInternship = ctx.Interships.Where(i => i.Id.Equals(internshipId)).FirstOrDefault();
if (oInternship.Equals(null))
{
return(false);
}
ctx.Interships.Attach(oInternship);
oInternship.State = "Cancelada";
oInternship.CancellationDescription = cancelationDescription;
oInternship.CancellationDate = cancelationDate ?? DateTime.Now;
oInternship.UserCancelattionId = userId;
ctx.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool CreateOrUpdate(CompanyDTO company)
{
try
{
using (var ctx = new Utn_SysContext())
{
var oCompany = ctx.Companies.AsNoTracking()
.Where(c => c.Id == company.Id)
.FirstOrDefault();
if (oCompany == null)
{
oCompany = new Companies();
ctx.Companies.Add(oCompany);
}
else
{
ctx.Companies.Attach(oCompany);
}
oCompany.Address = company.Address;
oCompany.Cuit = company.Cuit;
oCompany.Email = company.Email;
oCompany.Name = company.Name;
oCompany.Deleted = false;
ctx.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public List <TeacherDTO> GetTeachersByFilter(string filter)
{
using (var ctx = new Utn_SysContext())
{
return(ctx.Teachers.Where(t => t.Names.Contains(filter) || t.Surnames.Contains(filter) || t.File.Contains(filter))
.Select(s => _mapper.Map <TeacherDTO>(s)).ToList());
}
}
public InternshipDTO GetInternshipById(int Id)
{
using (var ctx = new Utn_SysContext())
{
return(_mapper.Map <InternshipDTO>(ctx.Interships.AsNoTracking()
.Where(s => s.Id.Equals(Id))
.FirstOrDefault()));
}
}
public bool Delete(CareerDTO career)
{
using (var ctx = new Utn_SysContext())
{
ctx.Careers.Remove(_mapper.Map <Careers>(career));
ctx.SaveChanges();
return(true);
}
}
public bool Delete(InternshipDTO internship)
{
using (var ctx = new Utn_SysContext())
{
ctx.Interships.Remove(_mapper.Map <Interships>(internship));
ctx.SaveChanges();
return(true);
}
}
public bool Delete(TeacherDTO teacher)
{
using (var ctx = new Utn_SysContext())
{
ctx.Teachers.Remove(_mapper.Map <Teachers>(teacher));
ctx.SaveChanges();
return(true);
}
}
public TeacherDTO GetTeacherById(int Id)
{
using (var ctx = new Utn_SysContext())
{
return(_mapper.Map <TeacherDTO>(ctx.Teachers.AsNoTracking()
.Where(s => s.Id.Equals(Id))
.FirstOrDefault()));
}
}
public bool Delete(CompanyTutorDTO companyTutor)
{
using (var ctx = new Utn_SysContext())
{
ctx.CompanyTutor.Remove(_mapper.Map <CompanyTutor>(companyTutor));
ctx.SaveChanges();
return(true);
}
}
public bool Delete(StudentDTO student)
{
using (var ctx = new Utn_SysContext())
{
ctx.Students.Remove(_mapper.Map <Students>(student));
ctx.SaveChanges();
return(true);
}
}
public CompanyTutorDTO GetCompanyTutorById(int Id)
{
using (var ctx = new Utn_SysContext())
{
return(_mapper.Map <CompanyTutorDTO>(ctx.CompanyTutor
.AsNoTracking()
.Where(s => s.Id.Equals(Id))
.FirstOrDefault()));
}
}
public List <CompanyTutorDTO> GetAllCompanyTutors()
{
using (var ctx = new Utn_SysContext())
{
return(ctx.CompanyTutor.AsNoTracking()
.Select(s =>
_mapper.Map <CompanyTutorDTO>(s)
).ToList());
}
}
public StudentDTO GetStudentById(int Id)
{
using (var ctx = new Utn_SysContext())
{
return(_mapper.Map <StudentDTO>(ctx.Students.AsNoTracking()
.Include(d => d.Career)
.Where(s => s.Id.Equals(Id))
.FirstOrDefault()));
}
}
public List <TeacherDTO> GetAllTeachers()
{
using (var ctx = new Utn_SysContext())
{
return(ctx.Teachers.AsNoTracking()
.Select(s =>
_mapper.Map <TeacherDTO>(s)
).ToList());
}
}
public List <StudentDTO> GetAllStudents()
{
using (var ctx = new Utn_SysContext())
{
return(ctx.Students.AsNoTracking()
.Include(s => s.Career)
.Select(s =>
_mapper.Map <StudentDTO>(s)
).ToList());
}
}
public List <InternshipDTO> GetAllInternships()
{
using (var ctx = new Utn_SysContext())
{
return(ctx.Interships.AsNoTracking().Include(s => s.Student)
.Include(s => s.Company).Include(s => s.CompanyTutor)
.Select(s =>
_mapper.Map <InternshipDTO>(s)
).ToList());
}
}
public UsersDTO Authenticate(UserLoginDTO user)
{
using (var ctx = new Utn_SysContext())
{
return(_mapper.Map <UsersDTO>(
ctx.Users.Where(u => u.Dni == user.Dni && u.Password == user.Password)
.Include(u => u.Rol)
.FirstOrDefault()
));
}
}
public bool CreateOrUpdate(InternshipDTO internship, int userId)
{
try
{
using (var ctx = new Utn_SysContext())
{
var oInternship = ctx.Interships.AsNoTracking()
.Where(c => c.Id == internship.Id)
.FirstOrDefault();
if (oInternship == null)
{
oInternship = new Interships();
ctx.Interships.Add(oInternship);
oInternship.CreatedDate = DateTime.Now;
oInternship.State = "Nueva";
oInternship.UserCreatedId = userId;
}
else
{
ctx.Interships.Attach(oInternship);
oInternship.LastModified = DateTime.Now;
oInternship.UserLasModifiedId = userId;
}
oInternship.DailyHours = internship.DailyHours;
oInternship.WorkAgreement = internship.WorkAgreement;
oInternship.CompanyTutorId = internship.CompanyMentorId;
oInternship.CompanySignatory = internship.CompanySignatory;
oInternship.SalaryWorkAssignment = internship.SalaryWorkAssignment;
oInternship.StartDate = internship.StartDate;
oInternship.EndDate = internship.EndDate;
oInternship.StudentId = internship.StudentId;
oInternship.TaskDescription = internship.TaskDescription;
oInternship.CompanyId = internship.CompanyId;
oInternship.Observations = internship.Observations;
ctx.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool RenoveInternship(int userId, int internshipId, DateTime?renovationDate)
{
using (var ctx = new Utn_SysContext())
{
var oInternship = ctx.Interships.Where(i => i.Id.Equals(internshipId)).FirstOrDefault();
if (oInternship.Equals(null))
{
return(false);
}
ctx.Interships.Attach(oInternship);
oInternship.State = "Renovada";
oInternship.UserRenovationId = userId;
oInternship.RenovationDate = renovationDate ?? DateTime.Now;
ctx.SaveChanges();
return(true);
}
}
public bool CreateOrUpdate(TeacherDTO teacher)
{
try
{
using (var ctx = new Utn_SysContext())
{
var oTeacher = ctx.Teachers.AsNoTracking()
.Where(c => c.Id == teacher.Id)
.FirstOrDefault();
if (oTeacher == null)
{
oTeacher = new Teachers();
ctx.Teachers.Add(oTeacher);
}
else
{
ctx.Teachers.Attach(oTeacher);
}
oTeacher.Names = teacher.Names;
oTeacher.Surnames = teacher.Surnames;
oTeacher.Email = teacher.Email;
oTeacher.Birthdate = teacher.Birthdate;
oTeacher.Cuil = teacher.Cuil;
oTeacher.Dni = teacher.Dni;
oTeacher.Deleted = false;
oTeacher.Address = teacher.Address;
ctx.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool CreateOrUpdate(StudentDTO student)
{
try
{
using (var ctx = new Utn_SysContext())
{
var oStudent = ctx.Students.AsNoTracking()
.Where(c => c.Id == student.Id)
.FirstOrDefault();
if (oStudent == null)
{
oStudent = new Students();
ctx.Students.Add(oStudent);
}
else
{
ctx.Students.Attach(oStudent);
}
oStudent.Names = student.Names;
oStudent.Surnames = student.Surnames;
oStudent.Email = student.Email;
oStudent.Birthdate = student.Birthdate;
oStudent.Cuil = student.Cuil;
oStudent.Dni = student.Dni;
oStudent.Deleted = false;
oStudent.Address = student.Address;
ctx.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public bool CreateOrUpdate(CompanyTutorDTO companyTutor)
{
try
{
using (var ctx = new Utn_SysContext())
{
var oCompanyTutor = ctx.CompanyTutor.AsNoTracking()
.Where(c => c.Id == companyTutor.Id)
.FirstOrDefault();
if (oCompanyTutor == null)
{
oCompanyTutor = new CompanyTutor();
ctx.CompanyTutor.Add(oCompanyTutor);
}
else
{
ctx.CompanyTutor.Attach(oCompanyTutor);
}
oCompanyTutor.Birthdate = companyTutor.Birthdate;
oCompanyTutor.CompanyId = companyTutor.CompanyId;
oCompanyTutor.Cuil = companyTutor.Cuil;
oCompanyTutor.Dni = companyTutor.Dni;
oCompanyTutor.Email = companyTutor.Email;
oCompanyTutor.Names = companyTutor.Names;
oCompanyTutor.Surnames = companyTutor.Surnames;
oCompanyTutor.Sex = companyTutor.Sex;
ctx.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
