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;
}
