public ResultBM UpdateVerticallDigit() { try { //TODO - debería soportar varias entidades DigitVerificatorDAL dvDal = new DigitVerificatorDAL(); UserBLL userBll = new UserBLL(); ResultBM usersBms = userBll.GetUsers(); List <DigitVeryficator> users = usersBms.GetValue <List <UserBM> >().Cast <DigitVeryficator>().ToList(); string digit = SecurityHelper.Encrypt(GetStringToCheck(users)); DigitVerificatorDTO digitDto = new DigitVerificatorDTO(USER_TABLE, digit); bool result = dvDal.UpdateEntityDigit(digitDto); if (result) { return(new ResultBM(ResultBM.Type.OK, "Dígito verificador vertical actualizado.")); } else { return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("UPDATING_ERROR"))); } } catch (Exception exception) { return(new ResultBM(ResultBM.Type.EXCEPTION, SessionHelper.GetTranslation("UPDATING_ERROR") + " " + exception.Message, exception)); } }
private DigitVerificatorDTO Resolve(List <String> item) { DigitVerificatorDTO result = new DigitVerificatorDTO(); result.entity = item[0]; result.vdv = item[1]; return(result); }
public bool UpdateEntityDigit(DigitVerificatorDTO digitDto) { DBSql dbsql = new DBSql(); String sql; sql = "UPDATE vdv SET vdv = '" + digitDto.vdv + "' WHERE entity = '" + digitDto.entity + "'"; dbsql.ExecuteNonQuery(sql); return(true); }