public override object Add(object obj, string userId)
{
StudentDTO std = (StudentDTO)obj;
try
{
using (var db = new stageobxdatabaseEntities())
{
var result = db.Students.FirstOrDefault(c => c.StudentEmail == std.Email);
if (!obj.Equals(result))
{
db.Students.Add(new Student()
{
StudentName = std.Name,
StudentFirstname = std.FirstName,
StudentDepartement = std.Departement,
StudentDocument = std.Document,
StudentEmail = std.Email,
AspNetUserId = userId
});
}
db.SaveChanges();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return("");
}
public override object Add(object obj, string userId)
{
CompanyDTO cpn = (CompanyDTO)obj;
try
{
using (var db = new stageobxdatabaseEntities())
{
db.Companies.Add(new Company()
{
CompanyName = cpn.Name,
CompanyCity = cpn.City,
CompanyStreetName = cpn.StreetName,
CompanyPostalCode = cpn.PostalCode,
CompanyTelephone = cpn.Telephone,
StudentId = db.Students.Where(w => w.AspNetUserId == userId).First().StudentId
});
db.SaveChanges();
}
}
catch (Exception e)
{
return(e.Message);
}
return("");
}
public override void Modify(object obj, string userId)
{
CompanyDTO cpn = (CompanyDTO)obj;
try
{
using (var db = new stageobxdatabaseEntities())
{
if (db.Companies.First(comp => comp.CompanyId == cpn.Id) == null)
{
return;
}
db.Companies.Remove(db.Companies.First(comp => comp.CompanyId == cpn.Id));
db.SaveChanges();
db.Companies.Add(new Company()
{
CompanyName = cpn.Name,
CompanyCity = cpn.City,
CompanyStreetName = cpn.StreetName,
CompanyPostalCode = cpn.PostalCode,
CompanyTelephone = cpn.Telephone,
StudentId = db.Students.Where(w => w.AspNetUserId == userId).First().StudentId
});
db.SaveChanges();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public override void Modify(object obj, string userId)
{
ContractDTO contract = (ContractDTO)obj;
try
{
using (var db = new stageobxdatabaseEntities())
{
if (db.Contracts.Where(w => w.Student.AspNetUserId == userId).Count() == 0)
{
return;
}
db.Contracts.Remove(db.Contracts.First(contr => contr.Student.AspNetUserId == userId));
db.SaveChanges();
db.Contracts.Add(new Contract()
{
ContractAddressBox = contract.ContractAddressBox,
ContractAddressCity = contract.ContractAddressCity,
ContractAddressNumber = contract.ContractAddressNumber,
ContractAddressPostalCode = contract.ContractAddressPostalCode,
ContractAddressStreet = contract.ContractAddressStreet,
ContractArrivalTime = contract.ContractArrivalTime,
ContractContactName = contract.ContractContactName,
ContractContactTitle = contract.ContractContactTitle,
ContractModality = contract.ContractModality,
ContractName = contract.ContractName,
ContractNotes = contract.ContractNotes,
ContractOptionnalInstruction = contract.ContractOptionnalInstruction,
ContractPhone = contract.ContractPhone,
ContractSubject = contract.ContractSubject,
ContractSupervisorFirstName = contract.ContractSupervisorFirstName,
ContractSupervisorMail = contract.ContractSupervisorMail,
ContractSupervisorName = contract.ContractSupervisorName,
ContractSupervisorPhone = contract.ContractSupervisorPhone,
StudentId = db.Students.First(w => w.AspNetUserId == userId).StudentId
});
db.SaveChanges();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public override void Remove(object obj)
{
ContractDTO contract = (ContractDTO)obj;
try
{
using (var db = new stageobxdatabaseEntities())
{
db.Contracts.Remove(db.Contracts.First(cont => cont.ContractId == contract.Id));
db.SaveChanges();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
private object GetAll()
{
List <Contract> result = null;
try
{
using (var db = new stageobxdatabaseEntities())
{
result = db.Contracts.ToList();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return(MapToContractDTO(result));
}
public override void Remove(object obj)
{
StudentDTO student = (StudentDTO)obj;
try
{
using (var db = new stageobxdatabaseEntities())
{
db.Students.Remove(db.Students.First(stud => stud.StudentId == student.Id));
db.SaveChanges();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
// Gets all the companies
private object GetAll()
{
object compList = new List <object>();
try
{
using (var db = new stageobxdatabaseEntities())
{
compList = db.Companies.ToList();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return(MapToCompanyDTO((List <Company>)compList));
}
public override object Get(string id)
{
List <Contract> result = null;
int integerId = Int32.Parse(id);
try
{
using (var db = new stageobxdatabaseEntities())
{
result = db.Contracts.Where(c => c.StudentId == integerId).ToList();
}
}
catch (Exception e)
{
return(e.Message);
}
return(MapToContractDTO(result));
}
public override void Modify(object obj, string userId)
{
StudentDTO student = (StudentDTO)obj;
try
{
using (var db = new stageobxdatabaseEntities())
{
Student stud = db.Students.First(w => w.AspNetUserId == userId);
stud.StudentDocument = student.Document;
db.SaveChanges();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public override object Get(string userId)
{
int contractId = 0;
List <Contract> result = null;
// GETS ALL THE STUDENTS IF ID == 0
if (userId == "0")
{
return(GetAll());
}
if (!Int32.TryParse(userId, out contractId))
{
try
{
using (var db = new stageobxdatabaseEntities())
{
result = db.Contracts.Where(c => c.Student.AspNetUserId == userId).ToList();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
else
{
try
{
using (var db = new stageobxdatabaseEntities())
{
result = db.Contracts.Where(c => c.ContractId == contractId).ToList();
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
return(MapToContractDTO(result));
}
