public bool updateMetertoBdd(CTRHTDTO infoCtr, out string msgTransaction) { msgTransaction = string.Empty; try { CTRHT _ctrHT = new CTRHT(); _ctrHT.SERIALNUMBER = infoCtr.SERIALNUMBER.Cryptage(); _ctrHT.PASSWORD_READER = infoCtr.PASSWORD_READER.Cryptage(); //_ctrHT.SERIALNUMBER = infoCtr.SERIALNUMBER; // _ctrHT.PASSWORD_READER = infoCtr.PASSWORD_READER; _ctrHT.PASSWORD_LABO = !string.IsNullOrEmpty(infoCtr.PASSWORD_LABO) ? infoCtr.PASSWORD_LABO.Cryptage() : string.Empty; //_ctrHT.PASSWORD_LABO = !string.IsNullOrEmpty(infoCtr.PASSWORD_LABO) ? infoCtr.PASSWORD_LABO : string.Empty; _ctrHT.TYPEMETER = infoCtr.TYPEMETER.Cryptage(); _ctrHT.FIRMWARE = infoCtr.FIRMWARE.Cryptage(); _ctrHT.UPDATED = true; _ctrHT.DATE_OPERATION = DateTime.Now; new DAL <CTRHT>().UpdateRow(_ctrHT, c => c.SERIALNUMBER == _ctrHT.SERIALNUMBER); return(true); } catch (Exception ex) { msgTransaction = ex.Message; } return(false); }
/// <summary> /// ajoute la ligne du fichier excel en bdd en crytant les données e /// </summary> /// <param name="infoCtr"></param> /// <param name="msgTransaction"></param> /// <returns>message derreur genéré cas echeant</returns> public bool insertMetertoBdd(CTRHTDTO infoCtr, out string msgTransaction) { msgTransaction = string.Empty; try { CTRHT _ctrHT = new CTRHT(); _ctrHT.IDLINEXCEL = Guid.NewGuid(); _ctrHT.SERIALNUMBER = infoCtr.SERIALNUMBER.Cryptage(); _ctrHT.PASSWORD_READER = infoCtr.PASSWORD_READER.Cryptage(); //---pr tests //_ctrHT.SERIALNUMBER = infoCtr.SERIALNUMBER; //_ctrHT.PASSWORD_READER = infoCtr.PASSWORD_READER; _ctrHT.PASSWORD_LABO = !string.IsNullOrEmpty(infoCtr.PASSWORD_LABO) ? infoCtr.PASSWORD_LABO.Cryptage() : string.Empty; _ctrHT.TYPEMETER = infoCtr.TYPEMETER.Cryptage(); _ctrHT.FIRMWARE = infoCtr.FIRMWARE.Cryptage(); _ctrHT.UPDATED = false; _ctrHT.DATE_OPERATION = DateTime.Now; new DAL <CTRHT>().InserRow(_ctrHT); return(true); } catch (Exception ex) { msgTransaction = ex.Message; } return(false); }