/// <summary>
/// Remove employee from the table EMPLOYEE
/// </summary>
/// <param name="employee">Employee (object) from the data selected by user</param>
public static void RemoveEmployeeFromEmployee(Employee employee)
{
string req = "delete from personnel where idpersonnel = @idpersonnelPersonnel;";
Dictionary <string, object> parameters = new Dictionary <string, object>
{
{ "@idpersonnelPersonnel", employee.IdEmployee }
};
ConnexionDataBase cursor = ConnexionDataBase.GetInstance(connexionString);
cursor.ReqUpdate(req, parameters);
}
/// <summary>
/// Remove an absence from an employee
/// </summary>
/// <param name="absence">Absence (object) selected from an employee</param>
/// <param name="employee">Employee (object) selected by a user</param>
public static void RemoveAbsenceFromEmployee(Absence absence, Employee employee)
{
string req = "delete from absence ";
req += "where idpersonnel = @idpersonnel ";
req += "and datedebut = @datedebut";
Dictionary <string, object> parameters = new Dictionary <string, object>
{
{ "@idpersonnel", employee.IdEmployee },
{ "@datedebut", absence.FirstDay }
};
ConnexionDataBase cursor = ConnexionDataBase.GetInstance(connexionString);
cursor.ReqUpdate(req, parameters);
}
/// <summary>
/// Add an absence to an employee
/// </summary>
/// <param name="employee">Employee (object) from the data selected by user</param>
/// <param name="firstDay">first day of the absence</param>
/// <param name="lastDay">last day of the absence</param>
/// <param name="idReason">ID reason of the absence</param>
public static void AddAbsence(Employee employee, DateTime firstDay, DateTime lastDay, int idReason)
{
string req = "insert into absence(idpersonnel, datedebut, idmotif, datefin) ";
req += "values (@idpersonnel, @datedebut, @idmotif, @datefin) ";
Dictionary <string, object> parameters = new Dictionary <string, object>
{
{ "@idpersonnel", employee.IdEmployee },
{ "@datedebut", firstDay },
{ "@idmotif", idReason },
{ "@datefin", lastDay }
};
ConnexionDataBase cursor = ConnexionDataBase.GetInstance(connexionString);
cursor.ReqUpdate(req, parameters);
}
/// <summary>
/// Update employee data in the database
/// </summary>
/// <param name="employee">Employee (object) from the data selected by user</param>
public static void UpdateEmployee(Employee employee)
{
string req = "update personnel set nom = @nom, prenom = @prenom, tel = @tel, mail = @mail, idservice = @idservice ";
req += "where idpersonnel = @idpersonnel;";
Dictionary <string, object> parameters = new Dictionary <string, object>
{
{ "@idpersonnel", employee.IdEmployee },
{ "@idservice", employee.IdDepartment },
{ "@nom", employee.FamilyName },
{ "@prenom", employee.FirstName },
{ "@tel", employee.Phone },
{ "@mail", employee.Mail }
};
ConnexionDataBase cursor = ConnexionDataBase.GetInstance(connexionString);
cursor.ReqUpdate(req, parameters);
}
/// <summary>
/// Add an employee to the database
/// </summary>
/// <param name="employee">Employee (object) from the data selected by user</param>
public static void AddEmployee(Employee employee)
{
string req = "insert into personnel(idpersonnel, idservice, nom, prenom, tel, mail) ";
req += "values (@idpersonnel, @idservice, @nom, @prenom, @tel, @mail);";
Dictionary <string, object> parameters = new Dictionary <string, object>
{
{ "@idpersonnel", employee.IdEmployee },
{ "@nom", employee.FamilyName },
{ "@prenom", employee.FirstName },
{ "@tel", employee.Phone },
{ "@mail", employee.Mail },
{ "@idservice", employee.IdDepartment },
};
ConnexionDataBase cursor = ConnexionDataBase.GetInstance(connexionString);
cursor.ReqUpdate(req, parameters);
}
/// <summary>
/// Update absence from an employee
/// </summary>
/// <param name="employee">Employee (object) from the data selected by user</param>
/// <param name="previousDateSelected">first day, part of the composite primary key absence</param>
/// <param name="firstDay">first day selected</param>
/// <param name="lastDay">last day selected</param>
/// <param name="idReason">ID reason of the absence</param>
public static void UpdateAbsence(Employee employee,
DateTime previousDateSelected,
DateTime firstDay,
DateTime lastDay,
int idReason
)
{
string req = "update absence set datedebut = @datedebut, datefin = @datefin, idmotif = @idmotif ";
req += "where idpersonnel = @idpersonnel and datedebut = @datedebutAvantMAJ;";
Dictionary <string, object> parameters = new Dictionary <string, object>
{
{ "@idpersonnel", employee.IdEmployee },
{ "@datedebut", firstDay },
{ "@datedebutAvantMAJ", previousDateSelected },
{ "@datefin", lastDay },
{ "@idmotif", idReason }
};
ConnexionDataBase cursor = ConnexionDataBase.GetInstance(connexionString);
cursor.ReqUpdate(req, parameters);
}
