private void AjouterEmployee()
{
SessionEmployee SENouveau = new SessionEmployee
{
EmployeeConcerne = AjouterEmployeeSelectionner,
SessionConcerne = SessionConcerne
};
DAOSessionEmploye.AjouterSessionEmployee(SENouveau);
navigate.NavigateToDetailSession();
}
public static SessionLoginResult Login(string userName, string userPassword, IEmployee employeeService, IDepartment departmentService, IEducation educationService, IMission missionService)
{
Employee IsEmployeeExist = new EmployeeService(employeeService, departmentService).CheckUsernameAndPassword(
userName,
userPassword);
if (IsEmployeeExist != null)
{
Employee existEmployee = IsEmployeeExist;
SessionEmployee currentEmployee = new SessionEmployee();
currentEmployee.EmployeeId = existEmployee.EmployeeId;
currentEmployee.EmployeeName = existEmployee.EmployeeName;
currentEmployee.EmployeeSurname = existEmployee.EmployeeSurname;
currentEmployee.EmployeeCode = existEmployee.EmployeeCode;
currentEmployee.EmployeeEmail = existEmployee.EmployeeEmail;
currentEmployee.EmployeeUsername = existEmployee.EmployeeUsername;
currentEmployee.EmployeeTitle = existEmployee.EmployeeTitle;
currentEmployee.EmployeeBirthdate = existEmployee.EmployeeBirthdate;
currentEmployee.EmployeeTc = existEmployee.EmployeeTc;
currentEmployee.EmployeeManager = existEmployee.EmployeeManager;
currentEmployee.Departments = new DepartmentService(employeeService, departmentService).GetDepartmentByEmployeeId(existEmployee.EmployeeId);
currentEmployee.Educations = new EducationService(employeeService, educationService).GetEducationByEmployeeId(existEmployee.EmployeeId);
currentEmployee.Missions = new MissionService(employeeService, missionService).GetEducationByEmployeeId(existEmployee.EmployeeId);
if (currentEmployee.Departments == null)
{
return(new SessionLoginResult(false, "Can not find departmant info from Human Resource system for employee."));
}
else if (currentEmployee.Educations == null)
{
return(new SessionLoginResult(false, "Can not find education info from Human Resource system for employee."));
}
else if (currentEmployee.Missions == null)
{
return(new SessionLoginResult(false, "Can not find missions info from Human Resource system for employee."));
}
CurrentEmployee = currentEmployee;
return(new SessionLoginResult(true, null));
}
else
{
return(new SessionLoginResult(false, "Username or password wrong."));
}
}
public List <TeamSite> GetTeamSites([FromQuery] int id, [FromQuery] string startdate, [FromQuery] string enddate)
{
string query = "SELECT SessionSite FROM SessionEmployeeTable WHERE EmployeeId=@EmployeeId AND SessionDate=@Date;";
Team team = GetByIdStatic(id);
List <string> dates = new List <string>();
List <TeamSite> teamsites = new List <TeamSite>();
for (DateTime dt = DateTime.Parse(startdate); dt <= DateTime.Parse(enddate); dt = dt.AddDays(1))
{
dates.Add(dt.ToString("yyyy-MM-dd"));
}
using (SqlConnection conn = new SqlConnection(Connection.ConnString))
{
try
{
conn.Open();
foreach (string date in dates)
{
TeamSite teamsite = new TeamSite
{
Date = date,
Day = DateTime.Parse(date).DayOfWeek.ToString(),
Members = new List <SessionEmployee>()
};
foreach (TeamMember member in team.Members)
{
SessionEmployee employee = new SessionEmployee();
employee.EmployeeName = member.EmployeeName;
List <string> sites = new List <string>();
sites = conn.Query <string>(query, new { date, member.EmployeeId }).ToList();
if (sites.Count < 1)
{
employee.SessionSite = AbsenceController.GetEmployeeStatus(member.EmployeeId, date);
}
else if (sites.Count > 0)
{
employee.SessionSite = string.Join(", ", sites);
}
teamsite.Members.Add(employee);
}
teamsites.Add(teamsite);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
}
}
return(teamsites);
}
public static void AjouterSessionEmployee(SessionEmployee sEConcerne)
{
using (var db = new DBAirAtlantiqueContext())
{
var requetteE = from e in db.Employees where sEConcerne.EmployeeConcerne.Matricule == e.Matricule select e;
var requetteS = from s in db.Sessions where sEConcerne.SessionConcerne.SessionID == s.SessionID select s;
SessionEmployee _sessionEmployeeNouveau = new SessionEmployee
{
SessionConcerne = requetteS.First(),
EmployeeConcerne = requetteE.First()
};
db.SessionEmployees.Add(_sessionEmployeeNouveau);
db.SaveChanges();
}
}
