string IntfDalUSTypeAppareil.isTypeAppareil(crlUSTypeAppareil typeAppareilObj, string typeAppareil)
{
#region declaration
string typeAppareilStr = "";
#endregion
#region implementation
if (typeAppareilObj != null && typeAppareil != "")
{
this.strCommande = "SELECT * FROM `ustypeappareil` WHERE `typeAppareil`='" + typeAppareilObj.TypeAppareil + "' AND";
this.strCommande += " `typeAppareil`<>'" + typeAppareil + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
typeAppareilStr = this.reader["typeAppareil"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(typeAppareilStr);
}
string IntfDalUSTypeAppareil.insertTypeAppareil(crlUSTypeAppareil typeAppareil)
{
#region declaration
string typeAppareilStr = "";
int nbInsert = 0;
#endregion
#region implementation
if (typeAppareil != null)
{
this.strCommande = "INSERT INTO `ustypeappareil` (`typeAppareil`)";
this.strCommande += " VALUES ('" + typeAppareil.TypeAppareil + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
typeAppareilStr = typeAppareil.TypeAppareil;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(typeAppareilStr);
}
bool IntfDalUSTypeAppareil.updateTypeAppareil(crlUSTypeAppareil typeAppareilObj, string typeAppareil)
{
#region declaration
bool isUpdate = false;
int nbUpdate = 0;
#endregion
#region impementation
if (typeAppareilObj != null && typeAppareil != "")
{
this.strCommande = "UPDATE `ustypeappareil` SET `typeAppareil`='" + typeAppareilObj.TypeAppareil + "'";
this.strCommande += " WHERE `typeAppareil`='" + typeAppareil + "'";
this.serviceConnectBase.openConnection();
nbUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nbUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isUpdate);
}
