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