bool IntfDalPassager.deletePassager(crlPassager Passager)
{
#region declaration
bool isDelete = false;
int nombreDelete = 0;
#endregion
#region implementation
if (Passager != null)
{
if (Passager.IdPassager != "")
{
this.strCommande = "DELETE FROM `passager` WHERE (`idPassager` = '" + Passager.IdPassager + "')";
this.serviceConnectBase.openConnection();
nombreDelete = this.serviceConnectBase.requete(this.strCommande);
if (nombreDelete == 1)
{
isDelete = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isDelete);
}
string IntfDalPassager.insertPassager(crlPassager Passager)
{
#region declaration
IntfDalPassager servicePassager = new ImplDalPassager();
int nombreInsertion = 0;
string idPassager = "";
#endregion
#region implementation
if (Passager != null)
{
Passager.IdPassager = servicePassager.getIdPassager();
this.strCommande = "INSERT INTO `passager` (`idPassager`,`nomPassager`";
this.strCommande += ",`prenomPassager`,`pieceIdentite`,`telephonePassager`)";
this.strCommande += " VALUES ('" + Passager.IdPassager + "','" + Passager.NomPassager + "'";
this.strCommande += ",'" + Passager.PrenomPassager + "','" + Passager.PieceIdentite + "'";
this.strCommande += ",'" + Passager.TelephonePassager + "')";
this.serviceConnectBase.openConnection();
nombreInsertion = this.serviceConnectBase.requete(this.strCommande);
if (nombreInsertion == 1)
{
idPassager = Passager.IdPassager;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(idPassager);
}
string IntfDalPassager.isPassager(crlPassager Passager)
{
#region declaration
string isPersonne = "";
#endregion
#region implementation
if (Passager != null)
{
this.strCommande = "SELECT * FROM `passager` WHERE (`idPassager` <> '" + Passager.IdPassager + "')";
this.serviceConnectBase.openConnection();
reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
while (reader.Read())
{
if (Passager.NomPassager.Replace(" ", "").ToLower().Equals(reader["nomPassager"].ToString().Replace(" ", "").ToLower()) &&
Passager.PrenomPassager.Replace(" ", "").ToLower().Equals(reader["prenomPassager"].ToString().Replace(" ", "").ToLower()))
{
isPersonne = reader["idPassager"].ToString();
break;
}
}
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isPersonne);
}
crlPassager IntfDalPassager.selectPassager(string idPassager)
{
#region declaration
crlPassager Passager = null;
#endregion
#region implementation
if (idPassager != "")
{
this.strCommande = "SELECT * FROM `personne` WHERE (`idPersonne` = '" + idPassager + "')";
this.serviceConnectBase.openConnection();
reader = this.serviceConnectBase.select(this.strCommande);
if (reader != null)
{
if (reader.HasRows)
{
Passager = new crlPassager();
reader.Read();
Passager.IdPassager = reader["idPassager"].ToString();
Passager.NomPassager = reader["nomPassager"].ToString();
Passager.PieceIdentite = reader["pieceIdentite"].ToString();
Passager.PrenomPassager = reader["prenomPassager"].ToString();
Passager.TelephonePassager = reader["telephonePassager"].ToString();
}
reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(Passager);
}
bool IntfDalPassager.updatePassager(crlPassager Passager)
{
#region declaration
bool isUpdate = false;
int nombreUpdate = 0;
#endregion
#region implementation
if (Passager != null)
{
if (Passager.IdPassager != "")
{
this.strCommande = "UPDATE `passager` SET `nomPassager`='" + Passager.NomPassager + "', `prenomPassager`='" + Passager.PrenomPassager + "', ";
this.strCommande += "`pieceIdentite`='" + Passager.PieceIdentite + "', `telephonePassager`='" + Passager.TelephonePassager + "' ";
this.strCommande += "WHERE (`idPassager`='" + Passager.IdPassager + "')";
this.serviceConnectBase.openConnection();
nombreUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nombreUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
}
#endregion
return(isUpdate);
}
