public static List <Employes> rechercheParPreNom(string prenom)
{
List <Employes> lEmployes = new List <Employes>();
using (SqlConnection conn = UtilityBD.connectBD())
{
string query = "SELECT * FROM Employes WHERE EmployePrenom = '" + prenom + "';";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Employes emp = new Employes();
emp.NoIdentifiant = Convert.ToInt32(reader["EmployeId"]);
emp.MPasse = reader["EmployeMDP"].ToString();
emp.NomUtil = reader["EmployeNom"].ToString();
emp.PrenomAdmin = reader["EmployePrenom"].ToString();
emp.Categorie = reader["EmployeFonction"].ToString();
lEmployes.Add(emp);
}
}
return(lEmployes);
}
// bool isExecute = Convert.ToBoolean(cd.ExecuteNonQuery());
// sc.Close();
// return isExecute;
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.Message);
// }
// return true;
//}
//public string AddEmp(Employes st)
//{
// try
// {
// SqlConnection sc = new SqlConnection("Data Source = (localdb)\\MSSQLLocalDB; Initial Catalog = work; Integrated Security = True; Connect Timeout = 30; Encrypt = False; TrustServerCertificate = False; ApplicationIntent = ReadWrite; MultiSubnetFailover = False");
// SqlCommand cd = new SqlCommand("AddEmployee", sc);
// cd.CommandType = System.Data.CommandType.StoredProcedure;
// cd.Parameters.AddWithValue("@Name", st.Name);
// cd.Parameters.AddWithValue("@Email", st.Email);
// cd.Parameters.AddWithValue("@EmployeeCode", st.EmployeeCode);
// cd.Parameters.AddWithValue("@Gender", st.Gender);
// cd.Parameters.AddWithValue("@Designation", st.Designation);
// cd.Parameters.AddWithValue("@Department", st.Department);
// cd.Parameters.AddWithValue("@DOB", st.DOB);
// cd.Parameters.AddWithValue("@Salary", st.Salary);
// sc.Open();
// bool isExecute = Convert.ToBoolean(cd.ExecuteNonQuery());
// sc.Close();
// return "hello world";
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.Message);
// }
// return /*true*/ "hello world";
//}
public bool UpdateEmp(Employes st)
{
try
{
SqlConnection sc = new SqlConnection("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=work;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand cd = new SqlCommand("UpdateEmployee", sc);
cd.CommandType = System.Data.CommandType.StoredProcedure;
cd.Parameters.AddWithValue("@Id", st.Id);
cd.Parameters.AddWithValue("@Name", st.Name);
cd.Parameters.AddWithValue("@Email", st.Email);
cd.Parameters.AddWithValue("@EmployeeCode", st.EmployeeCode);
cd.Parameters.AddWithValue("@Gender", st.Gender);
cd.Parameters.AddWithValue("@Designation", st.Designation);
cd.Parameters.AddWithValue("@Department", st.Department);
cd.Parameters.AddWithValue("@DOB", st.DOB);
cd.Parameters.AddWithValue("@Salary", st.Salary);
sc.Open();
bool isExecute = Convert.ToBoolean(cd.ExecuteNonQuery());
sc.Close();
return(isExecute);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(true);
}
/// <summary>
/// Chargement des donnees de l'application
/// </summary>
private void ChargerDonnees()
{
foreach (Offre ofr in manager.GetOffres())
{
Offres.Add(new OffreVM(ofr));
}
foreach (Employe emp in manager.GetEmployees())
{
Employes.Add(new EmployeVM(emp));
}
foreach (OffreVM ofr in Offres)
{
foreach (Postulation post in manager.GetPostulations(item => Equals(item.OffreId, ofr.Id)))
{
EmployeVM emp = Employes.Where(item => Equals(item.Id, post.EmployeId)).FirstOrDefault();
if (emp != null)
{
ofr.EmployesInteresses.Add(emp);
}
}
}
}
protected override Task OnInitializedAsync()
{
Cargadatos();
empleado = Employes.Where(x => x.Id == int.Parse(Id)).FirstOrDefault();
return(base.OnInitializedAsync());
}
private void AjouterEmploye(object operateur)
{
if (!string.IsNullOrWhiteSpace(EmployeCourant.Nom) && !string.IsNullOrWhiteSpace(EmployeCourant.Prenom))
{
Employes.Add(EmployeCourant);
DAL.InsertPersonne(EmployeCourant);
EmployeCourant = new Personne();
}
}
private void DeletEmployes(List <Employe> employes)
{
foreach (var item in employes)
{
Employes.Remove(item);
}
// for perfomance Reason we update the list when we remove all value.
OnPropertyChanged(nameof(Employes));
}
//private void AjouterEmploye(object o)
//{
// if (!string.IsNullOrEmpty(NouvelEmploye.Nom) &&
// !string.IsNullOrEmpty(NouvelEmploye.Prenom))
// Employes.Add(NouvelEmploye);
// NouvelEmploye = new Employe();
//}
private void AjouterEmploye(object o)
{
WndAjoutEmploye dlg = new WndAjoutEmploye(NouvelEmploye);
bool? res = dlg.ShowDialog();
if (res.Value)
{
Employes.Add(NouvelEmploye);
NouvelEmploye = new Employe();
}
}
private void button_connecter_Click(object sender, EventArgs e)
{
string mdp = textBox_MDP.Text;
int id = Convert.ToInt32(textBox_id.Text);
if (EmployesBD.UtilTrouve(id, mdp) != null)
{
Employes emp = new Employes();
emp = EmployesBD.UtilTrouve(id, mdp);
if (emp.Categorie == "Gestionnaire IT")
{
Administration adm = new Administration();
adm.PersonneMP = emp.NoIdentifiant.ToString();
adm.Show();
this.Hide();
}
else if (emp.Categorie == "Gestionnaire Ventes")
{
COMMIS com = new COMMIS();
com.PersonneMP = emp.NoIdentifiant.ToString();
com.Show();
this.Hide();
}
else if (emp.Categorie == "Commis")
{
FeuilleCommis fCommis = new FeuilleCommis();
fCommis.PersonneMP = emp.NoIdentifiant.ToString();
fCommis.Show();
this.Hide();
}
else if (emp.Categorie == "Comptable")
{
// formulaire à faire
}
else if (emp.Categorie == "Contrôleur")
{
FeuilleControle fc = new FeuilleControle();
fc.PersonneMP = emp.NoIdentifiant.ToString();
fc.Show();
this.Hide();
}
else
{
// Utilisateur lambda
}
}
else
{
MessageBox.Show("Utilisateur inconnu", "Incorrect", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public IActionResult DeleteEmployee(int ID, Employes st)
{
Delete emp = new Delete();
if (emp.DeleteEmp(ID))
{
return(RedirectToAction("GetEmployee"));
}
else
{
return(View());
}
}
public IActionResult UpdateEmployee(int ID, Employes s1)
{
Update emp = new Update();
if (emp.UpdateEmp(s1))
{
return(RedirectToAction("GetEmployee"));
}
else
{
return(View());
}
}
/// <summary>
/// Construtor padrão
/// </summary>
public UserControlEmployes()
{
//Carregando os componentes
InitializeComponent();
//Instanciando objetos
actionIndex = -1;
_employe = new Employe();
_employe.id = MainWindow.currentId;
aux = null;
logs = new Logs();
dao = new Employes();
}
public static bool DeleteData(Employes emp)
{
using (SqlConnection con = UtilityBD.connectBD())
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = con;
sqlCmd.Parameters.Add("@EmployeId", emp.NoIdentifiant);
sqlCmd.CommandText = string.Format("DELETE FROM Employes WHERE EmployeId = @EmployeId ;");
return(Convert.ToBoolean(sqlCmd.ExecuteNonQuery()));
}
}
public IActionResult AddEmployes(Employes emp)
{
AddRepo em = new AddRepo();
if (em.AddEmp(emp))
{
ViewBag.ErrMsg = "Employee Details are successfully Added";
}
else
{
ViewBag.ErrMsg = "Employee Details are Not successfully Added";
}
return(View(emp));
}
public EmployeViewModel()
{
DeletEmployesCommand = new DeletEmployesCommand(DeletEmployes);
Employes.Add(new Employe {
Age = 20, Name = "Krisztian"
});
Employes.Add(new Employe {
Age = 10, Name = "Bence"
});
Employes.Add(new Employe {
Age = 30, Name = "Jozsi"
});
}
public static void add()
{
Console.WriteLine();
Employes emp = new Employes();
Console.Write("Имя:");
emp.name = Console.ReadLine();
Console.Write("Средняя ЗП:");
emp.salary = float.Parse(Console.ReadLine());
Console.Write("Стаж:");
emp.experience = int.Parse(Console.ReadLine());
sqlQuery sql = new sqlQuery();
sql.addUser(emp);
}
private void SupprimerEmploye(Object o)
{
var e = (Employe)CollectionViewSource.GetDefaultView(Employes).CurrentItem;
Employes.Remove(e);
try
{
DAL.SupprimerEmploye(e);
}
catch (SqlException)
{
MessageBox.Show("L'employé choisi est reférencé. Il n'est pas possible de le supprimer",
"Erreur", MessageBoxButton.OK);
}
}
private void btnAjout_Click(object sender, EventArgs e)
{
Employes employeModif = (from unEmploye in monDataContext.Employes
where unEmploye.No == (int)employesDataGridView.CurrentRow.Cells[0].Value
select unEmploye).FirstOrDefault();
frmAjout = new frmAjoutEmployes(employeModif, monDataContext);
frmAjout.ShowDialog();
this.Show();
//refresh le bindingsource du datagridview pour voir l'employe qui a ete ajoute
employesBindingSource.DataSource = from unEmploye in monDataContext.Employes
//orderby unEmploye.No
select unEmploye;
}
/// <summary>
/// метод изменения данных в выбранной из таблицы записи
/// </summary>
public void ChangeEmployee()
{
//проверка временных переменных на NULL
//если временная переменная равна NULL то присваивается выбранное
//на данный момент значение поля из DataGrid
employee.LastName = lNameTmp ?? employee.LastName;
employee.Name = nameTmp ?? employee.Name;
employee.SurName = sNameTmp ?? employee.SurName;
//сохранение изменений бд
//а так же обновление DataGrid
DB.SaveChanges();
DB = new Employes();
DB.Employees.Load();
MessageBox.Show("Объект обновлен");
}
private void AjouterEmploye(Object o)
{
//if (!string.IsNullOrEmpty(NouvelEmploye.Nom) && !string.IsNullOrEmpty(NouvelEmploye.Prenom))
//{
// Employes.Add(NouvelEmploye);
// DAL.AjouterEmploye(NouvelEmploye);
// NouvelEmploye = new Employe();
//}
WndAjoutEmploye dlg = new WndAjoutEmploye(NouvelEmploye);
bool? res = dlg.ShowDialog();
if (res.Value)
{
Employes.Add(NouvelEmploye);
NouvelEmploye = new Employe();
}
}
public void FillList()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString()))
{
SqlCommand query = new SqlCommand("select * from tblEmploye where ManagerID = @ManagerID;", conn);
query.Parameters.AddWithValue("@ManagerID", LoginScreen.CurrentManager.Id);
conn.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
if (Employes == null)
{
Employes = new ObservableCollection <Employe>();
}
foreach (DataRow row in dataTable.Rows)
{
Employe e = new Employe
{
Id = int.Parse(row[0].ToString()),
FirstName = row[1].ToString(),
LastName = row[2].ToString(),
DateOfBirth = DateTime.Parse(row[3].ToString()),
Mail = row[4].ToString(),
Username = row[5].ToString(),
Password = row[6].ToString(),
Floor = int.Parse(row[7].ToString()),
Gender = row[8].ToString(),
Citizenship = row[9].ToString(),
Duty = row[10].ToString(),
Salary = double.Parse(row[11].ToString()),
ManagerID = int.Parse(row[12].ToString())
};
if (e.Duty == "Overviewing" || e.Duty == "Reporting")
{
e.EditSalary = true;
}
Employes.Add(e);
}
}
}
public static bool modifyData(Employes emp)
{
using (SqlConnection con = UtilityBD.connectBD())
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = con;
sqlCmd.Parameters.Add("@EmployeId", emp.NoIdentifiant);
sqlCmd.Parameters.Add("@EmployePrenom", emp.PrenomAdmin);
sqlCmd.Parameters.Add("@EmployeNom", emp.NomUtil);
sqlCmd.Parameters.Add("@EmployeFonction", emp.Categorie);
sqlCmd.Parameters.Add("@EmployeMDP", emp.MPasse);
sqlCmd.CommandText = string.Format("UPDATE Employes SET EmployePrenom = @EmployePrenom, EmployeNom = @EmployeNom, EmployeFonction = @EmployeFonction, EmployeMDP = @EmployeMDP WHERE EmployeId = @EmployeId ;");
return(Convert.ToBoolean(sqlCmd.ExecuteNonQuery()));
}
}
public static bool InsertData(Employes emp)
{
using (SqlConnection con = UtilityBD.connectBD())
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = con;
sqlCmd.Parameters.Add("@EmployeeId", emp.NoIdentifiant);
sqlCmd.Parameters.Add("@EmployeMDP", emp.MPasse);
sqlCmd.Parameters.Add("@EmployePrenom", emp.PrenomAdmin);
sqlCmd.Parameters.Add("@EmployeNom", emp.NomUtil);
sqlCmd.Parameters.Add("@EmployeFonction", emp.Categorie);
sqlCmd.CommandText = "INSERT INTO Employes VALUES (@EmployeeId,@EmployeMDP,@EmployePrenom,@EmployeNom,@EmployeFonction)";
return(Convert.ToBoolean(sqlCmd.ExecuteNonQuery()));
}
}
public bool AddEmploye(Employe newEmploye)//method for adding a employe to institute
{
if (Employes.Count > 9)
{
Console.Write($"No more space in list of employes for: {newEmploye}.");
return(false);
}
foreach (Employe emp in Employes)
{
if (emp.Equals(newEmploye))
{
Console.WriteLine($"{newEmploye} already exists among employes.");
return(false);
}
}
Employes.Add(newEmploye);
return(true);
}
public frmModificationEmployes(Employes emp, DataClasses1DataContext dataContextRecuperer)
{
InitializeComponent();
this.dataContexteModifier = dataContextRecuperer;
//ramener les provinces
this.employesBindingSource.DataSource = from prov in dataContextRecuperer.Provinces
select prov;
ExprMotDePasse = new Regex("^(?=.*[A-Za-z])(?=.*\\d)(?=.*[$@$!%*#?&])[A-Za-z\\d$@$!%*#?&]{8,}$");
employeRecuperer = (from unEmploye in dataContextRecuperer.Employes
where unEmploye.No == emp.No
select unEmploye).FirstOrDefault();
// MessageBox.Show(employeRecuperer.Nom);
}
public frmAjoutEmployes(Employes employe, DataClasses1DataContext dataContextRecuperer)
{
InitializeComponent();
this.dataContextajout = dataContextRecuperer;
ExprMotDePasse = new Regex("^(?=.*[A-Za-z])(?=.*\\d)(?=.*[$@$!%*#?&])[A-Za-z\\d$@$!%*#?&]{8,}$");
employeRecuperer = (from unEmploye in dataContextRecuperer.Employes
where unEmploye.No == employe.No
select unEmploye).FirstOrDefault();
//ramener les provinces
this.employesBindingSource1.DataSource = from prov in dataContextRecuperer.Provinces
select prov;
//ramener les types employes
this.employesBindingSource2.DataSource = from noTypeEmploye in dataContextRecuperer.TypesEmploye
where noTypeEmploye.No != 1
select noTypeEmploye;
}
//конструктор класса
public Logic()
{
db = new Employes();
employee = new Employee();
db.Employees.Load();
}
private void SupprimerEmploye(object obj)
{
var emp = (Employe)CollectionViewSource.GetDefaultView(Employes).CurrentItem;
Employes.Remove(emp);
}
public bool UpdateEmployes([FromBody] Employes emp)
{
AddRepo sb = new AddRepo();
return(sb.UpdateEmp(emp));
}
public int AddEmployes([FromBody] Employes emp)
{
AddRepo sb = new AddRepo();
return(sb.AddEmp(emp));
}
private void btnSuppression_Click(object sender, EventArgs e)
{
int noEmployeConnecter = Convert.ToInt32(frmConnexion.strNoUtilisateur);
//int intNoEmployeSelectionee = Convert.ToInt32(employesDataGridView.CurrentRow.Cells[0].Value.ToString());
// string strTypeEmploySelectionee =employesDataGridView.CurrentRow.Cells[2].Value.ToString();
// int noTypeEmploye = frmConnexion.noTypeEmploye;
// un employe qui a un service
/* var employeQuiADesServices = from unEmploye in monDataContext.Services
* let noEmploye = unEmploye.NoEmploye
* select new { noEmploye};
*
* int intEmployeQuiADesService = 0;
*
* foreach (var employeService in employeQuiADesServices)
* {
* intEmployeQuiADesService = employeService.noEmploye;
*
*
* }*/
if (employesDataGridView.CurrentRow == null)
{
MessageBox.Show("Vous devez sélectionner un employé pour le supprimer", "Attention!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
Employes Emp = (from unEmploye in monDataContext.Employes
where unEmploye.No == (int)employesDataGridView.CurrentRow.Cells[0].Value
select unEmploye).FirstOrDefault();
if (Emp.Equals(null))
{
MessageBox.Show("L'employé que vous voulez supprimer n'existe pas!", "Attention!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Emp.Services.Count > 0)
{
MessageBox.Show("L'employé que vous voulez supprimer a des services", "Attention!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Emp.No.Equals(noEmployeConnecter))
{
MessageBox.Show("Vous ne pouvez pas supprimer l'employé courant.", "Attention!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Emp.TypesEmploye.ToString().Equals("Administrateur"))
{
MessageBox.Show("Vous ne pouvez pas supprimer l'administrateur", "Attention!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var employeASupprimer = from unEmploye in monDataContext.Employes
where unEmploye.No == Emp.No
select unEmploye;
if ((MessageBox.Show("Vous êtes sur le point de supprimer un employé. \nVous êtes sûr de vouloir le faire ?", "Suppression d'un employé",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes))
{
foreach (var unEmploye in employeASupprimer)
{
employesBindingSource.Remove(unEmploye);
}
employesBindingSource.EndEdit();
try
{
monDataContext.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur lors de la suppression");
}
}
}
}
//MessageBox.Show(intEmployeQuiADesService.ToString());
// MessageBox.Show(noTypeEmploye.ToString());
/* if (intNoEmployeSelectionee.Equals(noEmployeConnecter))
* {
* MessageBox.Show("Vous ne pouvez pas supprimer l'employé courant.", "Attention!", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }
* else if (strTypeEmploySelectionee.Equals("Administrateur"))//a faire
* {
* MessageBox.Show("Vous ne pouvez pas supprimer l'administrateur", "Attention!", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }
* else
* {
*
*
*
* var employeASupprimer = from unEmploye in monDataContext.Employes
* where unEmploye.No == intNoEmployeSelectionee
* select unEmploye;
*
* if ((MessageBox.Show("Vous êtes sur le point de supprimer un employé. \nVous êtes sûr de vouloir le faire ?", "Suppression d'un employé",
* MessageBoxButtons.YesNo, MessageBoxIcon.Warning,
* MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes))
* {
* foreach (var unEmploye in employeASupprimer)
* employesBindingSource.Remove(unEmploye);
*
* employesBindingSource.EndEdit();
*
* try
* {
* monDataContext.SubmitChanges();
* }
* catch (Exception ex)
* {
* MessageBox.Show(ex.Message, "Erreur lors de la suppression");
* }
*
* }
* }*/
}
