public Bibliothecaire(String CodeBibl, Connexion con)
{
this.CodeBibl = CodeBibl;
this.con = con;
}
public Bibliothecaire(Connexion con)
{
this.con = con;
}
public Bibliothecaire(String CodeBibl, String NomBibl, String PrenomBibl, String AdresseBibl, int TelephoneBibl, String Utilisateur, String MotDePass, String Permission, Connexion con)
{
this.CodeBibl = CodeBibl;
this.NomBibl = NomBibl;
this.PrenomBibl = PrenomBibl;
this.AdresseBibl = AdresseBibl;
this.TelephoneBibl = TelephoneBibl;
this.Utilisateur = Utilisateur;
this.MotDePass = MotDePass;
this.Permission = Permission;
this.con = con;
}
int getZonNumber(string zonId)
{
c = new Connexion();
return(int.Parse(c.executer_valeur(string.Format(@"SELECT * FROM dbo.Zon WHERE [id] = '{0}'", zonId))));
}
void dataGridRefresh()
{
c = new Connexion();
dataTable = c.showDataTable(string.Format(@"SELECT * FROM dbo.Autor"));
DG_writer.DataSource = dataTable;
}
string getAutorName(string autorId)
{
c = new Connexion();
return(c.executer_valeur(string.Format(@"SELECT [autor_name] FROM Autor WHERE [aut_id] = '{0}'", autorId)));
}
public Autor()
{
c = new Connexion();
}
public Editor()
{
c = new Connexion();
}
public Login()
{
c = new Connexion();
}
public Borrow()
{
p = new Person();
b = new Books();
c = new Connexion();
}