/// <summary>
/// delete collaborator from database
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool deleteCollaboratorConfirmed(int?id)
{
try {
Colaborateur collaborator = db.Colaborateur.Find(id);
DemandeVisa demandeVisa = (from v in db.DemandeVisa where v.IdC == id select v).FirstOrDefault();
if (demandeVisa != null)
{
demandeVisa.IdC = null;
db.DemandeVisa.Remove(demandeVisa);
}
if (collaborator.IdD != null)
{
collaborator.IdD = null;
db.Entry(collaborator).State = EntityState.Modified;
}
db.Colaborateur.Remove(collaborator);
db.SaveChanges();
}
catch (ArgumentNullException)
{
Log.Error("ArgumentNullException: id passed is null ,Colaborateur can not be found ...");
return(false);
}
catch (Exception e)
{
Log.Error(e.StackTrace);
return(false);
}
return(true);
}
/// <summary>
/// Collaborators Suggestion to next displacement
/// </summary>
/// <returns></returns>
public IList <Colaborateur> CollaboratorsSuggestion()
{
try
{
var ColaborateurProposer = from v in db.DemandeVisa where v.Status.Equals("Acceptee") where v.Colaborateur.IdD == null select v.Colaborateur;
if (db.Deplacement.ToList().Count != 0)
{
Deplacement deplacement = (db.Deplacement.OrderByDescending(d => d.Date).ToList())[0];
Colaborateur colaborateur = (from c in db.Colaborateur where c.IdD == deplacement.Id select c).ToList()[0];
if (colaborateur.Equipe.Equals("tma"))
{
var colaborateurs = (from v in db.DemandeVisa where v.Status.Equals("Acceptee") where v.Colaborateur.IdD.Equals(null) where v.Colaborateur.Equipe.Equals("roadmap") select v.Colaborateur);
ColaborateurProposer = colaborateurs.OrderBy(c => c.NombreDeplacement).ThenByDescending(c => c.Anciennete);
}
if (colaborateur.Equipe.Equals("roadmap"))
{
var colaborateurs = (from v in db.DemandeVisa where v.Status.Equals("Acceptee") where v.Colaborateur.IdD == null where v.Colaborateur.Equipe.Equals("tma") select v.Colaborateur);
ColaborateurProposer = colaborateurs.OrderBy(c => c.NombreDeplacement).ThenByDescending(c => c.Anciennete);
}
}
else
{
var colaborateurs = (from v in db.DemandeVisa where v.Status.Equals("Acceptee") where v.Colaborateur.Equipe.Equals("roadmap") select v.Colaborateur);
ColaborateurProposer = colaborateurs.OrderBy(c => c.NombreDeplacement).ThenByDescending(c => c.Anciennete);
}
return(ColaborateurProposer.ToList());
}
catch (Exception e)
{
Log.Error(e.StackTrace);
return(null);
}
}
public ActionResult Create([Bind(Include = "IdCol,Nom,Prenom,Role,Cin,Email,Poste,Equipe,NombreDeplacement,Anciennete,DateValiditeVisa,DateFinVisa,Sexe,Login,Password,DateConnection,IdD")] Colaborateur colaborateur)
{
IList <Colaborateur> colaborateurs = colabo.getColaborateurs();
try
{
Colaborateur col = (from c in colaborateurs where c.Login.Equals(colaborateur.Login) select c).FirstOrDefault();
if (ModelState.IsValid && col == null)
{
colabo.ajouterColab(colaborateur);
string message = "Bonjour\nLogin:"******"\nPassword" + colaborateur.Password;
colabo.sendMail(colaborateur.Email, "Création de compte collaborateur", message);
Log.Info("User have been created.....");
return(RedirectToAction("Index"));
}
else if (col != null)
{
ViewBag.Message = "login existe déja ";
}
}
catch (Exception e)
{
Log.Error(e.StackTrace);
}
return(View(colaborateur));
}
public ActionResult Create([Bind(Include = "Id,Nom,Prenom,Cin,Email,Poste,Equipe,NombreDeplacement,Anciennete,DateValiditeVisa,DateFinVisa,Sexe,Login,Password")] Colaborateur colaborateur)
{
if (ModelState.IsValid)
{
colabo.ajouterColab(colaborateur);
return(RedirectToAction("Index"));
}
return(View(colaborateur));
}
/// <summary>
/// Edit Collaborator in database
/// </summary>
/// <param name="collaborator"></param>
public void editCollaborator(Colaborateur collaborator)
{
try
{
db.Entry(collaborator).State = EntityState.Modified;
db.SaveChanges();
}
catch (Exception e)
{
Log.Error(e.StackTrace);
}
}
/// <summary>
/// add collaborateur
/// </summary>
/// <param name="collaborator"></param>
public void addCollaborator(Colaborateur collaborator)
{
try
{
db.Colaborateur.Add(collaborator);
db.SaveChanges();
}
catch (Exception e)
{
Log.Error("addCollaborator failed " + e.StackTrace);
}
}
public ActionResult Message(string colMail, string objet, string message, int?IdCol)
{
Colaborateur colaborateur = colabo.getColaborateur(IdCol);
ViewBag.Status = "Email Sent Successfully.";
if (!colabo.sendMail(colMail, objet, message))
{
ViewBag.Status = "Problem while sending email, Please check details.";
}
return(View(colaborateur));
}
/// <summary>
/// find collaborator using login and password
/// </summary>
/// <param name="collaborator"></param>
/// <returns></returns>
public Colaborateur findCollaborator(Colaborateur collaborator)
{
try
{
var collabo = db.Colaborateur.Where(C => String.Equals(C.Login, collaborator.Login) && String.Equals(C.Password, collaborator.Password)).FirstOrDefault();
return(collabo);
}
catch (Exception e)
{
Log.Error(e.StackTrace);
return(null);
}
}
/// <summary>
/// Edit Collaborator by id (find Collaborator)
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Colaborateur editCollaborator(int?id)
{
try
{
Colaborateur collaborator = db.Colaborateur.Find(id);
return(collaborator);
}
catch (Exception e)
{
Log.Error(e.StackTrace);
return(null);
}
}
/// <summary>
/// get collaborator by id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Colaborateur detailsCollaborator(int?id)
{
try
{
Colaborateur collaborator = db.Colaborateur.Include(d => d.Deplacement).SingleOrDefault(i => i.IdCol == id);
return(collaborator);
}
catch (Exception e)
{
Log.Error(e.StackTrace);
return(null);
}
}
// GET: Colaborateur
public ActionResult Index()
{
if (Session["ID"] != null && Session["ConnectionDate"] != null && Session["Role"].Equals("Colaborateur"))
{
Colaborateur colaborateur = colabo.getColaborateur((int?)Session["ID"]);
return(RedirectToAction("DemandeVisa"));
}
else if (Session["ConnectionDate"] == null)
{
return(RedirectToAction("ChangePassword", "Login"));
}
return(RedirectToAction("Index", "Login"));
}
/// <summary>
/// edit a visa request
/// </summary>
/// <param name="demandeVisa"></param>
public void editRequestVisa(DemandeVisa demandeVisa)
{
try
{
Colaborateur c = db.Colaborateur.Find(demandeVisa.IdC);
c.DateValiditeVisa = demandeVisa.DateValiditeVisa;
c.DateFinVisa = demandeVisa.DateFinVisa;
db.Entry(demandeVisa).State = EntityState.Modified;
db.SaveChanges();
}
catch (Exception e)
{
Log.Error(e.StackTrace);
}
}
public ActionResult Index(Colaborateur col)
{
Log.Info("Login-page started...");
ViewBag.Message = null;
Colaborateur colaborateur = colab.getCollaborator(col);
if (colaborateur != null)
{
Session["DateConnection"] = colaborateur.DateConnection;
Session["ID"] = colaborateur.IdCol;
Session["Role"] = colaborateur.Role;
Session["Nom"] = colaborateur.Nom == null ? "User" : colaborateur.Nom;
Session["Prenom"] = colaborateur.Prenom == null ? " " : colaborateur.Prenom;
if (colaborateur.Role.Equals("Admin"))
{
Log.Info("Login succeeded to Admin Account:" + Session["ID"] + ":" + Session["Nom"] + " " + Session["Prenom"] + "...");
Log.Info("Redirection to Admin Account....");
return(RedirectToAction("Index", "UIColaborateur"));
}
else
{
Session["Role"] = colaborateur.Role;
Session["ConnectionDate"] = colaborateur.DateConnection;
if (colaborateur.DateConnection == null)
{
Log.Info("First Login succeeded Redirection to changePassword Page...");
return(RedirectToAction("ChangePassword", "Login", new { id = colaborateur.IdCol }));
}
else
{
Log.Info("Login succeeded to Colaborateur Account...");
return(RedirectToAction("Index", "Colaborateur"));
}
}
}
else
{
ViewBag.Message = "login ou password incorrect";
Log.Info("Login Faild:incorrect username or password...");
return(View("Index"));
}
}
public ActionResult RecoverPassword(string login, string email)
{
IList <Colaborateur> colaborateurs = colab.getCollaborators();
Colaborateur colaborateur = (from c in colaborateurs where c.Login.Equals(login) where c.Email.Equals(email) select c).FirstOrDefault();
if (colaborateur == null)
{
ViewBag.Message = "login ou email incorrecte";
return(View());
}
else
{
/* string message = "Bonjour "+colaborateur.Nom+" "+colaborateur.Prenom+"\n"
+" Les informations de connexion vers votre compte : \nLogin :"******"\nPassword"+colaborateur.Password ;
* colb.sendMail(email, "Password recover", message);*/
TempData["Message"] = "Mail de récupération à été envoyé a " + email;
return(RedirectToAction("Index"));
}
}
public ActionResult ChangePassword(int?id, string Password, string CPassword)
{
Colaborateur colabo = colb.modifierColborateurById((int)Session["ID"]);
if (CPassword.Equals(Password))
{
colabo.DateConnection = DateTime.Today;
colabo.Password = Password;
colb.modifierColaborateur(colabo);
Log.Info("password has been changed ...");
return(RedirectToAction("LogOut"));
}
else
{
ViewBag.Message = "Le mot de passe et le mot de passe de confirmation ne correspondent pas";
Log.Info("password and passwordConfirmation doesn't match ...");
return(View());
}
}
/// <summary>
/// add displacement to collaborators
/// </summary>
/// <param name="deplacement"></param>
/// <param name="IdU"></param>
public void addDisplacementToCollaborators(Deplacement deplacement, int?[] IdU)
{
try
{
if (IdU != null)
{
for (int i = 0; i < IdU.Length; i++)
{
Colaborateur colabo = db.Colaborateur.Find(IdU[i]);
colabo.IdD = deplacement.Id;
colabo.NombreDeplacement++;
db.SaveChanges();
}
}
}
catch (Exception e)
{
Log.Error("addDisplacementToCollaborators failed " + e.StackTrace);
}
}
public ActionResult Edit([Bind(Include = "IdCol,Nom,Prenom,Role,Cin,Email,Poste,Equipe,NombreDeplacement,Anciennete,DateValiditeVisa,DateFinVisa,Sexe,Login,Password,DateConnection,IdD")] Colaborateur colaborateur)
{
IList <Colaborateur> colaborateurs = colabo.getColaborateurs();
Colaborateur col = (from c in colaborateurs where c.IdCol != (colaborateur.IdCol) where c.Login.Equals(colaborateur.Login) select c).FirstOrDefault();
if (Session["ID"] != null && Session["Role"].Equals("Admin"))
{
if (ModelState.IsValid && col == null)
{
colaborateur.DateConnection = new DateTime();
colabo.modifierColaborateur(colaborateur);
return(RedirectToAction("Index"));
}
else if (col != null)
{
ViewBag.Message = "login existe déja ";
return(View(colaborateur));
}
}
return(RedirectToAction("Index", "Login"));
}
public ActionResult Edit([Bind(Include = "IdCol,Nom,Prenom,Role,Cin,Email,Poste,Equipe,NombreDeplacement,Anciennete,DateValiditeVisa,DateFinVisa,Sexe,Login,Password")] Colaborateur colaborateur)
{
if (ModelState.IsValid)
{
colabo.modifierColaborateur(colaborateur);
return(RedirectToAction("Index"));
}
if (Session["ID"] != null)
{
if (Session["Role"].Equals("Colaborateur") && Session["ConnectionDate"] == null)
{
return(RedirectToAction("ChangePassword", "Login"));
}
else
{
return(View(colaborateur));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public void ajouterColab(Colaborateur colaborateur)
{
colab.AddColaborateur(colaborateur);
}
public void AddColaborateur(Colaborateur colaborateur)
{
db.Colaborateur.Add(colaborateur);
db.SaveChanges();
}
public void modifierColaborateur(Colaborateur colaborateur)
{
colab.editCollaborator(colaborateur);
}
public void ajouterColab(Colaborateur colaborateur)
{
colab.addCollaborator(colaborateur);
}
public Colaborateur getCollaborator(Colaborateur colaborateur)
{
return(colab.findCollaborator(colaborateur));
}
public void editCollaborator(Colaborateur colaborateur)
{
colab.editCollaborator(colaborateur);
}
public void addCollaborator(Colaborateur colaborateur)
{
colab.addCollaborator(colaborateur);
}
public ActionResult Message(int?id)
{
Colaborateur colaborateur = colabo.getColaborateur(id);
return(View(colaborateur));
}