1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
[AuthExtension]
[SoapHeader("Authentication")]
[WebMethod]
[SoapDocumentMethod("http://www.agresso.com/france/SetPhotosEtudiants",
RequestNamespace = "http://www.agresso.com/france/", ResponseNamespace = "http://www.agresso.com/france/",
Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)]
public void SetPhotosEtudiants(Byte[] photoEtudiant,int studentPK)
{
//Requete de Maj de la photo
string query = "Update adsfileblob set blob_image=:photoParticipant where file_guid = lpad(:studentPK,32, '0')";
// Paramètres pour la reuqte
IDbDataParameter[] ParametresAdsFileBlob = {
DBUtils.BuildParameter("@photoParticipant", DbType.Binary, photoEtudiant),
DBUtils.BuildParameter("@studentPK", DbType.Int32, studentPK)
};
DBUtils.ExecuteNonQuery(query, ParametresAdsFileBlob, iConnection);
log.Error("Appel Methode WS SetPhotosEtudiants" + studentPK);
} |
Partager