public specialization(int id = 0, discipline discipline_ = 0, expertise expertise_ = 0, double minWage_ = 0, double maxWage_ = 0)
{
specialization_id = id;
discipline = discipline_;
expertise = expertise_;
minWage = minWage_;
maxWage = maxWage_;
}
public contract(int contractID_ = 0, int employerID_ = 0, int employeeID_ = 0, int professionalID_ = 0, bool isSigned_ = false,
double salaryBrute_ = 0, double salaryNet_ = 0, DateTime dt = default(DateTime), DateTime end_ = default(DateTime), int numHours_ = 0, expertise e_ = expertise.ALGO_INGINEER,
string city_ = null, double commission_ = 0)
{
contractID = contractID_;
employerID = employerID_;
employeeID = employeeID_;
professionalID = professionalID_;
isSigned = isSigned_;
salaryBrute = salaryBrute_;
salaryNet = salaryNet_;
beginning = dt;
end = end_;
numHours = numHours_;
expertise = e_;
city = city_;
commission = commission_;
}
public List <expertise> GetExpertiseList(int cv_id)
{
var fexpertise = (from ex in pgfe.expertise
join exCv in pgfe.expertise_cv on ex.expertise_id equals exCv.expertise_id
where exCv.cv_id == cv_id
select new
{
ex.expertise_id,
ex.name,
ex.rank_expertise_id
}).ToList();
List <expertise> expertiseL = new List <expertise>();
foreach (var item in fexpertise)
{
expertise expertise2 = new expertise();
expertise2.expertise_id = item.expertise_id;
expertise2.name = item.name;
expertise2.rank_expertise_id = item.rank_expertise_id;
expertiseL.Add(expertise2);
}
;
return(expertiseL);
}
