public Devis(Guid id, int statut, DateTime dateCreation, Client client, Salarie salarie) { devId = id; devStatut = statut; devDateCreation = dateCreation; devClient = client; devSalarie = salarie; }
public Devis(Guid id, int statut, DateTime dateCreation, DateTime dateSignature, DateTime dateFacture, double montantFacture, Client client, Salarie salarie) { devId = id; devStatut = statut; devDateCreation = dateCreation; devDateSignature = dateSignature; devDateFacture = dateFacture; devMontantFacture = montantFacture; devClient = client; devSalarie = salarie; }
public static Salarie GetSalarie(string id) { NpgsqlConnection conn; conn = new NpgsqlConnection(chaineConnection); conn.Open(); string query = @"SELECT id,nom,prenom,mail,tel,fonction FROM ""Salarie"" where id ='" + id + "'"; Debug.WriteLine(query); NpgsqlCommand command = new NpgsqlCommand(query, conn); NpgsqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { Salarie OneSalarie = new Salarie(new Guid(dr[0].ToString()), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[3].ToString(), Int32.Parse(dr[4].ToString())); return(OneSalarie); } conn.Close(); return(null); }
public static Boolean AjouterSalerie(Salarie monSalerie) { try { NpgsqlConnection conn; conn = new NpgsqlConnection(chaineConnection); conn.Open(); NpgsqlCommand MyCmd = null; // id, nom ,tel,numrue,codepostal,ville,pays,mail,nom rue string query = @"INSERT INTO ""Salarie"" VALUES ('" + monSalerie.salId.ToString() + "','" + monSalerie.salNom + "','" + monSalerie.salPrenom + "','" + monSalerie.salMail + "','" + monSalerie.salTel + "','" + monSalerie.salCommercial.ToString() + "')"; Debug.WriteLine(query); MyCmd = new NpgsqlCommand(query, conn); MyCmd.ExecuteNonQuery(); //Exécution conn.Close(); return(true); } catch (Exception ex) { Debug.WriteLine(ex.Message); return(false); } }
public void associerSalarie(Salarie salarie) { this.devSalarie = salarie; }