bool IntfDalSocieteTransport.deleteSocieteTransport(crlSocieteTransport SocieteTransport)
{
#region declaration
bool isDelete = false;
int nombreDelete = 0;
#endregion
#region implementation
if (SocieteTransport != null)
{
if (SocieteTransport.NumerosSociete != "")
{
this.strCommande = "DELETE FROM `societetransport` WHERE (`numerosSociete` = '" + SocieteTransport.NumerosSociete + "')";
this.serviceConnection.openConnection();
nombreDelete = this.serviceConnection.requete(this.strCommande);
if (nombreDelete == 1)
{
isDelete = true;
}
this.serviceConnection.closeConnection();
}
}
#endregion
return(isDelete);
}
crlSocieteTransport IntfDalSocieteTransport.selectSocieteTransport(string numerosSociete)
{
#region declaration
crlSocieteTransport SocieteTransport = null;
#endregion
#region implementation
if (numerosSociete != "")
{
this.strCommande = "SELECT * FROM `societetransport`";
this.serviceConnection.openConnection();
reader = this.serviceConnection.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
if (reader.Read())
{
SocieteTransport = new crlSocieteTransport();
SocieteTransport.NomSociete = reader["nomSociete"].ToString();
SocieteTransport.NumerosSociete = reader["numerosSociete"].ToString();
}
}
reader.Dispose();
}
this.serviceConnection.closeConnection();
}
#endregion
return(SocieteTransport);
}
string IntfDalSocieteTransport.insertSocieteTransport(crlSocieteTransport SocieteTransport)
{
#region declaration
IntfDalSocieteTransport serviceSocieteTransport = new ImplDalSocieteTransport();
int nombreInsertion = 0;
string numerosSociete = "";
#endregion
#region implementation
if (SocieteTransport != null)
{
SocieteTransport.NumerosSociete = serviceSocieteTransport.getNumerosSociete();
this.strCommande = "INSERT INTO `societetransport` (`numerosSociete`,`nomSociete`) VALUES ";
this.strCommande += " ('" + SocieteTransport.NumerosSociete + "','" + SocieteTransport.NomSociete + "')";
this.serviceConnection.openConnection();
nombreInsertion = this.serviceConnection.requete(this.strCommande);
if (nombreInsertion == 1)
{
numerosSociete = SocieteTransport.NumerosSociete;
}
this.serviceConnection.closeConnection();
}
#endregion
return(numerosSociete);
}
int IntfDalSocieteTransport.isSocieteTransport(crlSocieteTransport SocieteTransport)
{
#region declaration
int isSocieteTransport = 0;
#endregion
#region implementation
if (SocieteTransport != null)
{
this.strCommande = "SELECT * FROM `societetransport` WHERE (`numerosSociete`<> '" + SocieteTransport.NumerosSociete + "')";
this.serviceConnection.openConnection();
reader = this.serviceConnection.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
while (reader.Read())
{
if (SocieteTransport.NomSociete.Trim().ToLower().Equals(reader["nomSociete"].ToString().Trim().ToLower()))
{
isSocieteTransport = 1;
break;
}
}
}
reader.Dispose();
}
this.serviceConnection.closeConnection();
}
#endregion
return(isSocieteTransport);
}
