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);
}
